Skip to main content

How to automatically add RSS feed items to Google Sheets with n8n

Learn how integrate RSS feeds and Google Sheets with n8n

Updated today

n8n is a visual workflow automation tool that connects apps, APIs, and data sources through drag-and-drop logic. You can use n8n to automatically upload new RSS feed posts to Google Sheets.

Prerequisites

Step 1: Create an RSS Feed with RSS Generator

1. Go to RSS Generator.

2. Paste the URL of the content you want to turn into a feed (e.g. a Twitter profile, subreddit, or blog).

3. Click Generate.

4. Once your feed is ready, click Save to My Feeds.

5. Copy the generated XML URL.

Step 2: Add the RSS Feed Node in n8n

1. Click Create Workflow in your n8n dashboard.

2. Click the + button and search for RSS Feed Trigger.

3. Choose how often you want n8n to check your feed for updates by setting the Poll Time.

4. Paste the RSS.app feed URL and click Fetch Test Event.

n8n will fetch the latest feed items according to your poll time.

Step 3: Add a Google Sheets Action Node

You can now define what happens when the RSS feed is read. We'll be adding a new row in Google Sheets every time a new feed item is posted.

1. Click the + button and search for Google Sheets.

2. Choose the Append or update row in sheet option.

3. Click on Credential to connect with and connect your Google account.

4. Select the document and sheet where you'd like to upload the RSS feed data.

5. Map the fields from the RSS feed to the columns:

6. Click Test Step to verify that everything works as expected.

Your Google Sheets should now be populated with information from your RSS feed:

Step 4: Activate and Check History

1. Toggle the Active button to turn on your workflow:

Once it’s active, n8n will automatically check your RSS feed for new items according to the poll interval you set. Each time new posts are found, they’ll be added to your Google Sheets file.

2. To review past runs or troubleshoot, open the Executions tab for a full history of when and how your workflow ran.

Did this answer your question?