Bibliothek / Social-Media-Veröffentlichung
Social-Media-Veröffentlichung
Google-Sheets-Themen mit Gemini auf LinkedIn, Facebook und Bluesky veröffentlichen
Läuft werktags um 9:00 Uhr: Gemini schreibt Beiträge aus bereiten Google-Sheets-Themen, erzeugt ein Bild, und PostWire veröffentlicht alles auf LinkedIn, Facebook und Bluesky.
Was sie bewirkt
## Write LinkedIn posts with an AI image and post them from a list of topics Turn topics from Google Sheets into LinkedIn posts with their own image: every weekday Gemini writes the post, Nano Banana draws the image and PostWire publishes both on LinkedIn, Facebook and Bluesky. ### How it works 1. Every weekday at 9:00 reads the rows marked ready. Take the next topic picks the first and Mark the topic as writing claims it. 2. Write the posts with Gemini returns a LinkedIn post, a shorter Facebook and Bluesky version and the brief for the image. 3. Nano Banana image (Gemini) generates the image from that brief. 4. Post to LinkedIn, Facebook, Bluesky (PostWire) uploads the image and publishes each text on its network. 5. Mark the topic as posted writes the post links in the row. When the image or a network fails, Write the fix in the row and Email me the fix tell you what to fix. ### Setup 1. Install the verified PostWire node (search "PostWire" in the nodes panel), create an account at postwire.io, connect your networks and paste your API key into a PostWire API credential. 2. Add a Google Gemini credential to both Gemini nodes. The text fits the free tier; a Nano Banana image costs about 0.04 USD. 3. Create a sheet with the columns topic, notes, status, posted_at, links and note. Write ready in status to queue a topic, and pick the sheet in the four Sheets nodes. 4. Connect Gmail and fill in Post settings. ### Customize Change the voice and image style in Post settings, or the networks in the PostWire node (the free plan posts to 2 networks per post).
Die Schritte
- Every weekday at 9:00
- Post settings
- Read the topics
- Has a topic
- Take the next topic
- Mark the topic as writing
- Write the posts with Gemini
- Read the plan
- Nano Banana image
- Post to LinkedIn, Facebook, Bluesky
- Collect the results
- Everything published?
- Mark the topic as posted
- Write the fix in the row
Insgesamt 15 Schritte.
Ähnliche Automatisierungen
Social-Media-VeröffentlichungTop-Reddit-Threads mit OpenAI in LinkedIn-, Facebook- und Bluesky-Beiträge verwandeln15 SchritteE-Mail-AutomatisierungRewrite top Instagram posts for LinkedIn, Facebook and Bluesky with Apify and OpenAI19 SchritteE-Mail-AutomatisierungPost daily AI news commentary to LinkedIn, Bluesky and Mastodon with Gemini21 SchritteSocial-Media-VeröffentlichungBildbeitrag auf Bluesky veröffentlichen48 Schritte