Make.com is a tool that allows users to automate workflows. Instead of manually entering data, it can connect an RSS feed to Google Sheets and automatically share new content as it becomes available.
Prerequisites
An RSS.app account.
A Make.com account.
A Google Workspace account.
Step 1: Create an RSS Feed with RSS.app
1. Copy the URL of any website, social media page, or other online source you want to track.
2. Paste the URL into our RSS Generator.
If the site is highly customizable or you just want more control over what to include in the feed, try using our RSS Builder.
3. Click Generate.
4. Your RSS feed should be ready within 20 seconds. Click Save to my Feeds to save it.
Use filters to customize the content that appears in your feed. You can exclude/include posts based on keywords, add custom text, replace text, etc.
Once the feed is generated and customized, copy the XML feed URL.
Step 2: Create a new Scenario in Make.com
Now that your XML feed URL is ready, it’s time to create a scenario in Make.com.
A scenario is an automation workflow that connects apps and performs actions based on triggers.
Log into Make.com.
Click Create a new scenario.
Name your scenario (e.g., "RSS to X Automation").
Step 3: Connect your RSS feed to Make.com
Next, we’ll set up Make.com to monitor your RSS feed and trigger new posts when updates are detected.
1. In the scenario editor, click + to add a module. Search for RSS and select Watch RSS Feed Items.
2. Configure the RSS module:
RSS Feed URL: Paste your RSS feed link.
Max number of returned items: Choose how many new posts to fetch at a time (start with 5-10 to avoid timeout errors).
3. Click Save, then choose where Make.com should begin processing items (e.g., from the most recent post).
Step 4: Connect Make.com to Google Sheets
Now, we’ll set up Make.com to post content from your RSS feed to Google Sheets automatically.
1. Click the + to add another module.
2. Search for Google Sheets and select Add a Row.
3. Click on Add to link your Google account to Make.com.
4. Once connected, select the specific Spreadsheet and Sheet you want to update.
5. Map the RSS feed elements (such as title, link, publication date) to the corresponding columns in Google Sheets. For example:
Title → Column A
Link → Column B
Date → Column C
6. Click Save.
Step 5: Test your automation
Before activating the workflow, test it to ensure it works as expected. Click Run Once in the bottom left corner and verify that the posts are appearing in your Google Sheet.
Step 6: Activate your automation
Once your test runs successfully, activate the scenario to run automatically.
In Make.com, toggle the Every 15 Minutes option and adjust the schedule settings based on your needs.
The ideal automation frequency depends on your RSS.app plan and refresh rate.
Click Save. The scenario will now execute automatically at the specified intervals.