Paste a Google Trends explore link into Keywords, one per line, next to
plain keywords. The run checks that view: its terms (up to 5, compared
together), location, time range, category and search type. Settings the link
leaves out use the Google Trends defaults (worldwide, past 12 months), not the
run settings. A link that compares different regions or periods, names a
topic by its id, or is not a Trends explore page becomes one INVALID_INPUT
row with the reason and is not charged.
A one-row keyword_summary for every keyword of a checked group, right after
the group's status row: direction (UP, DOWN, STABLE), change_pct
between the latest complete periods of the chart and as many periods before
them, the peak, the latest value, the top rising query and an explanation
sentence. Without a direction, summary_status says why
(INSUFFICIENT_DATA, NOT_REQUESTED, NO_DATA, SOURCE_FAILED). Built from
data the run already collected: no extra requests, no price change, and it
does not count toward a group's 250 included rows. New Keyword summary
view. Runs started in Console or by AI agents get summaries by default; API
and scheduled runs get them with the new keywordSummaries: true input. In
compact storage each summary is its own stored item, like a status row, so a
CSV export with unwind=rows keeps every column.
Status rows carry data_freshness (FRESH, CACHED, NONE) and
last_verified_at.
RUN_SUMMARY.completeness counts fresh, cached, partial, failed, not checked
and invalid groups, the oldest cache age and up to 50 groups without fresh
data. Its line is added to the end of the run's status message; the first
sentence ("N/M groups completed; ...") is unchanged. A PARTIAL group is
reported as partial.
Signal rows carry a stable event_id (monitor, query or topic, change type,
growth level). Re-reading a run or a repeated webhook gives the same ID, so a
sheet or table can upsert on it. The README shows Sheets, SQL, Python and
Node.js examples.
A ready n8n daily digest with a Google Sheets template: topics from a sheet,
one monitor run a day, Summary, Signals, Errors and Runs tabs written by
summary_id, event_id and run, and one message per run. It turns keyword
summaries on itself. The earlier "changes to Google Sheets" workflow keeps
working unchanged.