Scrape Google News Articles into Google Sheets
Extract news articles, publication sources, publish dates, and snippets from Google News directly into your spreadsheet with simple formulas. Monitor any topic in real time.
Use Cases
How professionals use this scraper to get real results
Media Monitoring
Track brand mentions and industry coverage across thousands of news sources. Build a real-time media dashboard in Google Sheets to stay on top of how your company or competitors appear in the press.
PR Analysis
Measure the reach and frequency of press releases and news coverage. Analyze which publications pick up your stories, track sentiment over time, and report results to stakeholders.
Industry Research
Aggregate news from your industry into a single spreadsheet to spot emerging trends, track regulatory changes, and gather competitive intelligence without visiting dozens of news sites.
Trend Analysis
Monitor how news coverage of specific topics evolves over time. Identify spikes in media attention, correlate news events with market movements, and forecast emerging narratives.
12 Data Points You Can Extract
Structured data from Google News, delivered straight to your cells
Formula Examples
Copy these formulas directly into Google Sheets
Returns the latest Google News articles matching the query "artificial intelligence" with all default data fields.
=SCRAPE_GOOGLE_NEWS("artificial intelligence")Extracts the title, publication source, publish date, and article link for recent news about Tesla into adjacent cells.
=SCRAPE_GOOGLE_NEWS("Tesla", "title,source,date,link")Scrapes German-language news about "Bundesliga" from Google News Germany, returning article titles and sources.
=SCRAPE_GOOGLE_NEWS("Bundesliga", "title,source", "de", "DE")Why Use This Scraper
Built for speed, reliability, and ease of use
Real-Time News Data
Pull the latest headlines, sources, and publish dates from Google News as they break. Your spreadsheet stays current with every refresh, giving you up-to-the-minute coverage.
Multi-Topic Monitoring
Track dozens of search queries at once by listing your topics in a column and applying the formula. Monitor brands, competitors, and industry keywords in a single sheet.
Language & Region Filters
Target news from specific countries and languages by passing region and language parameters. Get localized results from the US, UK, Germany, France, Brazil, and more.
Structured Data Extraction
Extract over 10 data points per article including title, source, date, snippet, and links. Choose exactly which fields you need to keep your spreadsheet clean and focused.
How It Works
Three steps to structured data in your spreadsheet
Install the Add-on
Install Unlimited Sheets from the Google Workspace Marketplace. Free to get started.
Set Your API Key
Add your HasData API key in the add-on settings. Get one free at hasdata.com.
Use the Formula
Type =SCRAPE_GOOGLE_NEWS() in any cell and get structured data instantly.
Built to Scrape at Any Scale
Every request passes through battle-tested infrastructure — anti-bot evasion, proxy rotation, CAPTCHA solving, and full browser rendering, all handled automatically.
Anti-Bot Bypass
Automatically evades Cloudflare, DataDome, Akamai, PerimeterX, and other bot detection systems without any extra configuration.
CAPTCHA Handling
Solves CAPTCHAs automatically in the background, so your data extraction never gets stuck waiting for human verification.
Smart Proxy Rotation
Requests are automatically routed through residential and datacenter proxies across 195+ countries. No proxy management on your end.
JavaScript Rendering
Full headless browser rendering for JavaScript-heavy sites built with React, Angular, Vue, or any other framework.
Structured JSON Output
Every response is clean, structured JSON — parsed, normalized, and ready to use. No HTML cleanup or regex needed.
Auto-Retry & Error Handling
Failed requests are automatically retried with exponential backoff. You get data or a clear error — never silent failures.
Effortless Scaling
Scale from a few requests to millions without changing your setup. 99.9% uptime backed by enterprise-grade infrastructure.
WAF & Fingerprint Bypass
Bypasses Web Application Firewalls, IP fingerprinting, and TLS fingerprinting with browser-grade request signatures.
100% Legal & Compliant
We only extract publicly available data, fully compliant with US and EU regulations. No login credentials or private data accessed.
Developer-First Support
Get help directly from the engineers who build and maintain the scrapers. No ticket queues, no outsourced call centers.
Trusted by Data Teams Worldwide
Teams at agencies, startups, and enterprises use Unlimited Sheets to extract structured data at scale.
“We replaced three different scraping tools with Unlimited Sheets. Having structured data from Amazon, Google Maps, and Zillow land directly in our spreadsheets saves our team hours every week.”
Sarah Chen
Growth Lead at DataFirst Agency
“The anti-bot bypass actually works. We were getting blocked constantly with other tools, but haven't had a single failed request in months. The proxy rotation is seamless.”
Marcus Rivera
SEO Manager at Rankify
“I track 500+ competitor prices on Amazon every day. Just a column of ASINs and SCRAPE_AMAZON — that's it. No scripts, no Python, no broken scrapers to maintain.”
Emily Park
E-Commerce Analyst at ShopMetrics
“Our real estate team pulls Zillow and Redfin listings into Sheets for market analysis. The data is always structured and ready to use — no cleanup needed.”
James Thornton
Real Estate Investor at Thornton Capital
“We use the Google Maps scraper for lead generation — pulling business names, phone numbers, and ratings directly into our CRM spreadsheet. Game changer for outbound.”
Priya Sharma
Sales Operations at LeadEngine
“The fact that it handles CAPTCHAs and JavaScript rendering under the hood is what sold me. I just write a formula and get data. No infrastructure to worry about.”
David Kim
Product Manager at Nexus Analytics
Frequently Asked Questions
How do I scrape Google News articles into Google Sheets?
Install the Unlimited Sheets add-on from the Google Workspace Marketplace, then use the =SCRAPE_GOOGLE_NEWS() formula with your search query. Articles, sources, and dates are pulled directly into your cells. No coding or API keys required.
Can I filter Google News results by language or country?
Yes. Pass the language code (e.g., "en", "de", "fr") and country code (e.g., "US", "UK", "DE") as additional parameters in the formula. This lets you target news from specific regions and get localized results.
How many Google News articles can I scrape per month?
Pro plans include 1,000 scraper credits per month and Business plans include 10,000 credits. Each news query uses one credit. You can monitor dozens of topics by listing queries in a column and applying the formula.
How often is the news data updated?
Data is fetched in real time each time the formula runs. You can trigger a refresh by recalculating your sheet or re-running the formula. Google News results update continuously, so you always get the latest articles.
Is it legal to scrape Google News data?
Scraping publicly available news headlines and metadata for personal or business analysis is a common practice. Unlimited Sheets accesses only public-facing Google News results. Always review Google's Terms of Service and consult legal advice for your specific use case.
Related Scrapers
Explore more premium scraping tools
Amazon Products Scraper
Extract real-time prices, ratings, reviews, and product details from any Amazon listing directly into your spreadsheet cells with simple formulas.
Google SERP Scraper
Extract organic results, rankings, snippets, featured answers, and more from any Google search query — directly into your spreadsheet cells with a single formula.
Instagram Profile Scraper
Extract follower counts, bios, post statistics, and profile details from any public Instagram account directly into your spreadsheet with simple formulas.
Start Scraping Google News Data Today
Install the free Google Sheets add-on, add your HasData API key, and start extracting structured data in seconds.
