What This Workflow Does
This automation solves the time-consuming problem of manually tracking news articles by creating a systematic pipeline from Google News to organized spreadsheet data. Instead of wasting hours browsing multiple sources, the workflow automatically collects, cleans, and structures relevant articles based on your predefined search terms.
For businesses, this means always having up-to-date market intelligence without manual effort. The workflow filters out duplicates, extracts key metadata, and formats everything for easy analysis in Google Sheets - perfect for creating dashboards, reports, or alerts when important news breaks.
How It Works
1. RSS Feed Collection
The workflow starts by pulling articles from Google News RSS feeds based on your configured search queries. You can monitor specific keywords, companies, or industry terms across all news sources or select publications.
2. Data Extraction & Cleaning
Each article's metadata is extracted, including title, source, publication date, summary, and direct link. The workflow standardizes date formats, removes HTML tags from summaries, and handles character encoding issues.
3. Deduplication Process
Before adding new entries, the system checks for existing articles with matching titles or URLs in your Google Sheet. This prevents duplicate entries from different news sources covering the same story.
4. Google Sheets Integration
Cleaned and deduplicated articles are appended to your specified Google Sheet with proper column formatting. The workflow maintains data integrity while adding new rows, preserving formulas and data validation rules.
Who This Is For
This automation is ideal for market researchers, PR professionals, competitive intelligence teams, and anyone needing systematic news monitoring. Small businesses can track their brand mentions, while investors can monitor companies in their portfolio. Content marketers use it for trend spotting and ideation.
What You'll Need
- n8n instance (cloud or self-hosted)
- Google Cloud Platform service account
- Google Sheets document with proper column headers
- Google News RSS feed URLs for your topics
Quick Setup Guide
- Download the JSON workflow file
- Import into your n8n instance
- Configure your Google News RSS feed URLs
- Connect your Google Sheets integration
- Set your preferred schedule (daily/hourly)
- Test with sample searches before going live
Key Benefits
Save 5-10 hours weekly by eliminating manual news collection and data entry tasks. The automation works around the clock without supervision.
Improve data quality with consistent formatting and automatic deduplication. Your analysis starts with clean, reliable data instead of messy manual inputs.
Never miss important news with scheduled runs that check for updates even when your team is offline. Critical developments are captured immediately.
Enable better decision-making with organized historical data for trend analysis. Spot patterns that would be invisible with ad-hoc manual monitoring.