Create local content draft ideas from RSS feeds to Google Sheets
Go to Workflow
Waleed Siddique
Description
Quick overview
A small, free n8n workflow that gives a local-service business a daily sheet of content ideas for its Google Business Profile and social posts — pulled from industry feeds you choose.
How it works
Once a day (default 8:00am), the workflow runs on a schedule.
Reads an RSS feed you pick — a supplier blog, an industry association feed, or local news.
Turns each new item into a draft row: date, headline, source, link, and a suggested angle written for a local-service business.
Saves the drafts to a Google Sheet called 'Content Drafts'. Drafts are starting points, not finished posts — you write 2–3 sentences in your own words.
Setup
Setup takes about 5 minutes: import the workflow into n8n and create a Google Sheet called 'Content Drafts'.
Add the headers Date | Headline | Source | Link | Suggested Angle | Status to the sheet.
Connect your Google account in the Sheets node, select the 'Content Drafts' spreadsheet, and replace the RSS feed URL with one relevant to your trade.
Requirements
n8n (free self-hosted or n8n Cloud) and a Google account for Sheets. No API keys, no paid services.
This workflow was created by Waleed Siddique and shared publicly on the n8n community template library. n8nFind indexes it for discovery — the workflow remains the property of its original creator.