4跟踪竞争对手网站更新
高级
这是一个Market Research, AI Summarization领域的自动化工作流，包含 18 个节点。主要使用 If, Set, GoogleSheets, McpClientTool, Agent 等节点。 使用Bright Data MCP和OpenAI的自动竞争对手价格监控
前置要求
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (18)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "mV1Dg3cHIDTFuUAG",
"meta": {
"instanceId": "60046904b104f0f72b2629a9d88fe9f676be4035769f1f08dad1dd38a76b9480",
"templateCredsSetupCompleted": true
},
"name": "4 跟踪竞争对手网站更新",
"tags": [],
"nodes": [
{
"id": "4188b754-04e5-491b-9d1e-33769030e9cb",
"name": "⏰ 触发器：检查职位列表",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
60,
0
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 9
}
]
}
},
"typeVersion": 1.2
},
{
"id": "c7e3e3a6-dfc9-4b10-b760-d223d438b303",
"name": "🛠️ 设置搜索参数",
"type": "n8n-nodes-base.set",
"position": [
260,
0
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "94a104cf-e1fb-42b2-9613-f943e04547f3",
"name": "url",
"type": "string",
"value": "https://clickup.com/pricing"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "532416b3-ae69-4b41-82f5-369e69ccc996",
"name": "🧠 OpenAI：LLM 大脑",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
700,
300
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "8sEyPDkC5p4w4Jha",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "87a06fc5-9ea9-4299-b407-dc5f108274bd",
"name": "MCP 客户端以 Markdown 格式抓取",
"type": "n8n-nodes-mcp.mcpClientTool",
"position": [
900,
300
],
"parameters": {
"toolName": "scrape_as_markdown",
"operation": "executeTool",
"toolParameters": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Tool_Parameters', ``, 'json') }}",
"descriptionType": "manual",
"toolDescription": "Scrape a single webpage URL with advanced options for content extraction and get back the results in markdown."
},
"credentials": {
"mcpClientApi": {
"id": "eqq94k789oJCd6jU",
"name": "MCP Client (STDIO) account"
}
},
"typeVersion": 1
},
{
"id": "846bfb1d-d58b-47d1-abde-131cf319c96e",
"name": "无操作，不执行任何操作",
"type": "n8n-nodes-base.noOp",
"position": [
1520,
-140
],
"parameters": {},
"typeVersion": 1
},
{
"id": "8022ef12-5026-4fbf-8af2-0e91a2f06007",
"name": "AI 代理",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
780,
0
],
"parameters": {
"text": "=Scrape Plan name and pricing from the url below\nurl: {{ $('🛠️ Set Search Parameters').item.json.url }}",
"options": {},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2
},
{
"id": "e1ec72d3-b1b3-4606-b331-061be896fe3f",
"name": "检索定价数据",
"type": "n8n-nodes-base.googleSheets",
"position": [
460,
0
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1olDNB5lFN8NGfVK8otJF2A8aYiR5jG6ve7cqwPyPXrY/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1olDNB5lFN8NGfVK8otJF2A8aYiR5jG6ve7cqwPyPXrY",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1olDNB5lFN8NGfVK8otJF2A8aYiR5jG6ve7cqwPyPXrY/edit?usp=drivesdk",
"cachedResultName": "Clickup Pricing"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "r2mDaisH6e9VkwHl",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "4cc13c60-95c0-4d3e-88c5-bd141b74935c",
"name": "如果价格变化",
"type": "n8n-nodes-base.if",
"position": [
1280,
0
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "ecde1a05-35fd-4d57-880c-dc426f38f34f",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Retrieve Pricing data').item.json['1 Pricing'] }}",
"rightValue": "={{ $('AI agent').item.json.output.plans[0].price }}"
},
{
"id": "96f46f31-2703-4f5f-9cf9-034527f19d38",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Retrieve Pricing data').item.json['2 Pricing'] }}",
"rightValue": "={{ $('AI agent').item.json.output.plans[1].price }}1"
},
{
"id": "09861d6d-6553-4d1d-9533-334b5a7c55e1",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Retrieve Pricing data').item.json['3 Pricing'] }}",
"rightValue": "={{ $('AI agent').item.json.output.plans[2].price }}"
},
{
"id": "f5a9ca6e-205a-47c3-be52-8c935f4095e7",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Retrieve Pricing data').item.json['4 Pricing'] }}",
"rightValue": "={{ $('AI agent').item.json.output.plans[3].price }}"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "c6a01b37-84e6-4cdf-9614-ca090aa843ce",
"name": "更新 Google Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
1520,
120
],
"parameters": {
"columns": {
"value": {
"1 Plan": "={{ $json.output.plans[0].plan_name }}",
"2 Plan": "={{ $json.output.plans[1].plan_name }}",
"3 Plan": "={{ $json.output.plans[2].plan_name }}",
"4 Plan": "={{ $json.output.plans[3].plan_name }}",
"1 Pricing": "={{ $json.output.plans[0].price }}",
"2 Pricing": "={{ $json.output.plans[1].price }}",
"3 Pricing": "={{ $json.output.plans[2].price }}",
"4 Pricing": "={{ $json.output.plans[3].price }}",
"row_number": "2",
"1 Key Features": "={{ $json.output.plans[0].key_features }}",
"2 Key Features": "={{ $json.output.plans[1].key_features }}",
"3 Key Features": "={{ $json.output.plans[2].key_features }}",
"4 Key Features": "={{ $json.output.plans[3].key_features }}"
},
"schema": [
{
"id": "1 Plan",
"type": "string",
"display": true,
"required": false,
"displayName": "1 Plan",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "1 Pricing",
"type": "string",
"display": true,
"required": false,
"displayName": "1 Pricing",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "1 Key Features",
"type": "string",
"display": true,
"required": false,
"displayName": "1 Key Features",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "2 Plan",
"type": "string",
"display": true,
"required": false,
"displayName": "2 Plan",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "2 Pricing",
"type": "string",
"display": true,
"required": false,
"displayName": "2 Pricing",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "2 Key Features",
"type": "string",
"display": true,
"required": false,
"displayName": "2 Key Features",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "3 Plan",
"type": "string",
"display": true,
"required": false,
"displayName": "3 Plan",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "3 Pricing",
"type": "string",
"display": true,
"required": false,
"displayName": "3 Pricing",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "3 Key Features",
"type": "string",
"display": true,
"required": false,
"displayName": "3 Key Features",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "4 Plan",
"type": "string",
"display": true,
"required": false,
"displayName": "4 Plan",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "4 Pricing",
"type": "string",
"display": true,
"required": false,
"displayName": "4 Pricing",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "4 Key Features",
"type": "string",
"display": true,
"required": false,
"displayName": "4 Key Features",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1olDNB5lFN8NGfVK8otJF2A8aYiR5jG6ve7cqwPyPXrY/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1olDNB5lFN8NGfVK8otJF2A8aYiR5jG6ve7cqwPyPXrY",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1olDNB5lFN8NGfVK8otJF2A8aYiR5jG6ve7cqwPyPXrY/edit?usp=drivesdk",
"cachedResultName": "Clickup Pricing"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "r2mDaisH6e9VkwHl",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "0bc8b647-8aaf-447c-aefd-b819219b7327",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
20,
-1260
],
"parameters": {
"color": 6,
"width": 580,
"height": 1440,
"content": "## 🧩 **第1部分：设置与历史数据获取**"
},
"typeVersion": 1
},
{
"id": "c52243c8-4e6a-4011-ba0c-cc980b3b8f7d",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
700,
-920
],
"parameters": {
"color": 2,
"width": 400,
"height": 1100,
"content": "## 🤖 **第2部分：AI 代理抓取定价**"
},
"typeVersion": 1
},
{
"id": "1d9ae3ab-13e3-43d0-a33c-6deab25cdb82",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1240,
-1240
],
"parameters": {
"color": 3,
"width": 440,
"height": 1520,
"content": "## 🔄 **第3部分：比较、决策与更新**"
},
"typeVersion": 1
},
{
"id": "6c257ba0-74ad-4b80-ac49-c8ca92de931b",
"name": "便签 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1760,
-1240
],
"parameters": {
"color": 7,
"width": 380,
"height": 240,
"content": "## 如果您通过此链接加入 Bright Data，我将获得少量佣金——感谢您支持更多免费内容！"
},
"typeVersion": 1
},
{
"id": "4ba2638f-0995-477b-8031-d34423041e93",
"name": "### 替换 Airtable 连接",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1640,
-1260
],
"parameters": {
"color": 4,
"width": 1300,
"height": 320,
"content": "======================================="
},
"typeVersion": 1
},
{
"id": "b0e2647e-9bf5-4dd4-8114-863dc2f9ba1a",
"name": "便签 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1640,
-920
],
"parameters": {
"color": 4,
"width": 1289,
"height": 3198,
"content": "## 🚀 **自动跟踪 ClickUp 定价变化**"
},
"typeVersion": 1
},
{
"id": "b25022dc-2a54-4738-9720-230af526fa5d",
"name": "自动修复输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserAutofixing",
"position": [
1060,
300
],
"parameters": {
"options": {}
},
"typeVersion": 1
},
{
"id": "0f5ff62f-d358-4031-a2a7-f771e0d6fe81",
"name": "OpenAI Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
1000,
560
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "8sEyPDkC5p4w4Jha",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "44a40a39-67c1-4445-9b8b-f5dcda67ed99",
"name": "Structured Output Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
1180,
560
],
"parameters": {
"jsonSchemaExample": "{\n \"plans\": [\n {\n \"plan_name\": \"Free Forever\",\n \"price\": \"Free\",\n \"key_features\": [\n \"60MB Storage\",\n \"Unlimited Tasks\",\n \"Unlimited Free Plan Members\",\n \"Two-Factor Authentication\",\n \"Collaborative Docs\",\n \"Kanban Boards\",\n \"Sprint Management\",\n \"Calendar View\",\n \"Custom Field Manager Basic\",\n \"In-App Video Recording\",\n \"24/7 Support\",\n \"1 Form\"\n ]\n },\n {\n \"plan_name\": \"Unlimited\",\n \"price\": \"$7 per user per month\",\n \"key_features\": [\n \"Everything in Free Forever plus\",\n \"2GB Storage per user\",\n \"Unlimited Folders and Spaces\",\n \"Unlimited Integrations\",\n \"Unlimited Gantt Charts\",\n \"Unlimited Custom Fields\",\n \"Unlimited Chat Messages\",\n \"Unlimited Forms\",\n \"Guests with Permissions\",\n \"Email in ClickUp\",\n \"3 Teams (User Group)\",\n \"Native Time Tracking\",\n \"Goals & Portfolios\",\n \"Resource Management\",\n \"AI Compatible\"\n ]\n },\n {\n \"plan_name\": \"Business\",\n \"price\": \"$12 per user per month\",\n \"key_features\": [\n \"Everything in Unlimited, plus\",\n \"Google SSO\",\n \"Unlimited Storage\",\n \"Unlimited Teams\",\n \"Unlimited Message History\",\n \"Unlimited Mind Maps\",\n \"Unlimited Activity views\",\n \"Unlimited Timeline views\",\n \"Unlimited Dashboards\",\n \"Unlimited Whiteboards\",\n \"Sprint Points & Reporting\",\n \"Automation Integrations\",\n \"Custom Exporting\",\n \"Private Whiteboards\",\n \"Workload Management\",\n \"SMS 2-Factor Authentication\",\n \"More Automations\"\n ]\n },\n {\n \"plan_name\": \"Enterprise\",\n \"price\": \"Custom pricing\",\n \"key_features\": [\n \"Everything in Business, plus\",\n \"White Labeling\",\n \"Conditional Logic in Forms\",\n \"Team Sharing for Spaces\",\n \"Custom Roles\",\n \"Custom Capacity in Workload\",\n \"Enterprise API\",\n \"Unlimited Posts\",\n \"Default Personal Views\",\n \"Advanced Permissions\",\n \"Advanced Public Sharing\",\n \"MSA & HIPPA Available\",\n \"Single Sign-On (SSO)\",\n \"SCIM Provisioning\",\n \"US, EU, & APAC Data Residency\",\n \"Live Onboarding Training\",\n \"Customer Success Manager\",\n \"Access to Managed Services\"\n ]\n }\n ]\n}\n"
},
"typeVersion": 1.2
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "d26222dc-4c8c-46da-9a8f-5a7977d940e2",
"connections": {
"AI agent": {
"main": [
[
{
"node": "If price changes",
"type": "main",
"index": 0
}
]
]
},
"If price changes": {
"main": [
[
{
"node": "No Operation, do nothing",
"type": "main",
"index": 0
}
],
[
{
"node": "Update google sheet",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Auto-fixing Output Parser",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Retrieve Pricing data": {
"main": [
[
{
"node": "AI agent",
"type": "main",
"index": 0
}
]
]
},
"🧠 OpenAI: LLM Brain": {
"ai_languageModel": [
[
{
"node": "AI agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "Auto-fixing Output Parser",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Auto-fixing Output Parser": {
"ai_outputParser": [
[
{
"node": "AI agent",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"🛠️ Set Search Parameters": {
"main": [
[
{
"node": "Retrieve Pricing data",
"type": "main",
"index": 0
}
]
]
},
"⏰ Trigger: Check Job Listings": {
"main": [
[
{
"node": "🛠️ Set Search Parameters",
"type": "main",
"index": 0
}
]
]
},
"MCP Client to Scrape as markdown": {
"ai_tool": [
[
{
"node": "AI agent",
"type": "ai_tool",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 市场调研, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
23 分析客户终身价值
使用GPT-4和Bright Data MCP分析与定位高价值客户
If
Set
Code
+9
20 节点Yaron Been
市场调研
11 监控社交媒体广告表现
使用 Bright Data MCP 监控社交媒体广告表现并发送告警
If
Set
Code
+9
19 节点Yaron Been
市场调研
15 个追踪反向链接机会
使用 Bright Data MCP 和 GPT-4o 追踪并分析反向链接机会
If
Set
Gmail
+9
19 节点Yaron Been
市场调研
智能网站漏斗分析器
使用GPT-4o、Bright Data和Google Sheets分析网站转化漏斗
Set
Google Sheets
Mcp Client Tool
+6
15 节点Yaron Been
市场调研
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
市场调研
工作流信息
难度等级
高级
节点数量18
分类2
节点类型11
作者
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 查看 →
分享此工作流