Skip to content
NEWMarketplace and your team: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Social Media Publishing

Social Media Publishing

Publish Google Sheets topics to LinkedIn, Facebook, Bluesky with Gemini

Runs on weekdays at 9:00: Gemini writes posts from ready Google Sheets topics, generates an image, and PostWire publishes to LinkedIn, Facebook and Bluesky.

What it does

## 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).

The steps

  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

15 steps in total.

Similar automations