Build a weekly Google Trends report in Google Sheets with n8n (no pytrends)

Description and use

An n8n automation that weekly pulls Google Trends data for any number of keywords, computes week‑over‑week changes, and appends the results to Google Sheets.

Problem

Automating Google Trends data collection is difficult because the site limits keyword comparison to five terms and lacks an official API, making manual checks tedious.

Outcome

The workflow produces a Google Sheet with one row per keyword containing this_week, last_week, change_pct, period_avg, peak, and rising_queries, enabling easy trend charting and analysis.

Workflow

• Schedule a Monday 8:00 trigger
• HTTP Request to Apify’s Google Trends Scraper Actor with search terms, geo, timeRange, and flags
• Code node to process timeline: filter partial points, detect resolution, compute thisWeek, lastWeek, change_pct, peak, top rising queries
• Google Sheets node to append one row per keyword using automatic column mapping

Evidence

Google Trends is one of the most useful free datasets in marketing and one of the most annoying to automate. There is no official API, the website compares at most five keywords, and pytrends breaks whenever Google changes something.

Source

The Actor charges $0.003 per result. A result is one timeline, one regional breakdown or one related-queries list. Three keywords with related queries = 4 results = $0.012 per run, about $0.05 a month for a weekly report.

Source

Four nodes: Schedule (Monday 8:00) → HTTP Request (Google Trends Scraper) → Code → Google Sheets (append)

Source