Yaron Been This workflow corresponds to n8n.io template #5964 — we link there as the canonical source.
This workflow follows the Agent → Google Sheets recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "CE8hCLPGBDqK8M07",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "21 Track Local Search Trends",
"tags": [],
"nodes": [
{
"id": "9ea32a48-a56e-404a-aa0b-878a6e17f117",
"name": "\ud83d\udd0c Trigger: Manual Start",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-40,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d35de7e1-5b66-4e93-b812-dff0b195ccff",
"name": "\ud83d\udcdd Set google trends URL",
"type": "n8n-nodes-base.set",
"position": [
180,
0
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "bbb89709-875d-4064-8d35-652dc4ec0f44",
"name": "url",
"type": "string",
"value": "https://trends.google.com/trending?geo=US"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "910da821-530a-4830-ae98-a49c42346f4f",
"name": "\ud83e\udd16 Scrape Trends with MCP",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
440,
0
],
"parameters": {
"text": "=Use Bright Data MCP to scrape the following Google Trends URL and return with keywords, score, and date.\n\nURL: {{ $json.url }}",
"options": {},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2
},
{
"id": "a1be70b4-e0c6-4ab8-b4a6-d8debbbb5310",
"name": "\ud83e\udde9 Split Trends (One per Item)",
"type": "n8n-nodes-base.code",
"position": [
880,
0
],
"parameters": {
"jsCode": "// Get the Agent response\nconst input = items[0].json;\n\n// Access the trending keywords array\nconst keywords = input.output.trending_keywords;\n\n// Prepare each keyword as a single item\nreturn keywords.map(keyword => {\n return {\n json: {\n keyword: keyword.keyword,\n score: keyword.score,\n date: keyword.date\n }\n };\n});\n"
},
"typeVersion": 2
},
{
"id": "6e969c7b-276f-412f-976b-2298468eca70",
"name": "\ud83d\udcc4 Save to Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
1080,
0
],
"parameters": {
"columns": {
"value": {
"Date": "={{ $json.date }}",
"Score": "={{ $json.score }}",
"Keyword": "={{ $json.keyword }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Score",
"type": "string",
"display": true,
"required": false,
"displayName": "Score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1U3JIgUjCjjOUssjcwDcV5v5dFI_ssjzMHb9DzjtH4nU/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1U3JIgUjCjjOUssjcwDcV5v5dFI_ssjzMHb9DzjtH4nU",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1U3JIgUjCjjOUssjcwDcV5v5dFI_ssjzMHb9DzjtH4nU/edit?usp=drivesdk",
"cachedResultName": "Google trends"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.6
},
{
"id": "511ebc56-696d-4830-b119-c959e9539294",
"name": "\ud83e\udde0 OpenAI Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
400,
280
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
},
"typeVersion": 1.2
},
{
"id": "8edd4a28-ee73-4431-80b2-b4d0d2680337",
"name": "\ud83c\udf10 Bright Data MCP",
"type": "n8n-nodes-mcp.mcpClientTool",
"position": [
560,
280
],
"parameters": {
"toolName": "scrape_as_markdown",
"operation": "executeTool",
"toolParameters": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Tool_Parameters', ``, 'json') }}"
},
"credentials": {
"mcpClientApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "c00d74fc-2698-463e-8598-42a2a9a0ece9",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
-900
],
"parameters": {
"color": 6,
"width": 420,
"height": 1080,
"content": "### ## \ud83d\udfe2 **SECTION 1 \u2014 \ud83d\ude80 Trigger & Input: \u201cSet the Mission\u201d**\n\n**\u2728 Nodes in this section:**\n1\ufe0f\u20e3 **\ud83d\udd0c Trigger: Manual Start**\n2\ufe0f\u20e3 **\ud83d\udcdd Set Region & Topic**\n\n---\n\n### \ud83c\udfaf **What happens here?**\n\n* **Purpose:**\n This section is your *starting point*. It lets *you* (or anyone using this workflow) **decide when to run** it and **what you want to search for**.\n\n* **How it works:**\n\n * The **\ud83d\udd0c Trigger** node is like a *button*. When you click *Execute Workflow*, the whole process starts.\n * The **\ud83d\udcdd Input Fields** node lets you fill in details \u2014 for example:\n\n * *Region:* \u201cLos Angeles\u201d\n * *Topic:* \u201cRestaurants\u201d, \u201cConcerts\u201d, \u201cEvents near me\u201d\n * These inputs tell the Agent exactly **which local trends** to scrape.\n\n* **Benefit for beginners:**\n You don\u2019t need to open Google Trends manually or copy-paste URLs \u2014 just **set your target location & topic once**, click a button, and you\u2019re good to go! \ud83c\udf0d\u2728\n\n---\n\n---\n\n"
},
"typeVersion": 1
},
{
"id": "1a71f611-b7ce-42e1-9f91-e0281dee05ae",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
400,
-1040
],
"parameters": {
"color": 3,
"width": 340,
"height": 1220,
"content": "### ## \ud83d\udfe1 **SECTION 2 \u2014 \ud83e\udd16 Scrape Trends with Bright Data MCP**\n\n**\u2728 Nodes in this section:**\n3\ufe0f\u20e3 **\ud83e\udd16 Scrape Trends with MCP**\n\n* Sub-nodes:\n\n * \ud83e\udde0 **OpenAI Model** \u2192 Handles the Agent\u2019s logic & instructions\n * \ud83c\udf10 **Bright Data MCP** \u2192 Runs the actual scraping\n * \ud83d\uddc2\ufe0f **Structured Output Parser** \u2192 Makes sure the data comes back clean JSON\n\n---\n\n### \ud83c\udfaf **What happens here?**\n\n* **Purpose:**\n This section is the *smart engine* of your workflow. It sends your search request out to the internet, collects the latest **local trending keywords**, and puts them in a neat, structured format.\n\n* **How it works:**\n\n * The **\ud83e\udd16 Agent** takes your region & topic and talks to **Bright Data MCP** \u2014 your web scraper.\n * Bright Data crawls **Google Trends** (or another site) and finds **hot keywords**, **interest scores**, and **when they started trending**.\n * The **Structured Output Parser** makes sure the raw text is turned into tidy, machine-readable **JSON** \u2014 so you don\u2019t need to clean up messy data yourself.\n\n* **Benefit for beginners:**\n You don\u2019t have to write scraping code or build a custom parser. The Agent + Bright Data MCP do it all. It\u2019s like having a digital research assistant that never sleeps. \ud83e\uddd1\u200d\ud83d\udcbb\ud83d\udd0d\n\n---\n\n---\n\n"
},
"typeVersion": 1
},
{
"id": "420b543a-0ed0-43f0-91b3-616c3b7d9f48",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
840,
-760
],
"parameters": {
"color": 5,
"width": 400,
"height": 940,
"content": "### ## \ud83d\udfe3 **SECTION 3 \u2014 \ud83e\udde9 Process & Save: \u201cPut it to Work\u201d**\n\n**\u2728 Nodes in this section:**\n4\ufe0f\u20e3 **\ud83e\udde9 Split Trends (One per Item)**\n5\ufe0f\u20e3 **\ud83d\udcc4 Save to Google Sheets**\n\n---\n\n### \ud83c\udfaf **What happens here?**\n\n* **Purpose:**\n This section *unpacks* the scraped data and *uses* it \u2014 by saving it to your Google Sheet, ready for SEO or marketing.\n\n* **How it works:**\n\n * The **\ud83e\udde9 Code** node (your `Function`) takes the full list of keywords and **breaks them into single items** \u2014 one keyword per row.\n * The **\ud83d\udcc4 Google Sheets** node then **appends** each keyword as a new row:\n\n * Keyword\n * Search volume\n * When it started trending\n\n"
},
"typeVersion": 1
},
{
"id": "4ee00b42-8838-4ba3-8c5e-96d0b068c501",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1320,
-760
],
"parameters": {
"color": 7,
"width": 380,
"height": 240,
"content": "## I\u2019ll receive a tiny commission if you join Bright Data through this link\u2014thanks for fueling more free content!\n\n### https://get.brightdata.com/1tndi4600b25"
},
"typeVersion": 1
},
{
"id": "1397f12a-47ee-4b41-be66-2b9818abcc20",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1780,
-900
],
"parameters": {
"color": 4,
"width": 1300,
"height": 320,
"content": "=======================================\n WORKFLOW ASSISTANCE\n=======================================\nFor any questions or support, please contact:\n Yaron@nofluff.online\n\nExplore more tips and tutorials here:\n - YouTube: https://www.youtube.com/@YaronBeen/videos\n - LinkedIn: https://www.linkedin.com/in/yaronbeen/\n=======================================\n"
},
"typeVersion": 1
},
{
"id": "6d7d3cc4-67dc-45a9-9670-571190d0cefd",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1780,
-560
],
"parameters": {
"color": 4,
"width": 1289,
"height": 2958,
"content": "## \ud83c\udfaf **\ud83d\udccd Title:**\n\n**\u201cLocal Trends Scraper & SEO Booster \u2014 Automated Google Trends to Sheets Workflow\u201d**\n\n---\n\n\n### ## \ud83d\udfe2 **SECTION 1 \u2014 \ud83d\ude80 Trigger & Input: \u201cSet the Mission\u201d**\n\n**\u2728 Nodes in this section:**\n1\ufe0f\u20e3 **\ud83d\udd0c Trigger: Manual Start**\n2\ufe0f\u20e3 **\ud83d\udcdd Set Region & Topic**\n\n---\n\n### \ud83c\udfaf **What happens here?**\n\n* **Purpose:**\n This section is your *starting point*. It lets *you* (or anyone using this workflow) **decide when to run** it and **what you want to search for**.\n\n* **How it works:**\n\n * The **\ud83d\udd0c Trigger** node is like a *button*. When you click *Execute Workflow*, the whole process starts.\n * The **\ud83d\udcdd Input Fields** node lets you fill in details \u2014 for example:\n\n * *Region:* \u201cLos Angeles\u201d\n * *Topic:* \u201cRestaurants\u201d, \u201cConcerts\u201d, \u201cEvents near me\u201d\n * These inputs tell the Agent exactly **which local trends** to scrape.\n\n* **Benefit for beginners:**\n You don\u2019t need to open Google Trends manually or copy-paste URLs \u2014 just **set your target location & topic once**, click a button, and you\u2019re good to go! \ud83c\udf0d\u2728\n\n---\n\n---\n\n### ## \ud83d\udfe1 **SECTION 2 \u2014 \ud83e\udd16 Scrape Trends with Bright Data MCP**\n\n**\u2728 Nodes in this section:**\n3\ufe0f\u20e3 **\ud83e\udd16 Scrape Trends with MCP**\n\n* Sub-nodes:\n\n * \ud83e\udde0 **OpenAI Model** \u2192 Handles the Agent\u2019s logic & instructions\n * \ud83c\udf10 **Bright Data MCP** \u2192 Runs the actual scraping\n * \ud83d\uddc2\ufe0f **Structured Output Parser** \u2192 Makes sure the data comes back clean JSON\n\n---\n\n### \ud83c\udfaf **What happens here?**\n\n* **Purpose:**\n This section is the *smart engine* of your workflow. It sends your search request out to the internet, collects the latest **local trending keywords**, and puts them in a neat, structured format.\n\n* **How it works:**\n\n * The **\ud83e\udd16 Agent** takes your region & topic and talks to **Bright Data MCP** \u2014 your web scraper.\n * Bright Data crawls **Google Trends** (or another site) and finds **hot keywords**, **interest scores**, and **when they started trending**.\n * The **Structured Output Parser** makes sure the raw text is turned into tidy, machine-readable **JSON** \u2014 so you don\u2019t need to clean up messy data yourself.\n\n* **Benefit for beginners:**\n You don\u2019t have to write scraping code or build a custom parser. The Agent + Bright Data MCP do it all. It\u2019s like having a digital research assistant that never sleeps. \ud83e\uddd1\u200d\ud83d\udcbb\ud83d\udd0d\n\n---\n\n---\n\n### ## \ud83d\udfe3 **SECTION 3 \u2014 \ud83e\udde9 Process & Save: \u201cPut it to Work\u201d**\n\n**\u2728 Nodes in this section:**\n4\ufe0f\u20e3 **\ud83e\udde9 Split Trends (One per Item)**\n5\ufe0f\u20e3 **\ud83d\udcc4 Save to Google Sheets**\n\n---\n\n### \ud83c\udfaf **What happens here?**\n\n* **Purpose:**\n This section *unpacks* the scraped data and *uses* it \u2014 by saving it to your Google Sheet, ready for SEO or marketing.\n\n* **How it works:**\n\n * The **\ud83e\udde9 Code** node (your `Function`) takes the full list of keywords and **breaks them into single items** \u2014 one keyword per row.\n * The **\ud83d\udcc4 Google Sheets** node then **appends** each keyword as a new row:\n\n * Keyword\n * Search volume\n * When it started trending\n\n* **Benefit for beginners:**\n You instantly have a **ready-made spreadsheet** you can share with your content team, SEO team, or use to update your local landing pages.\n No manual copy-paste. No formatting headaches. \ud83d\udcca\u2705\n\n---\n\n---\n\n## \ud83c\udf1f **\u2728 How does this help you win?**\n\n\u2705 **Fully automated:** You can run it every day or week \u2014 always get fresh local keywords.\n\u2705 **SEO superpower:** See exactly *what\u2019s trending* in your region \u2192 update landing pages \u2192 get more local traffic.\n\u2705 **No code needed:** All you did was *click*, *input*, *watch it run*.\n\u2705 **Team-ready:** The final Google Sheet is shareable, editable, and easy to integrate with your marketing process.\n\n---\n\n## \ud83c\udf89 **\ud83d\udc8e Visual Summary**\n\n```\n\ud83d\udccc SECTION 1: \ud83d\udfe2 Trigger & Input \n \ud83d\udd0c Manual Start \u2192 \ud83d\udcdd Set Region & Topic\n\n\ud83d\udccc SECTION 2: \ud83d\udfe1 Scrape & Structure \n \ud83e\udd16 Agent \u2192 \ud83e\udde0 OpenAI \u2192 \ud83c\udf10 Bright Data \u2192 \ud83d\uddc2\ufe0f JSON Parser\n\n\ud83d\udccc SECTION 3: \ud83d\udfe3 Process & Save \n \ud83e\udde9 Split Keywords \u2192 \ud83d\udcc4 Save to Google Sheets\n```\n\n---\n\n## \u2705 **Use Case Example**\n\n> **Example:**\n> Local bakery in Los Angeles wants to know trending searches for \u201cbest cake shops\u201d or \u201cIndependence Day treats\u201d \u2192 this workflow finds hot search trends \u2192 your SEO person adds those phrases to landing pages \u2192 you rank higher locally \u2192 more customers! \ud83c\udf82\ud83c\udf86\n\n---\n\n"
},
"typeVersion": 1
},
{
"id": "e1108517-eac3-4ac9-a2a7-cac91566ce03",
"name": "Auto-fixing Output Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserAutofixing",
"position": [
720,
280
],
"parameters": {
"options": {}
},
"typeVersion": 1
},
{
"id": "6080dcb4-3ef7-41b3-bb05-b85e1e2d7737",
"name": "OpenAI Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
700,
500
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
},
"typeVersion": 1.2
},
{
"id": "4858d36d-3eca-46da-bb9a-a6f224e80f4d",
"name": "Structured Output Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
860,
500
],
"parameters": {
"jsonSchemaExample": "{\n \"trending_keywords\": [\n {\n \"keyword\": \"Julian McMahon\",\n \"score\": \"1M+ searches\",\n \"date\": \"5 hours ago\"\n },\n {\n \"keyword\": \"Camp Mystic\",\n \"score\": \"1M+ searches\",\n \"date\": \"13 hours ago\"\n },\n {\n \"keyword\": \"Palmeiras vs Chelsea\",\n \"score\": \"200K+ searches\",\n \"date\": \"8 hours ago\"\n },\n {\n \"keyword\": \"Cuatro de Julio\",\n \"score\": \"100K+ searches\",\n \"date\": \"23 hours ago\"\n },\n {\n \"keyword\": \"Independence Day Celebrations Near Me\",\n \"score\": \"100K+ searches\",\n \"date\": \"23 hours ago\"\n },\n {\n \"keyword\": \"What Time Do Fireworks Start\",\n \"score\": \"200K+ searches\",\n \"date\": \"7 hours ago\"\n },\n {\n \"keyword\": \"Astros vs Dodgers\",\n \"score\": \"50K+ searches\",\n \"date\": \"3 hours ago\"\n },\n {\n \"keyword\": \"Young Noble\",\n \"score\": \"20K+ searches\",\n \"date\": \"7 hours ago\"\n },\n {\n \"keyword\": \"Fluminense vs Al-Hilal\",\n \"score\": \"200K+ searches\",\n \"date\": \"10 hours ago\"\n },\n {\n \"keyword\": \"Brewsers vs Marlins\",\n \"score\": \"10K+ searches\",\n \"date\": \"5 hours ago\"\n }\n ]\n}\n"
},
"typeVersion": 1.2
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "a4dd65b0-e789-488c-882f-2094f0a5f1a7",
"connections": {
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Auto-fixing Output Parser",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"\ud83e\udde0 OpenAI Model": {
"ai_languageModel": [
[
{
"node": "\ud83e\udd16 Scrape Trends with MCP",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"\ud83c\udf10 Bright Data MCP": {
"ai_tool": [
[
{
"node": "\ud83e\udd16 Scrape Trends with MCP",
"type": "ai_tool",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "Auto-fixing Output Parser",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Auto-fixing Output Parser": {
"ai_outputParser": [
[
{
"node": "\ud83e\udd16 Scrape Trends with MCP",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"\ud83d\udcdd Set google trends URL": {
"main": [
[
{
"node": "\ud83e\udd16 Scrape Trends with MCP",
"type": "main",
"index": 0
}
]
]
},
"\ud83d\udd0c Trigger: Manual Start": {
"main": [
[
{
"node": "\ud83d\udcdd Set google trends URL",
"type": "main",
"index": 0
}
]
]
},
"\ud83e\udd16 Scrape Trends with MCP": {
"main": [
[
{
"node": "\ud83e\udde9 Split Trends (One per Item)",
"type": "main",
"index": 0
}
]
]
},
"\ud83e\udde9 Split Trends (One per Item)": {
"main": [
[
{
"node": "\ud83d\udcc4 Save to Google Sheets",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleSheetsOAuth2ApimcpClientApiopenAiApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This workflow contains community nodes that are only compatible with the self-hosted version of n8n.
Source: https://n8n.io/workflows/5964/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This workflow automatically monitors competitor social media engagement on LinkedIn to track their content performance and posting strategies. It saves you time by eliminating the need to manually che
Agent, N8N Nodes Mcp, Google Sheets +3
This workflow automatically identifies and tracks backlink opportunities by analyzing competitor link profiles and finding potential linking websites. It saves you time by eliminating the need to manu
OpenAI Chat, N8N Nodes Mcp, Agent +4
This workflow contains community nodes that are only compatible with the self-hosted version of n8n.
Agent, OpenAI Chat, N8N Nodes Mcp +4
This workflow contains community nodes that are only compatible with the self-hosted version of n8n.
Agent, OpenAI Chat, N8N Nodes Mcp +4
This workflow contains community nodes that are only compatible with the self-hosted version of n8n.
OpenAI Chat, Agent, N8N Nodes Mcp +4