跨平台追踪品牌提及
中级
这是一个Market Research, AI Summarization领域的自动化工作流，包含 15 个节点。主要使用 Set, GoogleSheets, McpClientTool, ManualTrigger, Agent 等节点。 使用 Bright Data 和 OpenAI 进行品牌提及跟踪与情感分析
前置要求
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (15)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "Kw6CPl5oArWJBG0E",
"meta": {
"instanceId": "c38e3b8a7e4240e6cdca062743f016c1029f385bf40345b6291939dfd83bfd77",
"templateCredsSetupCompleted": true
},
"name": "跨平台追踪品牌提及",
"tags": [],
"nodes": [
{
"id": "6f0fed2a-cd9b-472e-b541-321c4e43f12b",
"name": "🚀 启动工作流（手动触发）",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-340,
-80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c9195c44-551e-440e-a191-80801c17cbbb",
"name": "📝 定义Medium博客URL",
"type": "n8n-nodes-base.set",
"position": [
-120,
-80
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "5ce0f046-dd35-47d3-96a1-845a179f7949",
"name": "blogURL",
"type": "string",
"value": "https://medium.com/gitconnected/why-openai-suddenly-erased-jony-ive-from-their-website-5d6f431e5297"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "00f42b47-ced0-4d28-919b-6b1f9b05e210",
"name": "🤖 代理：抓取Medium博客（OpenAI提及）",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
180,
-80
],
"parameters": {
"text": "=scrape the below medium blog URL and do setimant analysis:\n{{ $json.blogURL }}",
"options": {},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2
},
{
"id": "c15a7aa3-4ec6-442b-859d-db32655ec08e",
"name": "🧠 聊天推理引擎",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
140,
140
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "kmqnyfHdWfA8k1KC",
"name": "OpenAi account 3"
}
},
"typeVersion": 1.2
},
{
"id": "2948ad8b-b41b-4405-98e8-7af70cf4cbde",
"name": "🌐 Bright Data工具",
"type": "n8n-nodes-mcp.mcpClientTool",
"position": [
300,
220
],
"parameters": {
"toolName": "scrape_as_markdown",
"operation": "executeTool",
"toolParameters": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Tool_Parameters', ``, 'json') }}"
},
"credentials": {
"mcpClientApi": {
"id": "dGu6Ys11ijXSTxcV",
"name": "MCP Client (STDIO) account"
}
},
"typeVersion": 1
},
{
"id": "0dec0fe8-a2db-4862-b3f5-243d059066c5",
"name": "📥 保存结果到Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
760,
-80
],
"parameters": {
"columns": {
"value": {
"URL": "={{ $('📝 Define Medium Blog URL').item.json.blogURL }}",
"Title": "={{ $json.output.title }}",
"Author": "={{ $json.output.author }}",
"Platform": "={{ $json.output.platform }}",
"Sentiment": "={{ $json.output.sentiment }}",
"Content Summary": "={{ $json.output['content summary'] }}"
},
"schema": [
{
"id": "URL",
"type": "string",
"display": true,
"required": false,
"displayName": "URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Platform",
"type": "string",
"display": true,
"required": false,
"displayName": "Platform",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Author",
"type": "string",
"display": true,
"required": false,
"displayName": "Author",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Title",
"type": "string",
"display": true,
"required": false,
"displayName": "Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Content Summary",
"type": "string",
"display": true,
"required": false,
"displayName": "Content Summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Sentiment",
"type": "string",
"display": true,
"required": false,
"displayName": "Sentiment",
"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/1XxLjaMa4vLqSV6bf0Fq1vreOJX6Os_uUCW0PrUK3UWE/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1XxLjaMa4vLqSV6bf0Fq1vreOJX6Os_uUCW0PrUK3UWE",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1XxLjaMa4vLqSV6bf0Fq1vreOJX6Os_uUCW0PrUK3UWE/edit?usp=drivesdk",
"cachedResultName": "brand sentiment analysis"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "i899RBJ6SKiYYWwx",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "ccc265dd-b894-4f2c-87d9-13e704ede0f8",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-380,
-820
],
"parameters": {
"color": 6,
"width": 420,
"height": 960,
"content": "## 🔹 第一部分：启动工作流并提供输入"
},
"typeVersion": 1
},
{
"id": "77163aaf-9a40-42b5-86ce-81933f8de5aa",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
100,
-980
],
"parameters": {
"width": 460,
"height": 1400,
"content": "## 🤖 第二部分：AI代理获取和筛选内容"
},
"typeVersion": 1
},
{
"id": "a291820d-69b5-450a-a588-d4ef3a75090d",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
640,
-740
],
"parameters": {
"color": 3,
"width": 360,
"height": 860,
"content": "## 📊 第三部分：将结果存储到Google Sheets"
},
"typeVersion": 1
},
{
"id": "46d528b4-e68e-4f42-92cc-ec75d582348f",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2360,
-1260
],
"parameters": {
"color": 4,
"width": 1300,
"height": 2220,
"content": "# 🧠跨平台追踪品牌提及"
},
"typeVersion": 1
},
{
"id": "ec93ef06-2418-4677-bb49-332d308b7506",
"name": "便签 9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2360,
-1620
],
"parameters": {
"color": 4,
"width": 1300,
"height": 320,
"content": "======================================="
},
"typeVersion": 1
},
{
"id": "d33d3c54-def3-4bc7-869d-85707bdb4106",
"name": "便签说明5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1080,
-740
],
"parameters": {
"color": 7,
"width": 380,
"height": 240,
"content": "## 如果您通过此链接加入Bright Data，我将获得少量佣金 - 感谢您为更多免费内容提供支持！"
},
"typeVersion": 1
},
{
"id": "01b7e9dd-992f-463f-819a-7c9e36a219d4",
"name": "自动修复输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserAutofixing",
"position": [
400,
160
],
"parameters": {
"options": {
"prompt": "Instructions:\n--------------\n{instructions}\n--------------\nCompletion:\n--------------\n{completion}\n--------------\n\nAbove, the Completion did not satisfy the constraints given in the Instructions.\nError:\n--------------\n{error}\n--------------\n\nPlease try again. Please only respond with an answer that satisfies the constraints laid out in the Instructions:"
}
},
"typeVersion": 1
},
{
"id": "7a9c56b5-5d2a-478d-b3fc-61e5e4f7526e",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
440,
360
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "kmqnyfHdWfA8k1KC",
"name": "OpenAi account 3"
}
},
"typeVersion": 1.2
},
{
"id": "e193f7ea-5ff7-4b9a-816d-3e9a58043ce3",
"name": "结构化输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
600,
340
],
"parameters": {
"jsonSchemaExample": "{\n \"platform\": \"Blog\",\n \"author\": \"Sam Enfield\",\n \"title\": \"Why OpenAI Suddenly Erased Jony Ive from their Website\",\n \"content summary\": \"The article discusses a vanished partnership between OpenAI and Jony Ive, Apple's legendary designer behind iconic products like the iMac, iPod, iPhone, iPad, and Apple Watch. The collaboration aimed to create a sleek, intuitive AI consumer device dubbed the \\\"iPhone of artificial intelligence,\\\" backed by billions in funding and design philosophy from Apple. However, all traces of this collaboration suddenly disappeared online—blog posts, announcement videos, promotional pages, and introductions were deleted or wiped clean. The article reveals that this abrupt removal is linked to a trademark lawsuit that emerged, reshaping the future of AI.\",\n \"sentiment\": \"Negative\"\n}\n"
},
"typeVersion": 1.3
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "05587a39-880b-47c6-ba10-78aa1462d36c",
"connections": {
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Auto-fixing Output Parser",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"🌐 Bright Data Tool": {
"ai_tool": [
[
{
"node": "🤖 Agent: Scrape Medium Blog (OpenAI Mentions)",
"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": "🤖 Agent: Scrape Medium Blog (OpenAI Mentions)",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"🧠 Chat Reasoning Engine": {
"ai_languageModel": [
[
{
"node": "🤖 Agent: Scrape Medium Blog (OpenAI Mentions)",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"📝 Define Medium Blog URL": {
"main": [
[
{
"node": "🤖 Agent: Scrape Medium Blog (OpenAI Mentions)",
"type": "main",
"index": 0
}
]
]
},
"🚀 Start Workflow (Manual Trigger)": {
"main": [
[
{
"node": "📝 Define Medium Blog URL",
"type": "main",
"index": 0
}
]
]
},
"🤖 Agent: Scrape Medium Blog (OpenAI Mentions)": {
"main": [
[
{
"node": "📥 Save Results 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
市场调研
追踪本地搜索趋势
使用Bright Data MCP和AI分析本地Google趋势搜索数据
Set
Code
Google Sheets
+7
16 节点Yaron Been
市场调研
15 个追踪反向链接机会
使用 Bright Data MCP 和 GPT-4o 追踪并分析反向链接机会
If
Set
Gmail
+9
19 节点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 查看 →
分享此工作流