Extract Google Trends keywords & summarize articles in Google Sheets

by Miko · 19,677 views · created 2025-03-11 · Market Research, AI Summarization

What this workflow does

This workflow has 15 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets. It also calls trends.google.it over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).

1. CONFIG (Edit Fields (Set)): sets 3 fields: min_traffic, max_results, jina_key
2. Get saved keywords (Google Sheets): uses Google Sheets
3. GoogleTrends (HTTP Request): calls trends.google.it
4. XML: converts between XML and JSON
5. New keywords (Code): runs custom JavaScript code
6. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
7. Mapping (Edit Fields (Set)): sets 17 fields: summary, trending_keyword, approx_traffic…
8. content (HTTP Request): calls an HTTP API
9. If: checks a condition and branches into true / false
10. content (HTTP Request): calls an HTTP API

…plus 2 more steps. See the full node list below.

Services it uses

Google Sheets

HTTP calls to: trends.google.it

Before you upgrade to n8n 3.0

Nodes used (10)

• Manual Triggern8n-nodes-base.manualTrigger
• XMLn8n-nodes-base.xml
• HTTP Requestn8n-nodes-base.httpRequest
• Edit Fields (Set)n8n-nodes-base.set
• Google Sheetsn8n-nodes-base.googleSheets
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• Coden8n-nodes-base.code
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Ifn8n-nodes-base.if
• No Operation, do nothingn8n-nodes-base.noOp

From the author

Stay ahead of trends by automating your content research. This workflow fetches trending keywords from Google Trends RSS, extracts key insights from top articles, and saves structured summaries in Google Sheets—helping you build a data-driven editorial plan…

View the original on n8n.io → Check your own copy