追踪本地搜索趋势
高级
这是一个Market Research, AI Summarization领域的自动化工作流，包含 16 个节点。主要使用 Set, Code, GoogleSheets, McpClientTool, ManualTrigger 等节点。 使用Bright Data MCP和AI分析本地Google趋势搜索数据
前置要求
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (16)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "CE8hCLPGBDqK8M07",
"meta": {
"instanceId": "60046904b104f0f72b2629a9d88fe9f676be4035769f1f08dad1dd38a76b9480",
"templateCredsSetupCompleted": true
},
"name": "21 追踪本地搜索趋势",
"tags": [],
"nodes": [
{
"id": "9ea32a48-a56e-404a-aa0b-878a6e17f117",
"name": "🔌 触发器：手动启动",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-40,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d35de7e1-5b66-4e93-b812-dff0b195ccff",
"name": "📝 设置谷歌趋势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": "🤖 使用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": "🧩 拆分趋势（每项一个）",
"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": "📄 保存到 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": {
"id": "r2mDaisH6e9VkwHl",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "511ebc56-696d-4830-b119-c959e9539294",
"name": "🧠 OpenAI模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
400,
280
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "8sEyPDkC5p4w4Jha",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "8edd4a28-ee73-4431-80b2-b4d0d2680337",
"name": "🌐 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": {
"id": "eqq94k789oJCd6jU",
"name": "MCP Client (STDIO) account"
}
},
"typeVersion": 1
},
{
"id": "c00d74fc-2698-463e-8598-42a2a9a0ece9",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
-900
],
"parameters": {
"color": 6,
"width": 420,
"height": 1080,
"content": "### ## 🟢 **第1部分 — 🚀 触发器与输入：“设定任务”**"
},
"typeVersion": 1
},
{
"id": "1a71f611-b7ce-42e1-9f91-e0281dee05ae",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
400,
-1040
],
"parameters": {
"color": 3,
"width": 340,
"height": 1220,
"content": "### ## 🟡 **第2部分 — 🤖 使用Bright Data MCP抓取趋势**"
},
"typeVersion": 1
},
{
"id": "420b543a-0ed0-43f0-91b3-616c3b7d9f48",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
840,
-760
],
"parameters": {
"color": 5,
"width": 400,
"height": 940,
"content": "### ## 🟣 **第3部分 — 🧩 处理与保存：“投入使用”**"
},
"typeVersion": 1
},
{
"id": "4ee00b42-8838-4ba3-8c5e-96d0b068c501",
"name": "便利贴5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1320,
-760
],
"parameters": {
"color": 7,
"width": 380,
"height": 240,
"content": "## 如果您通过此链接加入 Bright Data，我将获得少量佣金 — 感谢您支持更多免费内容！"
},
"typeVersion": 1
},
{
"id": "1397f12a-47ee-4b41-be66-2b9818abcc20",
"name": "便签 9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1780,
-900
],
"parameters": {
"color": 4,
"width": 1300,
"height": 320,
"content": "======================================="
},
"typeVersion": 1
},
{
"id": "6d7d3cc4-67dc-45a9-9670-571190d0cefd",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1780,
-560
],
"parameters": {
"color": 4,
"width": 1289,
"height": 2958,
"content": "## 🎯 **📍 标题：**"
},
"typeVersion": 1
},
{
"id": "e1108517-eac3-4ac9-a2a7-cac91566ce03",
"name": "自动修复输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserAutofixing",
"position": [
720,
280
],
"parameters": {
"options": {}
},
"typeVersion": 1
},
{
"id": "6080dcb4-3ef7-41b3-bb05-b85e1e2d7737",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
700,
500
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "8sEyPDkC5p4w4Jha",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "4858d36d-3eca-46da-bb9a-a6f224e80f4d",
"name": "结构化输出解析器",
"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,
"pinData": {},
"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
}
]
]
},
"🧠 OpenAI Model": {
"ai_languageModel": [
[
{
"node": "🤖 Scrape Trends with MCP",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"🌐 Bright Data MCP": {
"ai_tool": [
[
{
"node": "🤖 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": "🤖 Scrape Trends with MCP",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"📝 Set google trends URL": {
"main": [
[
{
"node": "🤖 Scrape Trends with MCP",
"type": "main",
"index": 0
}
]
]
},
"🔌 Trigger: Manual Start": {
"main": [
[
{
"node": "📝 Set google trends URL",
"type": "main",
"index": 0
}
]
]
},
"🤖 Scrape Trends with MCP": {
"main": [
[
{
"node": "🧩 Split Trends (One per Item)",
"type": "main",
"index": 0
}
]
]
},
"🧩 Split Trends (One per Item)": {
"main": [
[
{
"node": "📄 Save to Google Sheets",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 市场调研, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
监控本地事件
使用 Bright Data MCP 和 OpenAI 分析自动监控本地事件
Set
Code
Google Sheets
+8
18 节点Yaron Been
市场调研
分析竞争对手反向链接
使用Bright Data MCP和GPT提取和分析竞争对手反向链接数据
Set
Code
Google Sheets
+7
16 节点Yaron Been
市场调研
35 监控竞争对手财务状况
使用Bright Data MCP、OpenAI和Google Sheets监控竞争对手财务表现
Set
Code
Gmail
+8
18 节点Yaron Been
市场调研
监控竞争对手社交媒体互动
使用Bright Data和AI监控LinkedIn竞争对手参与度与分析
Set
Code
Google Sheets
+7
19 节点Yaron Been
市场调研
从Trustpilot抓取评论
使用OpenAI和Bright Data进行Trustpilot评论情感分析并同步到Google Sheets
Set
Code
Google Sheets
+7
16 节点Yaron Been
市场调研
25收集功能请求
通过AI自动化从评论到Jira的功能请求收集与分析
Set
Code
Jira
+7
16 节点Yaron Been
市场调研
工作流信息
难度等级
高级
节点数量16
分类2
节点类型10
作者
Yaron Been
@yaron-nofluffBuilding AI Agents and Automations | Growth Marketer | Entrepreneur | Book Author & Podcast Host If you need any help with Automations, feel free to reach out via linkedin: https://www.linkedin.com/in/yaronbeen/ And check out my Youtube channel: https://www.youtube.com/@YaronBeen/videos
外部链接
在 n8n.io 查看 →
分享此工作流