Create LinkedIn, Facebook and Bluesky posts from Google Sheets with Gemini, Nano Banana and PostWire

Description

Quick Overview
This workflow runs every weekday and turns “ready” topics from Google Sheets into LinkedIn, Facebook, and Bluesky posts using Google Gemini for copy and image generation, then publishes them via PostWire and writes back post links or error notes to the sheet with a Gmail alert.

How it works
Runs every weekday at 9:00 and reads rows from Google Sheets where the status is set to ready.
Takes the first available topic and updates the row in Google Sheets to status writing to claim it.
Uses Google Gemini to generate platform-specific post text (LinkedIn, Facebook, Bluesky) plus an image prompt in JSON format.
Uses Google Gemini (image) to generate an illustration for the post from the image prompt.
Publishes the texts and generated image to LinkedIn, Facebook, and Bluesky via PostWire and collects the per-platform results.
If all platforms succeed, updates the Google Sheets row to posted with the publication timestamp and platform URLs.
If any step fails, updates the row to needs fix or partly posted with error details and sends a Gmail email with what to fix and any links that were published.

Setup
Create a PostWire account, connect your LinkedIn/Facebook/Bluesky profiles, install the PostWire node, and add your PostWire API credential in n8n.
Add Google Sheets credentials and select the target spreadsheet and sheet in each Google Sheets node.
Add a Google Gemini credential for both Gemini nodes (text and image models).
Add Gmail credentials and set the notification email address in the Post settings node.
Ensure your Google Sheet includes columns for topic, notes, status, posted_at, links, and note, and set status to ready to queue topics.