{"product_id":"generate-linkedin-posts-with-openai-gmail-approval-sheets-tracking","title":"Generate LinkedIn Posts with OpenAI: Gmail Approval + Sheets Tracking","description":"\u003ch3\u003eTurn LinkedIn content planning into a Gmail-approved, Sheets-tracked publishing workflow—using OpenAI\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow generates LinkedIn post ideas and drafts with OpenAI, routes approvals through Gmail replies (via correlation IDs), tracks every content cycle in Google Sheets, and publishes the selected post to LinkedIn—either as a person or an organization.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eGenerate idea titles with OpenAI:\u003c\/b\u003e When started manually, it creates a numbered list of LinkedIn post idea titles for your configured niche and audience.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLog runs and notify via Gmail:\u003c\/b\u003e It records the idea batch and run settings in \u003cb\u003eGoogle Sheets\u003c\/b\u003e, then emails the ideas to your \u003cb\u003eGmail\u003c\/b\u003e inbox with a correlation ID in the subject.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003ePoll Gmail for approvals:\u003c\/b\u003e The workflow checks Gmail for unread replies containing the correlation ID, extracts the reply number, and finds the matching row in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eDraft posts at the “ideas” stage:\u003c\/b\u003e If the selected row is marked in the ideas stage, it uses OpenAI to generate multiple LinkedIn post drafts for that idea, updates Google Sheets, and emails the drafts for final approval.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003ePublish at the “drafts” stage:\u003c\/b\u003e If the row is in the drafts stage, it takes the chosen draft text and posts it to \u003cb\u003eLinkedIn\u003c\/b\u003e with public visibility as your configured person or organization.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eConfirm posting:\u003c\/b\u003e It updates Google Sheets to mark the post as posted and sends a Gmail confirmation email including a preview.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators who need consistent LinkedIn posting without manual drafting and selection.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers who want a human-in-the-loop approval flow using Gmail instead of a UI.\u003c\/li\u003e\n  \u003cli\u003eTeams tracking content status end-to-end in Google Sheets (ideas → drafts → posted).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eOpenAI\u003c\/b\u003e for idea titles and LinkedIn post drafts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGmail\u003c\/b\u003e nodes to send idea\/draft emails, poll unread replies, and confirm publication.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Sheets\u003c\/b\u003e to append idea batches and update rows during ideas\/drafts\/post stages.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLinkedIn\u003c\/b\u003e node (Community Management authentication) to publish as person or organization.\u003c\/li\u003e\n  \u003cli\u003eIncludes logic using nodes such as \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003eswitch\u003c\/b\u003e, \u003cb\u003eno op\u003c\/b\u003e, and a \u003cb\u003esticky note\u003c\/b\u003e for workflow documentation.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45741424967859,"sku":"N8N-17592","price":58.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/7ojwr4ZhueaZyOqHlwYBP_2gQ0xSJk.png?v=1785316387","url":"https:\/\/buyflowscripts.com\/products\/generate-linkedin-posts-with-openai-gmail-approval-sheets-tracking","provider":"N8N Commerce","version":"1.0","type":"link"}