{"product_id":"n8n-workflow-auto-generate-branded-social-images-from-google-sheets","title":"n8n Workflow: Auto Generate Branded Social Images from Google Sheets","description":"\u003ch3\u003eAuto-generate branded social image PNGs from your Google Sheets topics—powered by n8n + OpenAI + Polotno\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads unprocessed topics from a Google Sheets content calendar, generates a headline and subheadline with OpenAI, renders a branded PNG using the Polotno Images API, and writes the resulting image URL back to the same row—automatically (daily at 8am) or on demand.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers manually or on a schedule:\u003c\/strong\u003e runs on demand or every morning at \u003cstrong\u003e8am\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls only the right rows:\u003c\/strong\u003e reads your Google Sheets rows and keeps items where \u003cstrong\u003eTopic\u003c\/strong\u003e is filled and \u003cstrong\u003eGenerated Image\u003c\/strong\u003e is empty.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates copy with OpenAI:\u003c\/strong\u003e sends each \u003cstrong\u003eTopic\u003c\/strong\u003e to OpenAI and expects a strict JSON response containing a \u003cstrong\u003eheadline\u003c\/strong\u003e and \u003cstrong\u003esubheadline\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRenders a branded PNG via Polotno:\u003c\/strong\u003e calls the \u003cstrong\u003ePolotno Images API\u003c\/strong\u003e to render a PNG from your template, injecting the generated copy (and an optional source image URL as a dynamic field).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eVerifies render success:\u003c\/strong\u003e checks that the Polotno render completed successfully.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites results back to Google Sheets:\u003c\/strong\u003e updates the originating row with the returned image URL, or records the \u003cstrong\u003efailed row number\u003c\/strong\u003e and \u003cstrong\u003eerror message\u003c\/strong\u003e for troubleshooting.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003ePopulate a weekly content calendar with topics and automatically produce branded social assets.\u003c\/li\u003e\n  \u003cli\u003eBatch-generate images for SaaS marketing posts without manual copywriting or design work.\u003c\/li\u003e\n  \u003cli\u003eUse a consistent Polotno template to keep brand styling uniform across all generated graphics.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets integration:\u003c\/strong\u003e reads from a specified spreadsheet\/sheet and updates rows (requires columns like \u003cem\u003eTopic\u003c\/em\u003e, \u003cem\u003eImage URL\u003c\/em\u003e, and \u003cem\u003eGenerated Image\u003c\/em\u003e, plus row number for updates).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI integration:\u003c\/strong\u003e generates headline + subheadline from each topic (e.g., model such as \u003cstrong\u003egpt-4o-mini\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePolotno Images API:\u003c\/strong\u003e renders a branded PNG from a Polotno Studio template ID using HTTP Request with \u003cstrong\u003eAuthorization: Bearer \u0026lt;your_polotno_key\u0026gt;\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic \/ nodes:\u003c\/strong\u003e uses \u003cstrong\u003eif, set, code, filter, sticky note,\u003c\/strong\u003e and \u003cstrong\u003ehttp request\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45742769209523,"sku":"N8N-17638","price":5.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/waRiR2IDf6xXhUFRqhYgu_EAWHDLWE.png?v=1785402264","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-auto-generate-branded-social-images-from-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}