Home / Integrations / n8n / Weekly Google Trends interest over time to Google Sheets

Weekly Google Trends interest over time to Google Sheets

Up to five keywords, one row per keyword and week over the past 12 months, refreshed every Monday. Uses Google Trends Scraper.

Download workflow.json

Every Monday this workflow runs Google Trends Scraper (arcadium/google-trends) for up to five keywords and keeps a Google Sheet with one row per keyword and week: the weekly interest (0-100) over the past 12 months. Existing weeks are updated and new weeks are added, so the sheet is a ready source for a line chart or a pivot table.

Schedule (Mon 06:00) → Apify: Run actor and get dataset → Code: one row per keyword and week → Google Sheets: Append or update row

File: workflow.json (n8n workflow export format, with a sticky note that repeats the setup steps). Want only one summary row per keyword and week (average and last week) as a growing log? Use the n8n-google-trends-compare-to-google-sheets template.

What you need

Credential	Where	Placeholder in the file
Apify API token	Apify Console → Settings → API & Integrations	`REPLACE_WITH_YOUR_APIFY_CREDENTIAL_ID` (credential type Apify API)
Google Sheets	n8n's Google Sheets OAuth2 credential	`REPLACE_WITH_YOUR_GOOGLE_SHEETS_CREDENTIAL_ID`
A spreadsheet	Your Google Drive	`REPLACE_WITH_YOUR_SPREADSHEET_ID` in the sheet URL

The Apify node is Apify's official n8n node, package @apify/n8n-nodes-apify (checked against version 0.9.0, node version 2, operation Run actor and get dataset). On n8n Cloud search for "Apify" in the nodes panel. On self-hosted n8n: Settings → Community nodes → Install → @apify/n8n-nodes-apify.

Import

Create a Google Sheet with a tab named Interest and this header row (the node maps columns by name and matches rows on key):

n8n → Workflows → Import from File → workflow.json.
Get Google Trends: pick your Apify credential and edit the JSON input:
searchTerms: up to 5 keywords. compareKeywords: true puts them on one shared 0-100 scale, so 50 is half as popular as 100 within the same run.
geo: a two-letter country code, a region code (US-CA), or "" for worldwide.
timeRange: the default ("", past 12 months) gives one point per week. today 5-y also gives weekly points for 5 years.
Update Google Sheets: pick your credential and paste your sheet URL.
Execute once, check the sheet, then Activate.

Cost per run

Pay per event. Prices are the actor's Store pricing at the time of writing (Free plan; paid Apify plans pay less). The live price is on the Store page.

Event	Price	In this template
Result row (one keyword with its whole timeline)	$0.0027 ($2.70 per 1,000)	3 keywords = $0.0081
Error rows	free

Plus Apify's small start event per run. About $0.04 a month on a weekly schedule. The node caps a run at $0.20 (maxTotalChargeUsd).

What to expect

Google rescales every request (100 = the highest point of the keywords and period in that request). The workflow rewrites the whole series each week, so all values in the sheet come from the latest run and stay comparable. Do not mix in values from older runs.
The current week is still in progress: its row has partial = true and is updated next Monday.
3 keywords over 12 months give about 160 rows; Google Sheets updates them in one node run.
More than 5 keywords are chained through an anchor keyword (anchorKeyword) and the scale column then says anchor (approximate).