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

说明与用途

一个 n8n 自动化工作流，每周提取任意数量关键词的 Google Trends 数据，计算周比周变化，并将结果追加到 Google Sheets。

问题

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.

结果

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.

工作流

• 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

证据

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.

来源

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.

来源

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

来源