Google News to Google Sheets, clean links ready
You open Google News for “a quick scan” and suddenly you’ve got 12 tabs, three duplicated stories, and no place to save the good ones. Then comes the copy-paste ritual. Title, link, date, summary. Again.
Marketing managers feel it when they need a steady stream of angles for campaigns. Agency owners feel it when clients want “fresh takes” every week. And content leads trying to keep a newsletter alive? Same headache. This Google News automation gives you a clean, deduped backlog in Google Sheets without the tab hopping.
Below you’ll see exactly how the workflow runs on a schedule, pulls articles from multiple Google News RSS queries, cleans redirect links, removes repeats, and appends only usable rows to your sheet.
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: Google News to Google Sheets, clean links ready
flowchart LR
subgraph sg0["Flow 1"]
direction LR
n0["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/itemLists.svg' width='40' height='40' /></div><br/>Item Lists: Unique by URL"]
n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/merge.svg' width='40' height='40' /></div><br/>Merge Feeds (Append)"]
n2@{ icon: "mdi:cog", form: "rounded", label: "RSS Read — Google News (TOPI..", pos: "b", h: 48 }
n3@{ icon: "mdi:cog", form: "rounded", label: "RSS Read — Google News (TOPI..", pos: "b", h: 48 }
n4@{ icon: "mdi:database", form: "rounded", label: "Append new Links", pos: "b", h: 48 }
n5@{ icon: "mdi:swap-vertical", form: "rounded", label: "Set (Clean URL + Fields)", pos: "b", h: 48 }
n6@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Filter (only complete Items)", pos: "b", h: 48 }
n7@{ icon: "mdi:cog", form: "rounded", label: "Trigger: Monday 09:00", pos: "b", h: 48 }
n1 --> n5
n7 --> n2
n7 --> n3
n5 --> n6
n0 --> n4
n6 --> n0
n3 --> n1
n2 --> n1
end
%% Styling
classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
classDef disabled stroke-dasharray: 5 5,opacity: 0.5
class n6 decision
class n4 database
classDef customIcon fill:none,stroke:none
class n0,n1 customIcon
The Problem: Google News Research Turns Into Tab Chaos
Finding interesting stories is not the hard part. Keeping them organized is. Google News is built for reading, not collecting, which means your “research” usually becomes a messy mix of open tabs, half-copied links, and a doc that nobody trusts. Even worse, Google News RSS links often arrive as redirect URLs, so you paste them into a sheet and later realize they’re ugly, inconsistent, or broken for tracking. After a few weeks, your backlog is full of repeats and blanks, and the whole thing quietly stops getting used.
It adds up fast. Here’s where it breaks down in real life.
- You spend about 10 minutes per topic just collecting links, and it never feels “done.”
- Duplicates sneak in across similar searches (like “AI” and “AI automation”), which bloats your backlog.
- Redirect URLs make downstream work annoying, especially when you want clean links for briefs, tracking, or sharing.
- People stop trusting the sheet because too many rows are missing a title, date, or usable URL.
The Solution: Scheduled Google News → Clean Google Sheet
This workflow runs on a schedule (every Monday at 09:00 by default), grabs fresh articles from multiple Google News RSS searches, and funnels everything into one tidy list. It then cleans each item so you keep the fields you actually need: title, summary, publication date, and a normalized URL (not a messy redirect link). Next, it filters out incomplete rows, deduplicates by URL, and only then appends new items into your Google Sheet. The end result is simple: a backlog that stays usable because it’s clean by default, not “cleaned later” when you finally have time.
The workflow starts with a Cron schedule and two RSS reads for different topics. Those streams get merged into one list, mapped into consistent fields, and checked for missing data. Finally, duplicates are removed and the remaining articles are appended to Google Sheets as new rows.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you track 2 topics in Google News and save 15 solid links a week. Manually, you might spend about 10 minutes per topic searching, then another 2 minutes per link to copy the title, date, and URL into a sheet. That’s roughly an hour, and honestly it’s usually more because duplicates and redirects slow you down. With this workflow, you set the RSS queries once and let Monday morning do the work. Your time becomes “review and pick winners,” not “collect and clean.”
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Google Sheets for storing cleaned links and metadata
- Google News RSS URLs to define your tracked topics
- Google credentials (connect via n8n’s Google Sheets auth)
Skill level: Beginner. You’ll paste RSS URLs, connect Google Sheets, and choose a spreadsheet + tab.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
A weekly schedule kicks things off. The workflow uses a Cron trigger set to Monday at 09:00, so new articles appear without anyone remembering to “go do research.” Change it to daily if you want a constant stream.
Google News RSS feeds are pulled in parallel. Two RSS reads fetch different searches (for example, “AI” and “AI Automation”), which means you can cover broad and niche angles at the same time.
Everything is normalized, then cleaned. The feed streams are merged into one list, the workflow maps out the fields you care about (title, summary, date, url), and it extracts a cleaner destination URL so your sheet doesn’t fill up with redirect junk.
Only “good rows” get saved. Items missing a real title or URL are filtered out, duplicates are removed by URL, and then the remaining articles are appended into Google Sheets as fresh rows.
You can easily modify the RSS topics to match your niche based on your needs. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Cron Trigger
Set the workflow to run every Monday morning and start both RSS fetches in parallel.
- Add and open the Scheduled Monday Trigger node.
- In Trigger Times, set the schedule to
everyWeekwith Hour set to9. - Connect Scheduled Monday Trigger to both Fetch News RSS Topic A and Fetch News RSS Topic B so they run at the same time.
Scheduled Monday Trigger outputs to both Fetch News RSS Topic B and Fetch News RSS Topic A in parallel.
Step 2: Connect the RSS Data Sources
Configure both RSS feeds that will be aggregated and merged.
- Open Fetch News RSS Topic A and set URL to
https://news.google.com/rss/search?q=AI&hl=de&gl=DE&ceid=DE:de. - Open Fetch News RSS Topic B and set URL to
https://news.google.com/rss/search?q=AIAutomation&hl=de&gl=DE&ceid=DE:de. - Connect both RSS nodes into Combine Feed Streams so the two feeds are merged into a single stream.
Fetch News RSS Topic A and Fetch News RSS Topic B both feed into Combine Feed Streams.
Step 3: Set Up Field Mapping and Validation
Clean the RSS fields, extract a usable URL, and filter out incomplete records.
- Open Map Clean URL Fields and enable Keep Only Set.
- Set url to
{{ $json["link"] && $json["link"].match(/[?&]url=([^&]+)/) ? decodeURIComponent($json["link"].match(/[?&]url=([^&]+)/)[1]) : ($json["link"] || $json["guid"] || "") }}. - Set title to
{{$json["title"] || ""}}. - Set summary to
{{$json["contentSnippet"] || $json["summary"] || ""}}. - Set pubDate to
{{$json["pubDate"] || $json["isoDate"] || $json["date"] || ""}}. - In Filter Complete Records, keep the two conditions that require title and url to be not empty using
{{$json["title"]}}and{{$json["url"]}}.
Combine Feed Streams → Map Clean URL Fields → Filter Complete Records ensures only clean, valid items move forward.
Step 4: Configure Deduplication and Google Sheets Output
Remove duplicate URLs before appending the final items to Google Sheets.
- Open Deduplicate URL Records and set Operation to
removeDuplicates. - Open Append Links to Sheet and set Operation to
appendOrUpdate. - Select your target Google Sheet in Document and Sheet fields.
- Credential Required: Connect your googleSheetsOAuth2Api credentials.
Filter Complete Records → Deduplicate URL Records → Append Links to Sheet completes the storage pipeline.
Step 5: Test and Activate Your Workflow
Verify that items flow from RSS to Google Sheets and then enable the schedule.
- Click Execute Workflow to run Scheduled Monday Trigger manually.
- Confirm that both Fetch News RSS Topic A and Fetch News RSS Topic B produce items and merge into Combine Feed Streams.
- Check that Append Links to Sheet appends new rows in your target sheet without duplicates.
- Toggle the workflow to Active so it runs automatically every Monday at
09:00.
Common Gotchas
- Google Sheets credentials can expire or need specific permissions. If things break, check the credential status in n8n and confirm the Google account can edit that spreadsheet.
- If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
- Google News RSS results sometimes change formatting, which can affect how redirect links are parsed. If URLs start looking messy again, review the “Map Clean URL Fields” step and adjust the extraction logic.
Frequently Asked Questions
About 20 minutes if your Google Sheets access is ready.
No. You’ll mainly paste RSS URLs and pick the target Google Sheet tab.
Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also want to consider any optional add-ons you connect later (like AI summarization), since those can add usage-based costs.
Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.
Yes, and it’s the first thing most people change. Update the Cron schedule in the “Scheduled Monday Trigger” node, then duplicate the “Fetch News RSS Topic A/B” RSS nodes for new searches. If you add more feeds, keep the merge step (“Combine Feed Streams”) so everything still lands in one list before cleaning and dedupe.
Most of the time it’s permissions. Make sure the connected Google account can edit the spreadsheet, then re-check the selected documentId and sheetName in the “Append Links to Sheet” node. If it used to work and suddenly doesn’t, your OAuth authorization may have expired, so reconnect the Google Sheets credential inside n8n.
Plenty for typical weekly research. On n8n Cloud Starter, you’re working within your monthly execution limit, so higher frequency and lots of topics can push volume up. If you self-host, there’s no execution limit (it mainly depends on your server and how many feed items you pull each run). In practice, most teams log a few dozen to a few hundred rows per week without any drama.
Often, yes, because this flow benefits from “cleanup then dedupe then append” logic that’s easier to control in n8n. You also get self-hosting as an option, which matters when you want lots of scheduled runs without worrying about task costs. Zapier or Make can still do it, but you may spend more time working around limits, especially once you add multiple RSS feeds and filters. The practical difference is maintenance: n8n tends to be calmer once it’s set up. Talk to an automation expert if you want a quick recommendation based on your volume.
Once this is running, your research backlog fills itself. You review, pick angles, and publish, while the workflow handles the repetitive collecting and cleaning.
Need Help Setting This Up?
Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.
