Summarize RSS news with Gemini AI and store in Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 21 nodes and runs on a schedule (every day at 06:00) (plus 1 other trigger). Along the way it connects Google Sheets and Google Gemini Chat Model.
How it runs
Trigger: On a schedule (every day at 06:00) (plus 1 other trigger).
- Settings (Edit Fields (Set)): sets 6 fields: Document, Articles Sheet, Today Sheet…
- Clear sheet (Google Sheets): clear
- Get RSS Feed List (Google Sheets): uses Google Sheets
- Loop Over RSS Feed (Loop Over Items (Split in Batches)): loops over the items in batches
- Filter: keeps only the items that match a condition
- Read RSS (RSS Read): reads an RSS feed
- Loop Over Rss Elements (Loop Over Items (Split in Batches)): loops over the items in batches
- Combine Rss with source name (Edit Fields (Set)): sets 1 field: RSS NAME
- Get Row for URL is in Sheets (Google Sheets): uses Google Sheets
- Check If Article Exists (If): checks a condition and branches into true / false
…plus 7 more steps. See the full node list below.
Services it uses
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)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - RSS Read
n8n-nodes-base.rssFeedRead - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Markdown
n8n-nodes-base.markdown - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Filter
n8n-nodes-base.filter - No Operation, do nothing
n8n-nodes-base.noOp - HTTP Request
n8n-nodes-base.httpRequest - HTML
n8n-nodes-base.html - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini
From the author
This workflow pulls articles from multiple RSS feeds, filters them by date, fetches the full webpage content, and summarizes each article into a clean, structured Markdown format using Google Gemini (via LangChain). Summaries are automatically saved into…