Templates / Automated RSS monitoring with Gemini AI summaries and deduplication to Google Sheets

Automated RSS monitoring with Gemini AI summaries and deduplication to Google Sheets

Ready for 3.0

by Roman Rozenberger ✓ · 4,614 views · created 2025-07-08 · Market Research, AI Summarization

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 19 nodes and runs on a schedule (every hour) (plus 1 other trigger). Along the way it connects Google Sheets and OpenRouter Chat Model.

How it runs

Trigger: On a schedule (every hour) (plus 1 other trigger).

  1. Settings (Edit Fields (Set)): sets 5 fields: Document, Articles Sheet, Rss Feeds…
  2. Get RSS Feed List (Google Sheets): uses Google Sheets
  3. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
  4. Filter: keeps only the items that match a condition
  5. Read RSS (RSS Read): reads an RSS feed
  6. Loop Over Rss Elements (Loop Over Items (Split in Batches)): loops over the items in batches
  7. Combine Rss with source name (Edit Fields (Set)): sets 1 field: RSS NAME
  8. Get Row for URL is in Sheets (Google Sheets): uses Google Sheets
  9. Check If Article Exists (If): checks a condition and branches into true / false
  10. Get Webpage HTML Content (HTTP Request): calls an HTTP API

…plus 5 more steps. See the full node list below.

Services it uses

Google SheetsOpenRouter Chat Model

Scraping pages by hand? Firecrawl is a simpler option (10% off for new users).

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (14)

From the author

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Who's it for Content creators, marketers, and researchers who need to monitor multiple RSS feeds and get AI-generated summaries without manual work. How it…

Excerpt from Roman Rozenberger's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.