{"product_id":"n8n-linkedin-post-automation-gmail-to-google-sheets-gemini","title":"n8n LinkedIn Post Automation: Gmail to Google Sheets + Gemini","description":"\u003ch3\u003eTurn Gmail ideas into automated LinkedIn posts—Gmail to Google Sheets + Google Gemini\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically captures LinkedIn post topics from new unread \u003cstrong\u003eGmail\u003c\/strong\u003e messages, logs them into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and then—using \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e—generates and publishes a formatted post to your \u003cstrong\u003eLinkedIn organization page\u003c\/strong\u003e. It also cleans up your sheet daily and sends Gmail notifications when topics are processed and when posts are published.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMinute-by-minute ingestion:\u003c\/strong\u003e Triggers every minute on new unread Gmail messages that match your configured search query.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTopic extraction + sheet logging:\u003c\/strong\u003e Extracts comma-separated topics from the email text, normalizes them, finds the next blank rows in Google Sheets, writes the topics, and sends a formatted confirmation summary via Gmail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDaily cleanup:\u003c\/strong\u003e Runs on a schedule to load all Google Sheets rows and deletes invalid\/empty rows while keeping sheet metadata consistent.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRefinement tracking:\u003c\/strong\u003e Filters topics where \u003cem\u003eREFINED\u003c\/em\u003e is not TRUE, then marks those rows as refined in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI post generation + publishing:\u003c\/strong\u003e Retrieves the first Sheets row where \u003cem\u003ePOSTED?\u003c\/em\u003e is “No” and \u003cem\u003eREFINED\u003c\/em\u003e is true. If no eligible topics exist, it stops with a Gmail alert. Otherwise, it uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e (via an AI agent prompt) to generate a formatted LinkedIn post and publishes it to the configured LinkedIn organization page.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStatus update + notification:\u003c\/strong\u003e Updates the same row with \u003cem\u003ePOSTED?=Yes\u003c\/em\u003e plus the current date\/time, then sends a Gmail notification confirming the post was published.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCollect LinkedIn content ideas by email, then publish them automatically to a LinkedIn organization page.\u003c\/li\u003e\n  \u003cli\u003eMaintain an editorial queue in Google Sheets with refinement and posted status for transparency and control.\u003c\/li\u003e\n  \u003cli\u003eRun a hands-off content pipeline for SaaS marketing or community teams using n8n automation.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAuth\/connectors: \u003cstrong\u003eGmail OAuth2\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets OAuth2\u003c\/strong\u003e, \u003cstrong\u003eLinkedIn OAuth2\u003c\/strong\u003e, and a \u003cstrong\u003eGoogle Gemini (PaLM \/ Google AI)\u003c\/strong\u003e API key.\u003c\/li\u003e\n  \u003cli\u003eWorkflow components include: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003elinked in\u003c\/strong\u003e, \u003cstrong\u003esummarize\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eRecommended setup: configure Gmail nodes (search query + recipient details) and link credentials for all integrations.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45747800506547,"sku":"N8N-17652","price":57.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/EsUi2-IqJ-l1If7mOHwcN_eHRbi6BV.png?v=1785488784","url":"https:\/\/buyflowscripts.com\/products\/n8n-linkedin-post-automation-gmail-to-google-sheets-gemini","provider":"N8N Commerce","version":"1.0","type":"link"}