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.

difficulty Beginnersetup 30 minresult A hands-off pipeline where every new RSS feed item is automatically append it as a new row to a spreadsheet in Google Sheets.
  1. 1

    Add the RSS Feed Read Trigger node

    Start with a RSS Feed Read Trigger node — paste the feed URL into the Feed URL field 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. 2

    Map the fields with a Set node

    Add a Set node after the trigger to shape the data cleanly. Create fields: title to {{ $json.title }}, link to {{ $json.link }}, and published to {{ $json.isoDate }}. This turns the raw payload into tidy values your destination can use.

  3. 3

    Send it to Google Sheets

    Add a Google Sheets node set to operation Append Row. Connect your Google account, choose the Spreadsheet and Sheet (e.g. a Log tab), 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. 4

    Activate and test

    Click Activate in 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.

About this recipe. Recipes on FlowRecipesHub are written for business owners, not developers, and are tested before publishing — how recipes get made. Some ingredient links are affiliate links that cost you nothing — full disclosure.