{"product_id":"daily-rss-to-google-sheets-content-drafts-n8n-workflow","title":"Daily RSS to Google Sheets Content Drafts (n8n Workflow)","description":"\u003ch3\u003eTurn any RSS feed into daily content drafts for Google Business Profile \u0026amp; social posts\u003c\/h3\u003e\n\u003cp\u003eThis free n8n workflow creates a daily sheet of \u003cstrong\u003econtent ideas for a local-service business\u003c\/strong\u003e by pulling new items from an RSS feed you choose, then saving them as editable drafts in Google Sheets. If you’re looking for an easy way to stay consistent with local content—without manual searching—this automation is built for you.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns once per day\u003c\/strong\u003e on a schedule (default time: 8:00am).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your selected RSS feed\u003c\/strong\u003e (for example, a supplier blog, industry association feed, or local news source).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConverts each new feed item into a draft row\u003c\/strong\u003e including: \u003cem\u003edate, headline, source, link, and a suggested angle\u003c\/em\u003e tailored to a local-service business.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaves everything to a Google Sheet\u003c\/strong\u003e named \u003cstrong\u003eContent Drafts\u003c\/strong\u003e. These are starting points—\u003cstrong\u003efinished posts are not generated\u003c\/strong\u003e; you add 2–3 sentences in your own words.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLocal service marketing\u003c\/strong\u003e: Generate weekly-ready ideas for Google Business Profile updates and social posts from industry news.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBusy operators\u003c\/strong\u003e: Keep a rolling backlog of draft topics so you never start from a blank page.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineers \u0026amp; SaaS operators\u003c\/strong\u003e: Use a simple RSS-to-Sheets pattern as a foundation for larger workflows.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow\u003c\/strong\u003e: Schedule Trigger + RSS feed read + Google Sheets write.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes used\u003c\/strong\u003e (as included in the workflow): \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003esticky note\u003c\/em\u003e, \u003cem\u003eRSS Feed Read\u003c\/em\u003e, \u003cem\u003eGoogle Sheets\u003c\/em\u003e, and \u003cem\u003eSchedule Trigger\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup\u003c\/strong\u003e: Create a Google Sheet called \u003cstrong\u003eContent Drafts\u003c\/strong\u003e and add headers: \u003cstrong\u003eDate | Headline | Source | Link | Suggested Angle | Status\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequirements\u003c\/strong\u003e: \u003cstrong\u003en8n\u003c\/strong\u003e (self-hosted or n8n Cloud) and a \u003cstrong\u003eGoogle account\u003c\/strong\u003e. No API keys and no paid services.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eImport the workflow, select your spreadsheet, replace the RSS feed URL, and start collecting daily \u003cstrong\u003econtent drafts\u003c\/strong\u003e automatically.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46244559880371,"sku":"N8N-21101","price":19.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Iq4XV5velKLrBZNhlYnJV_VnycIXDf.png?v=1792401999","url":"https:\/\/buyflowscripts.com\/products\/daily-rss-to-google-sheets-content-drafts-n8n-workflow","provider":"N8N Commerce","version":"1.0","type":"link"}