Zum Inhalt springen
NEUMarktplatz und dein Team: Verkaufe, was du baust, und bekomm Pläne und Änderungen, die getestet sind, bevor du sie siehst. Neuigkeiten ansehen

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

  1. Every weekday at 9:00
  2. Post settings
  3. Read the topics
  4. Has a topic
  5. Take the next topic
  6. Mark the topic as writing
  7. Write the posts with Gemini
  8. Read the plan
  9. Nano Banana image
  10. Post to LinkedIn, Facebook, Bluesky
  11. Collect the results
  12. Everything published?
  13. Mark the topic as posted
  14. Write the fix in the row

Insgesamt 15 Schritte.

Ähnliche Automatisierungen