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 of content ideas for newsletters, blogs, or social media.
What you can do with it
- 🔎 Research faster – pull in fresh articles from multiple RSS sources without manual searching.
- 🧼 Clean & normalize – extract the real article URL (instead of Google redirects), keep only the title, summary, and date.
- 🗑 No duplicates – filter out empty or repeated entries before they ever reach your sheet.
- 📊 Central storage – append all new, unique links into a Google Sheet for review or further automation.
How it works
- Trigger – Cron starts the flow every Monday at 09:00 (you can change the schedule).
- RSS Read – Fetches articles from multiple Google News queries (e.g., “AI”, “AI Automation”).
- Merge – Combines all feed results into one list.
- Set (Clean URL) – Extracts the real URL, title, summary, and publication date.
- Filter – Ensures only items with a valid title and URL continue.
- Unique by URL – Removes duplicate articles across feeds.
- Google Sheets Append – Saves new links into your chosen Sheet for review and later use.
Setup Instructions
- Import workflow into your n8n instance.
- Update RSS feeds:
- Connect Google Sheets:
- Add your Google Sheets credentials.
- Select the
documentId
(the spreadsheet) and sheetName
(the tab) in the Append new Links
node.
- Recommended columns:
date
, title
, url
, summary
.
- Adjust schedule:
- In the
Trigger: Montag 09:00
node, change the cron expression to daily or multiple times per day if you want.
- Run test:
- Execute once manually.
- Check your sheet for the first rows.
Tips & Extensions
- ✅ Add more RSS Read nodes for additional sources (blogs, media outlets, niche topics).
- ✅ Chain this workflow with an AI node (OpenAI/GPT) to automatically generate post ideas from the collected articles.
- ✅ Notify yourself in Slack/Telegram when new articles are added.
- ✅ Use a status column (
Draft
, Approved
, Posted
) to manage a simple content pipeline directly from the sheet.
👉 With this template you’ll never run out of content ideas – everything flows into one place, ready to inspire your next posts, newsletters, or campaigns.