Automate RSS Feed Updates to Google Sheets

• Automatically fetch and store news articles from RSS feeds into Google Sheets.
• Filter and manage content based on publication dates for timely updates.
• Streamline data entry tasks for content marketing and analysis.

Schedule trigger initiates the workflow at regular intervals. Read links from a Google Sheets document containing RSS feed URLs. Fetch articles from the specified RSS feeds. Filter articles based on their publication date to retain only recent entries. Format the content into Markdown for better readability. Save the filtered articles into Google Sheets for easy access and management.

1. 1
   Import the workflow template into n8n.
2. 2
   Connect your Google Sheets account to n8n.
3. 3
   Update the Google Sheets document IDs and sheet names in the workflow.
4. 4
   Specify the RSS feed URLs in the designated Google Sheets.
5. 5
   Adjust the filter settings to define how many days of articles to keep.
6. 6
   Activate the workflow to start automating the process.