{"product_id":"n8n-workflow-google-sheets-to-social-posts-with-gemini-postwire","title":"n8n Workflow: Google Sheets to Social Posts with Gemini \u0026 PostWire","description":"\u003ch3\u003eTurn “ready” Google Sheets topics into multi-platform social posts—automatically—using Google Gemini and PostWire\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every weekday to take topics marked \u003cem\u003eready\u003c\/em\u003e in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, generates platform-specific copy and images with \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e, then publishes to \u003cstrong\u003eLinkedIn\u003c\/strong\u003e, \u003cstrong\u003eFacebook\u003c\/strong\u003e, and \u003cstrong\u003eBluesky\u003c\/strong\u003e via \u003cstrong\u003ePostWire\u003c\/strong\u003e. Results (post links or error notes) are written back to your sheet, and you’ll get a Gmail alert when something needs attention.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled automation:\u003c\/strong\u003e Executes every weekday at \u003cstrong\u003e9:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClaims the next topic:\u003c\/strong\u003e Reads rows from Google Sheets where status is \u003cstrong\u003eready\u003c\/strong\u003e, picks the first available topic, and updates the row to \u003cstrong\u003ewriting\u003c\/strong\u003e to avoid duplicate processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates text + image prompt:\u003c\/strong\u003e Uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to produce post text for \u003cstrong\u003eLinkedIn\u003c\/strong\u003e, \u003cstrong\u003eFacebook\u003c\/strong\u003e, and \u003cstrong\u003eBluesky\u003c\/strong\u003e, along with an \u003cstrong\u003eimage prompt in JSON format\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates the illustration:\u003c\/strong\u003e Uses Gemini (image) to generate an illustration from the image prompt.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePublishes via PostWire:\u003c\/strong\u003e Sends the generated text and image to all configured platforms through \u003cstrong\u003ePostWire\u003c\/strong\u003e, collecting per-platform outcomes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites back status:\u003c\/strong\u003e If all platforms succeed, updates the row to \u003cstrong\u003eposted\u003c\/strong\u003e with the timestamp and platform URLs. If any step fails, marks the row as \u003cstrong\u003eneeds fix\u003c\/strong\u003e or \u003cstrong\u003epartly posted\u003c\/strong\u003e with error details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmails the fix details:\u003c\/strong\u003e Sends a \u003cstrong\u003eGmail\u003c\/strong\u003e email including what to fix and any links that were already published.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eNewsletters or content teams managing topic queues in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and publishing automatically on schedule.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators repurposing a single topic into platform-native posts with Gemini-generated copy and images.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers needing reliable status tracking, error handling, and actionable alerts for social publishing workflows.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details (n8n + integrations)\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e (text + image), \u003cstrong\u003ePostWire\u003c\/strong\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFlow control \u0026amp; data handling:\u003c\/strong\u003e nodes including \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003elimit\u003c\/strong\u003e, \u003cstrong\u003efilter\u003c\/strong\u003e, \u003cstrong\u003eaggregate\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46223937306803,"sku":"N8N-20917","price":46.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/kF7DtvTp0r28WqEFmaQCn_uFIK2gR6.png?v=1791969127","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-sheets-to-social-posts-with-gemini-postwire","provider":"N8N Commerce","version":"1.0","type":"link"}