19 监控关键词排名
高级
这是一个Market Research, AI Summarization领域的自动化工作流，包含 16 个节点。主要使用 Set, Code, GoogleSheets, McpClientTool, Agent 等节点。 使用Bright Data MCP和GPT-4o AI分析跟踪SEO关键词排名
前置要求
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (16)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "FJU3f2ANp6c9kw2k",
"meta": {
"instanceId": "60046904b104f0f72b2629a9d88fe9f676be4035769f1f08dad1dd38a76b9480",
"templateCredsSetupCompleted": true
},
"name": "19 监控关键词排名",
"tags": [],
"nodes": [
{
"id": "cbb327c9-e995-49c6-b933-65d5667afb3d",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
460,
260
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "8sEyPDkC5p4w4Jha",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "fb426c60-7ab8-485d-a5c8-7343b701580c",
"name": "MCP Client",
"type": "n8n-nodes-mcp.mcpClientTool",
"position": [
640,
260
],
"parameters": {
"toolName": "search_engine",
"operation": "executeTool",
"toolParameters": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Tool_Parameters', ``, 'json') }}"
},
"credentials": {
"mcpClientApi": {
"id": "eqq94k789oJCd6jU",
"name": "MCP Client (STDIO) account"
}
},
"typeVersion": 1
},
{
"id": "de8164ef-9546-45dd-b1d2-b75f6f7e617d",
"name": "🕒 触发器：每日/每周运行",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
0,
0
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 9
}
]
}
},
"typeVersion": 1.2
},
{
"id": "53338cbc-add1-4881-80e8-35f6f86588ed",
"name": "📝 输入：关键词和域名",
"type": "n8n-nodes-base.set",
"position": [
200,
0
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "95b1399f-4709-46e0-89a9-cbf17ce9c06c",
"name": "keyword",
"type": "string",
"value": "best running shoes"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "73fecf1f-284d-403d-abe0-ee19818066e4",
"name": "🤖 SERP 抓取代理 (MCP)",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
480,
0
],
"parameters": {
"text": "=Based on the following keyword, provide me ranking of the 1st 5 website.\nkeyword: {{ $json.keyword }}",
"options": {},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2
},
{
"id": "2c635b80-4d63-46a9-90a9-7a24c4f06719",
"name": "🧠 格式化 SERP 结果",
"type": "n8n-nodes-base.code",
"position": [
960,
0
],
"parameters": {
"jsCode": "// Get the SERP list from the incoming item\nconst serpList = items[0].json.output;\n\n// Emit each result as a separate item\nreturn serpList.map(result => {\n return {\n json: result\n };\n});\n"
},
"typeVersion": 2
},
{
"id": "80cae567-a9eb-4c90-aacb-31be114960c3",
"name": "📊 记录到 Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
1180,
0
],
"parameters": {
"columns": {
"value": {
"URL": "={{ $json.url }}",
"Rank": "={{ $json.rank }}",
"Title": "={{ $json.title }}",
"Description": "={{ $json.description }}"
},
"schema": [
{
"id": "Title",
"type": "string",
"display": true,
"required": false,
"displayName": "Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URL",
"type": "string",
"display": true,
"required": false,
"displayName": "URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Description",
"type": "string",
"display": true,
"required": false,
"displayName": "Description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Rank",
"type": "string",
"display": true,
"required": false,
"displayName": "Rank",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1p64unH_JjzG978cAxPZC4kSZmoXgvYTA-Q7qdfnxr8Y/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1p64unH_JjzG978cAxPZC4kSZmoXgvYTA-Q7qdfnxr8Y",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1p64unH_JjzG978cAxPZC4kSZmoXgvYTA-Q7qdfnxr8Y/edit?usp=drivesdk",
"cachedResultName": "Website Ranking"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "r2mDaisH6e9VkwHl",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "685c2bb4-37d7-466b-b3f2-9b844298843a",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-20,
-1120
],
"parameters": {
"color": 6,
"width": 360,
"height": 1320,
"content": "## 🟦 **第一部分：输入与触发器配置**"
},
"typeVersion": 1
},
{
"id": "05accd72-2d70-47cb-8632-26e16dcbcfde",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
440,
-1080
],
"parameters": {
"color": 3,
"width": 340,
"height": 1280,
"content": "## 🟨 **第二部分：使用 AI Agent 进行智能 SERP 抓取**"
},
"typeVersion": 1
},
{
"id": "7dbd367a-a156-4ee0-b6c3-73c2414aceb7",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
920,
-900
],
"parameters": {
"color": 5,
"width": 400,
"height": 1100,
"content": "## 🟩 **第三部分：排名记录与报告**"
},
"typeVersion": 1
},
{
"id": "a9b9be2f-c21e-499d-939b-b07f0a88d4cf",
"name": "便利贴5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1420,
-900
],
"parameters": {
"color": 7,
"width": 380,
"height": 240,
"content": "## 如果您通过此链接加入 Bright Data，我将获得少量佣金 — 感谢您支持更多免费内容！"
},
"typeVersion": 1
},
{
"id": "2613a78d-33b1-4807-b363-d590c171a870",
"name": "便签 9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1680,
-1120
],
"parameters": {
"color": 4,
"width": 1300,
"height": 320,
"content": "======================================="
},
"typeVersion": 1
},
{
"id": "f425a1ba-751f-4ac6-90f4-afea94889d9c",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1680,
-780
],
"parameters": {
"color": 4,
"width": 1289,
"height": 2558,
"content": "## 🔍 **工作流：使用 AI 和 Bright Data MCP 监控关键词排名**"
},
"typeVersion": 1
},
{
"id": "aea188eb-b9af-4902-8af5-441940c392f6",
"name": "自动修复输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserAutofixing",
"position": [
760,
260
],
"parameters": {
"options": {}
},
"typeVersion": 1
},
{
"id": "6a7971dc-6694-4752-8154-cfa9e1c0c37c",
"name": "OpenAI 聊天模型1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
740,
480
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "8sEyPDkC5p4w4Jha",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "d9f0aa04-25e9-436b-9c83-067736012399",
"name": "结构化输出解析器1",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
900,
480
],
"parameters": {
"jsonSchemaExample": "[\n {\n \"rank\": 1,\n \"title\": \"Runner's World\",\n \"url\": \"https://www.runnersworld.com/gear/a19663621/best-running-shoes/\",\n \"description\": \"A comprehensive guide on the best running shoes, recommending models like Brooks Ghost and Nike Pegasus for new runners.\"\n },\n {\n \"rank\": 2,\n \"title\": \"RunRepeat\",\n \"url\": \"https://runrepeat.com/catalog/running-shoes\",\n \"description\": \"Offers running shoe reviews with ratings for various models such as Nike Pegasus 41 and Hoka Mach 6.\"\n },\n {\n \"rank\": 3,\n \"title\": \"Believe in the Run\",\n \"url\": \"https://believeintherun.com/shoe-reviews/best-running-shoes-2025/\",\n \"description\": \"Features an in-depth guide to the best running shoes of 2025 across different categories.\"\n },\n {\n \"rank\": 4,\n \"title\": \"The Run Testers\",\n \"url\": \"https://theruntesters.com/running-shoes/the-best-running-shoes-to-buy/\",\n \"description\": \"Reviews the best running shoes available, highlighting their performance and value.\"\n },\n {\n \"rank\": 5,\n \"title\": \"Men's Health\",\n \"url\": \"https://www.menshealth.com/fitness/a64476227/running-shoes-editors-picks/\",\n \"description\": \"Provides a selection of top running shoes recommended by Men's Health editors.\"\n }\n]\n"
},
"typeVersion": 1.2
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "59c58fd0-444f-4801-9b03-83ac820691d0",
"connections": {
"MCP Client": {
"ai_tool": [
[
{
"node": "🤖 SERP Scraper Agent (MCP)",
"type": "ai_tool",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "🤖 SERP Scraper Agent (MCP)",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"OpenAI Chat Model1": {
"ai_languageModel": [
[
{
"node": "Auto-fixing Output Parser",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"🧠 Format SERP Results": {
"main": [
[
{
"node": "📊 Log to Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Auto-fixing Output Parser": {
"ai_outputParser": [
[
{
"node": "🤖 SERP Scraper Agent (MCP)",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Structured Output Parser1": {
"ai_outputParser": [
[
{
"node": "Auto-fixing Output Parser",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"📝 Input: Keyword & Domain": {
"main": [
[
{
"node": "🤖 SERP Scraper Agent (MCP)",
"type": "main",
"index": 0
}
]
]
},
"🤖 SERP Scraper Agent (MCP)": {
"main": [
[
{
"node": "🧠 Format SERP Results",
"type": "main",
"index": 0
}
]
]
},
"🕒 Trigger: Run Daily/Weekly": {
"main": [
[
{
"node": "📝 Input: Keyword & Domain",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 市场调研, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
16 监控竞争对手定价
基于Bright Data MCP和Google表格的竞争对手定价自动监控
Set
Code
Gmail
+8
18 节点Yaron Been
市场调研
27 分析市场空白
使用 OpenAI 和 Bright Data 从市场空白生成 SaaS 产品创意
Set
Code
Google Sheets
+7
16 节点Yaron Been
市场调研
竞争对手产品发布监控
基于Bright Data和OpenAI的即时竞争对手产品发布监控，发送至邮箱/表格
Set
Code
Gmail
+8
18 节点Yaron Been
市场调研
24 项满意度评分追踪
使用 Bright Data 和 OpenAI 跨平台跟踪客户 NPS 评分
Set
Code
Google Sheets
+7
16 节点Yaron Been
市场调研
23 分析客户终身价值
使用GPT-4和Bright Data MCP分析与定位高价值客户
If
Set
Code
+9
20 节点Yaron Been
市场调研
智能网站漏斗分析器
使用GPT-4o、Bright Data和Google Sheets分析网站转化漏斗
Set
Google Sheets
Mcp Client Tool
+6
15 节点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 查看 →
分享此工作流