Automatically Send Every RSS Feed item to Google Sheets in Real Time
Connect RSS and Google Sheets in n8n: each new feed item is captured and sent straight to Google Sheets, in real time and completely hands-off.
- 1
Add the RSS Feed Read Trigger node
Start with a
RSS Feed Read Triggernode — paste the feed URL into theFeed URLfield and set a polling interval (e.g. every 15 minutes). The node emits each new item once. This fires the workflow the moment a new feed item arrives. - 2
Map the fields with a Set node
Add a
Setnode after the trigger to shape the data cleanly. Create fields:titleto{{ $json.title }},linkto{{ $json.link }}, andpublishedto{{ $json.isoDate }}. This turns the raw payload into tidy values your destination can use. - 3
Send it to Google Sheets
Add a
Google Sheetsnode set to operationAppend Row. Connect your Google account, choose theSpreadsheetandSheet(e.g. aLogtab), and map each field from the Set node to a matching column. Make sure row 1 of your sheet has headers with the same names. - 4
Activate and test
Click
Activatein the top-right of the canvas. Trigger a test feed item in RSS, then confirm it appears in Google Sheets. Once it works, you're done — every new feed item now flows through automatically.
Frequently asked questions
Do I need any coding skills to set this up?
No. n8n is a visual, drag-and-drop tool. You connect your RSS and Google Sheets accounts, point the nodes at the right form/sheet/channel, map the fields, and activate. No code required.
Can I send each feed item to more than one place at once?
Absolutely. Branch the workflow after the Set node: connect it to multiple destination nodes so the same feed item lands in Google Sheets and, say, Slack or a spreadsheet simultaneously.
Can I send each feed item to more than one place at once?
Absolutely. Branch the workflow after the Set node: connect it to multiple destination nodes so the same feed item lands in Google Sheets and, say, Slack or a spreadsheet simultaneously.
Keep every recipe free
FlowRecipesHub is free and always will be. If a workflow saved you time, chip in what you like — it helps us keep the lights on and build the next batch of automations for everyone.
One-tap support is being set up — check back soon. 💚
Secure checkout via Paddle · one-time, no account needed