Scrape Google Trends Data into Google Sheets
Pull search interest scores, related queries, trending topics, and geographic breakdowns from Google Trends into your spreadsheet. Turn search demand into actionable data with a single formula.
Use Cases
How professionals use this scraper to get real results
Trend Analysis & Forecasting
Track how search interest for keywords changes over weeks, months, or years. Identify rising trends before they peak and spot declining topics before investing resources.
Seasonal Planning
Map out seasonal demand patterns for your products or content topics. Know exactly when interest spikes each year so you can time campaigns, inventory, and content publishing.
Content Strategy
Discover what people are actively searching for and which related queries are gaining traction. Use breakout topics and rising queries to plan blog posts, videos, and social content.
Market Research
Compare search interest across product categories, brands, or geographic regions. Understand where demand is strongest and how consumer interest shifts between competing options.
8 Data Points You Can Extract
Structured data from Google Trends, delivered straight to your cells
Formula Examples
Copy these formulas directly into Google Sheets
Returns the current interest score (0-100) for "chatgpt" in the US over the past 12 months.
=SCRAPE_GOOGLE_TRENDS("chatgpt", "US", "interest_over_time", "today 12-m")Extracts the top related search queries for "yoga" worldwide over the past 3 months.
=SCRAPE_GOOGLE_TRENDS("yoga", "worldwide", "related_queries", "today 3-m")Returns a breakdown of search interest for "solar panels" by region within Germany.
=SCRAPE_GOOGLE_TRENDS("solar panels", "DE", "regional_interest", "today 12-m")Why Use This Scraper
Built for speed, reliability, and ease of use
Interest Over Time
Retrieve normalized search interest scores (0-100) for any keyword across custom date ranges. Build time-series charts directly in your spreadsheet.
Related Queries & Topics
Surface the top and rising related queries and topics that Google associates with your keyword. Uncover content ideas and audience intent you might have missed.
Geographic Breakdown
See how search interest varies by country, state, or metro area. Identify high-demand regions for targeted advertising and localized content strategies.
Flexible Date Ranges
Query data for the past hour, past day, past 7 days, past 12 months, past 5 years, or a custom date range. Analyze both real-time spikes and long-term macro trends.
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_TRENDS() 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 Trends data into Google Sheets?
Install the Unlimited Sheets add-on, then use the =SCRAPE_GOOGLE_TRENDS() formula with a search query, geo code (country or "worldwide"), data type (e.g., "interest_over_time", "related_queries"), and a date range. The trend data appears directly in your cells.
What do the Google Trends interest scores mean?
Interest scores are normalized on a scale of 0 to 100, where 100 represents the peak popularity of a term during the selected time range. A score of 50 means the term was half as popular as its peak. These are relative values, not absolute search volumes.
Can I compare multiple keywords in one sheet?
Yes. List your keywords in a column and apply the formula to each row. You can place interest scores side by side to compare trends for different topics, brands, or product categories.
Does the scraper support real-time trending data?
Yes. Use shorter date ranges like "now 1-H" (past hour) or "now 1-d" (past day) to capture real-time search spikes. This is useful for monitoring breaking news, viral events, or sudden shifts in consumer interest.
How many Google Trends queries can I run per month?
Pro plans include 1,000 scraper credits and Business plans include 10,000 credits per month. Each trends query uses one credit. You can scrape data for many keywords at once by listing them in a column and dragging the formula down.
Related Scrapers
Explore more premium scraping tools
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.
Google News Scraper
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.
Google Shopping Scraper
Extract product prices, merchant names, ratings, and availability from Google Shopping search results straight into your spreadsheet. Build price comparison dashboards in minutes.
Start Scraping Google Trends Data Today
Install the free Google Sheets add-on, add your HasData API key, and start extracting structured data in seconds.
