智能网站漏斗分析器
中级
这是一个Market Research, AI Summarization领域的自动化工作流，包含 15 个节点。主要使用 Set, GoogleSheets, McpClientTool, Agent, ScheduleTrigger 等节点。 使用GPT-4o、Bright Data和Google Sheets分析网站转化漏斗
前置要求
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (15)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "4A25nv05Jho7qvlD",
"meta": {
"instanceId": "60046904b104f0f72b2629a9d88fe9f676be4035769f1f08dad1dd38a76b9480",
"templateCredsSetupCompleted": true
},
"name": "12 智能网站漏斗分析器",
"tags": [],
"nodes": [
{
"id": "033bde69-15e0-4518-83fb-2fa0c434e3c1",
"name": "⏰ 触发器：按计划运行",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-60,
0
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 9
}
]
}
},
"typeVersion": 1.2
},
{
"id": "f8f66218-4f7d-4fdf-9d43-1217923f8d69",
"name": "🛠️ 定义目标 URL 和上下文",
"type": "n8n-nodes-base.set",
"position": [
160,
0
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "c0317fd3-7765-4e9d-9d10-a30184a89543",
"name": "url",
"type": "string",
"value": "https://www.shopify.com"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "5aebc5c5-adf8-4bfe-9dcf-4d9dad58620d",
"name": "🤖 AI 代理：使用 MCP 抓取 URL",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
440,
0
],
"parameters": {
"text": "=Visit the given URL and extract the following information:\n\n{{ $json.url }}\n\n1. **Page Metadata**\n - Page Title\n - Meta Description\n - Canonical URL\n\n2. **Tracking/Analytics Scripts**\n - List all script `src` that match known analytics vendors (e.g. `google-analytics.com`, `gtag`, `mixpanel`, `plausible.io`, `segment.io`, `hotjar.com`, etc.)\n\n3. **CTA Buttons and Links**\n - Extract all visible `<a>` and `<button>` elements with:\n - Inner text\n - href or onclick\n - Position in viewport (if possible)\n - Filter for CTA indicators: buttons/links with text like \"Start Free Trial\", \"Sign Up\", \"Get Started\", \"Learn More\", \"Try Now\", etc.\n\n4. **Analytics Objects**\n - Try to extract any JavaScript variables that might contain tracking data:\n - `window.dataLayer`\n - `window.analytics`\n - Any `JSON.parse(...)` content embedded in `<script>` tags\n\n5. **Page Structure Overview**\n - Count and summarize the number of:\n - Headings (`h1`, `h2`, `h3`)\n - Sections (`<section>` tags)\n - Images and media elements\n\n6. **Funnel Insight Tags (Optional for Later Use)**\n - Detect if this page likely fits a funnel stage:\n - Awareness (homepage, product overview)\n - Consideration (product detail, features)\n - Conversion (CTA, checkout, pricing)\n\nEnsure that JavaScript is rendered fully and wait for the page to become idle before extracting data. Use a mobile user-agent and viewport to simulate mobile browsing behavior accurately.\n\nReturn all data in structured JSON.\n",
"options": {},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2
},
{
"id": "19c9f2ea-1faf-42c5-aa6b-cc03f200d706",
"name": "🧠 LLM 模型（指令大脑）",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
400,
260
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "8sEyPDkC5p4w4Jha",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "4458687e-613a-4a41-823d-8f7ec7e374e8",
"name": "📡 Bright Data MCP 客户端",
"type": "n8n-nodes-mcp.mcpClientTool",
"position": [
580,
260
],
"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": "92c907a5-9ecd-4299-869e-dbcf8037fb3e",
"name": "📊 将结果保存到 Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
980,
0
],
"parameters": {
"columns": {
"value": {
"images": "={{ $json.output.page_structure_overview.images }}",
"headings": "={{ $json.output.page_structure_overview.headings }}",
"sections": "={{ $json.output.page_structure_overview.sections }}",
"analytics": "={{ $json.output.analytics_objects.analytics }}",
"data layer": "={{ $json.output.analytics_objects.dataLayer }}",
"page title": "={{ $json.output.page_metadata.page_title }}",
"funnel stage": "={{ $json.output.funnel_stage }}",
"canonical url": "={{ $json.output.page_metadata.canonical_url }}",
"cta button links": "={{ $json.output.cta_buttons_links }}",
"meta description": "={{ $json.output.page_metadata.meta_description }}",
"json parsed content": "={{ $json.output.analytics_objects.json_parsed_content }}"
},
"schema": [
{
"id": "page title",
"type": "string",
"display": true,
"required": false,
"displayName": "page title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "meta description",
"type": "string",
"display": true,
"required": false,
"displayName": "meta description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "canonical url",
"type": "string",
"display": true,
"required": false,
"displayName": "canonical url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "cta button links",
"type": "string",
"display": true,
"required": false,
"displayName": "cta button links",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "data layer",
"type": "string",
"display": true,
"required": false,
"displayName": "data layer",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "analytics",
"type": "string",
"display": true,
"required": false,
"displayName": "analytics",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "json parsed content",
"type": "string",
"display": true,
"required": false,
"displayName": "json parsed content",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "headings",
"type": "string",
"display": true,
"required": false,
"displayName": "headings",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "sections",
"type": "string",
"display": true,
"required": false,
"displayName": "sections",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "images",
"type": "string",
"display": true,
"required": false,
"displayName": "images",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "funnel stage",
"type": "string",
"display": true,
"required": false,
"displayName": "funnel stage",
"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/1JbTZgfXxSddks7Sx2YVW_uf-CDC6vBQ9s0nidzzxEKs/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1JbTZgfXxSddks7Sx2YVW_uf-CDC6vBQ9s0nidzzxEKs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1JbTZgfXxSddks7Sx2YVW_uf-CDC6vBQ9s0nidzzxEKs/edit?usp=drivesdk",
"cachedResultName": "Website analytics"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "r2mDaisH6e9VkwHl",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "72c17e6e-c2f0-447e-b15c-3d974c75af85",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
-900
],
"parameters": {
"color": 6,
"width": 380,
"height": 1080,
"content": "## 🔶 **第一部分：开始和定义目标**"
},
"typeVersion": 1
},
{
"id": "307d8a0d-260d-433d-ae61-097992f35efe",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
400,
-1340
],
"parameters": {
"color": 5,
"width": 340,
"height": 1520,
"content": "## 🤖 **第二部分：通过 Bright Data MCP 进行 AI 驱动的抓取**"
},
"typeVersion": 1
},
{
"id": "b4af3b43-0daf-40be-96ab-c8f706414e14",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
880,
-600
],
"parameters": {
"color": 3,
"width": 300,
"height": 780,
"content": "## ✅ **第三部分：保存见解以供报告**"
},
"typeVersion": 1
},
{
"id": "a38a2cb0-f8e3-4892-abae-0b1f0695b328",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2080,
-900
],
"parameters": {
"color": 4,
"width": 1300,
"height": 320,
"content": "======================================="
},
"typeVersion": 1
},
{
"id": "86a27ad9-d138-489c-a7de-176bd117536e",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2080,
-560
],
"parameters": {
"color": 4,
"width": 1289,
"height": 2778,
"content": "# 📊 **工作流标题：**"
},
"typeVersion": 1
},
{
"id": "0218af59-c980-495f-9546-5992ce8f399b",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1280,
-600
],
"parameters": {
"color": 7,
"width": 380,
"height": 240,
"content": "## I’ll receive a tiny commission if you join Bright Data through this link—thanks for fueling more free content!\n\n### https://get.brightdata.com/1tndi4600b25"
},
"typeVersion": 1
},
{
"id": "7c9b3666-f32f-49ab-be38-36b3f31a8ca0",
"name": "自动修复输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserAutofixing",
"position": [
720,
260
],
"parameters": {
"options": {}
},
"typeVersion": 1
},
{
"id": "dae3494e-25b5-4394-a9ac-d4bfcf0621a2",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
680,
520
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "8sEyPDkC5p4w4Jha",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "1ab9f312-a515-4b02-9e7f-f49e0f4c6515",
"name": "多表：您可以连接多个表以实现有组织的数据结构",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
860,
520
],
"parameters": {
"jsonSchemaExample": "{\n \"page_metadata\": {\n \"page_title\": \"Shopify – Start your free trial today\",\n \"meta_description\": \"Start selling online today with Shopify. The easiest way to start an online store.\",\n \"canonical_url\": \"https://www.shopify.com\"\n },\n \"tracking_analytics_scripts\": [\n \"https://www.googletagmanager.com/\",\n \"https://www.google-analytics.com/\"\n ],\n \"cta_buttons_links\": [\n {\n \"inner_text\": \"Start for free\",\n \"href\": \"https://accounts.shopify.com/store-create?locale=en&language=en&signup%5Fpage=https%3A%2F%2Fwww.shopify.com%2F&signup%5Ftypes%5B%5D=paid%5Ftrial%5Fexperience\",\n \"position_in_viewport\": null\n },\n {\n \"inner_text\": \"Start for free\",\n \"href\": \"https://accounts.shopify.com/store-create?locale=en&language=en&signup%5Fpage=https%3A%2F%2Fwww.shopify.com%2F&signup%5Ftypes%5B%5D=paid%5Ftrial%5Fexperience\",\n \"position_in_viewport\": null\n },\n {\n \"inner_text\": \"Get started\",\n \"href\": \"/online\",\n \"position_in_viewport\": null\n }\n ],\n \"analytics_objects\": {\n \"dataLayer\": null,\n \"analytics\": null,\n \"json_parsed_content\": null\n },\n \"page_structure_overview\": {\n \"headings\": {\n \"h1\": 1,\n \"h2\": 10,\n \"h3\": 4\n },\n \"sections\": 15,\n \"images\": 20\n },\n \"funnel_stage\": \"Awareness\"\n}\n"
},
"typeVersion": 1.2
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "fd1b5014-94c4-4a9f-848b-d42272c68d4a",
"connections": {
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Auto-fixing Output Parser",
"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: Scrape URL with MCP",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"📡 Bright Data MCP Client": {
"ai_tool": [
[
{
"node": "🤖 AI Agent: Scrape URL with MCP",
"type": "ai_tool",
"index": 0
}
]
]
},
"⏰ Trigger: Run on Schedule": {
"main": [
[
{
"node": "🛠️ Define Target URL & Context",
"type": "main",
"index": 0
}
]
]
},
"🤖 AI Agent: Scrape URL with MCP": {
"main": [
[
{
"node": "📊 Save Results to Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"🧠 LLM Model (Instruction Brain)": {
"ai_languageModel": [
[
{
"node": "🤖 AI Agent: Scrape URL with MCP",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"🛠️ Define Target URL & Context": {
"main": [
[
{
"node": "🤖 AI Agent: Scrape URL with MCP",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 市场调研, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
4跟踪竞争对手网站更新
使用Bright Data MCP和OpenAI的自动竞争对手价格监控
If
Set
Google Sheets
+8
18 节点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
市场调研
竞争对手产品发布监控
基于Bright Data和OpenAI的即时竞争对手产品发布监控，发送至邮箱/表格
Set
Code
Gmail
+8
18 节点Yaron Been
市场调研
3. 活动参与者爬虫
使用 Bright Data MCP、AI 和 Google Sheets 从 10times 抓取活动数据
Set
Google Sheets
Mcp Client Tool
+6
15 节点Yaron Been
市场调研
24 项满意度评分追踪
使用 Bright Data 和 OpenAI 跨平台跟踪客户 NPS 评分
Set
Code
Google Sheets
+7
16 节点Yaron Been
市场调研
工作流信息
难度等级
中级
节点数量15
分类2
节点类型9
作者
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 查看 →
分享此工作流