Automatically collect & process Google News articles to Google Sheets
Needs changesNeeds changes. This template uses 2 thing(s) that n8n 3.0 removes: Item Lists (legacy), Cron. 2 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 8 nodes and runs on a schedule (legacy Cron node). Along the way it connects Google Sheets.
How it runs
Trigger: On a schedule (legacy Cron node).
- RSS Read: reads an RSS feed
- RSS Read: reads an RSS feed
- Merge: merges the data from its input branches
- Set (Clean URL + Fields) (Edit Fields (Set)): sets or maps fields
- Filter: keeps only the items that match a condition
- Item Lists: reshapes item lists (legacy Item Lists node)
- Append new Links (Google Sheets): append or update
Services it uses
Before you upgrade to n8n 3.0
2 things in this workflow are removed in n8n 3.0. Fix them before you upgrade:
- Item Lists (legacy) in Item Lists: Unique by URL: replace with Split Out, Aggregate, Sort, Limit, Remove Duplicates or Summarize (match the operation used).
- Cron in Trigger: Monday 09:00: replace with Schedule Trigger.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Item Lists (legacy) Item Lists: Unique by URL | Split Out, Aggregate, Sort, Limit, Remove Duplicates or Summarize (match the operation used) |
| Cron Trigger: Monday 09:00 | Schedule Trigger |
Nodes used (7)
- Item Lists
n8n-nodes-base.itemLists - Merge
n8n-nodes-base.merge - RSS Read
n8n-nodes-base.rssFeedRead - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - Filter
n8n-nodes-base.filter - Cron
n8n-nodes-base.cron
From the author
Overview This workflow automatically collects the latest articles from Google News RSS feeds, cleans and deduplicates them, and stores them neatly in a Google Sheet. It runs on a set schedule (every Monday at 09:00 by default) and helps you build a fresh pool…