{"product_id":"n8n-rss-to-linkedin-post-automation-openai-gmail-sheets","title":"n8n RSS to LinkedIn Post Automation: OpenAI, Gmail \u0026 Sheets","description":"\u003ch3\u003eAutomatically turn RSS news into a polished LinkedIn post—then get your approval before it publishes\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads daily RSS headlines, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to draft a new \u003cstrong\u003eLinkedIn post in Brazilian Portuguese\u003c\/strong\u003e, finds a matching image via \u003cstrong\u003ePexels\u003c\/strong\u003e, and emails you a ready-to-post version for approval. Only after you approve will it publish to your LinkedIn profile and log the result in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 08:00\u003c\/strong\u003e (schedule is configurable in n8n).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your recent post history\u003c\/strong\u003e from Google Sheets to provide context and avoid repeating topics.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches the latest RSS items\u003c\/strong\u003e from a predefined list of RSS feeds.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a LinkedIn post with OpenAI\u003c\/strong\u003e: sends RSS headlines\/summaries to OpenAI and receives a \u003cem\u003estructured JSON\u003c\/em\u003e output (e.g., topic, post text, theme, and a source link).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSelects a relevant image from Pexels\u003c\/strong\u003e by querying the Pexels API using the generated theme\/topic and retrieving an image URL.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmails you a draft for approval via Gmail\u003c\/strong\u003e, including the post and image link.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSupports an approval\/rewrite loop\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eIf you request a rewrite, your feedback is sent back to OpenAI to surgically edit the post.\u003c\/li\u003e\n      \u003cli\u003eThen it re-parses the JSON output and asks for approval again.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePublishes after approval\u003c\/strong\u003e: downloads the selected image, uploads it to LinkedIn, posts to your profile, and \u003cstrong\u003elogs the outcome\u003c\/strong\u003e (or logs rejection) in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eConsistently publishing on LinkedIn using current industry news without manual drafting.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators who want a daily content pipeline with human approval to maintain tone and accuracy.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building an RSS-to-social workflow with OpenAI + review gates.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/integrations\u003c\/strong\u003e called out in this workflow: \u003cem\u003eCode\u003c\/em\u003e, \u003cem\u003eRSS Feed Read\u003c\/em\u003e, \u003cem\u003eOpenAI\u003c\/em\u003e, \u003cem\u003eHTTP Request\u003c\/em\u003e, \u003cem\u003ePexels\u003c\/em\u003e, \u003cem\u003eGmail\u003c\/em\u003e, \u003cem\u003eSwitch\u003c\/em\u003e, and supportive nodes like \u003cem\u003eSticky Note\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003eRequires credentials for \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eOpenAI\u003c\/strong\u003e, and \u003cstrong\u003eGmail\u003c\/strong\u003e, plus the Google Sheets document ID and sheet name used for reading history and logging outcomes.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45923081322675,"sku":"N8N-18869","price":45.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/a1g7V8YRYri0Wq-spY-0y_6mKvPWPA.png?v=1788167956","url":"https:\/\/buyflowscripts.com\/products\/n8n-rss-to-linkedin-post-automation-openai-gmail-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}