{"product_id":"linkedin-post-generator-n8n-workflow-ai-drafts-to-google-sheets","title":"LinkedIn Post Generator n8n Workflow: AI Drafts to Google Sheets","description":"\u003ch3\u003eTurn one idea into a daily LinkedIn post—automatically\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003eLinkedIn Post Generator n8n workflow\u003c\/strong\u003e uses AI to draft your LinkedIn captions and generate a matching image, stores everything in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, and then publishes \u003cstrong\u003eone approved post per day\u003c\/strong\u003e to your \u003cstrong\u003eLinkedIn organization page\u003c\/strong\u003e—with \u003cstrong\u003eGmail alerts\u003c\/strong\u003e if anything fails.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled or manual run\u003c\/strong\u003e to pull previous post ideas from a Google Sheets sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI drafting with Anthropic (Claude)\u003c\/strong\u003e: combines past ideas to generate a new post package (including \u003cstrong\u003ename, idea, title, text, and image description\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI image creation\u003c\/strong\u003e: downloads a reference image from \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, sends it with the new \u003cstrong\u003eimage description\u003c\/strong\u003e to \u003cstrong\u003eOpenAI’s Images API\u003c\/strong\u003e, and produces a styled visual.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReview pipeline\u003c\/strong\u003e: saves the generated image to Google Drive and appends the post content plus an \u003cstrong\u003eimage link\u003c\/strong\u003e to Google Sheets with status \u003cstrong\u003e“review”\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSecond scheduled run\u003c\/strong\u003e selects a post marked \u003cstrong\u003e“ready”\u003c\/strong\u003e and publishes it (text + image) to a \u003cstrong\u003eLinkedIn organization page\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStatus updates\u003c\/strong\u003e: after publishing, updates the row status to \u003cstrong\u003e“posted”\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eError handling\u003c\/strong\u003e: if any step errors, sends a \u003cstrong\u003eGmail notification\u003c\/strong\u003e with detailed error information.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS teams that want consistent \u003cstrong\u003eLinkedIn organization\u003c\/strong\u003e posting without manual drafting.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers running an AI + approvals workflow using \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e as the control panel.\u003c\/li\u003e\n  \u003cli\u003eFounders who generate post ideas in bulk, approve via “ready”, and publish one per day.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCredentials required\u003c\/strong\u003e: Google Sheets, Google Drive, Anthropic, LinkedIn, Gmail, plus an \u003cstrong\u003eOpenAI HTTP Header Auth\u003c\/strong\u003e credential (OpenAI API key).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSheet requirements\u003c\/strong\u003e: columns for \u003cstrong\u003ename, idea, text, image, status\u003c\/strong\u003e using \u003cstrong\u003ereview\u003c\/strong\u003e, \u003cstrong\u003eready\u003c\/strong\u003e, and \u003cstrong\u003eposted\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/steps\u003c\/strong\u003e include set, code, wait, gmail, limit, and twitter (as reflected in the workflow build).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46066365366451,"sku":"N8N-19744","price":69.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/VKqAK9d8wRMaln9C0ECyO_NKdIxqIp.png?v=1789895157","url":"https:\/\/buyflowscripts.com\/products\/linkedin-post-generator-n8n-workflow-ai-drafts-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}