监控竞争对手社交媒体互动
高级
这是一个Market Research, AI Summarization领域的自动化工作流，包含 19 个节点。主要使用 Set, Code, GoogleSheets, McpClientTool, ManualTrigger 等节点。 使用Bright Data和AI监控LinkedIn竞争对手参与度与分析
前置要求
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (19)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "mrecjHsKCTsQ6QYC",
"meta": {
"instanceId": "60046904b104f0f72b2629a9d88fe9f676be4035769f1f08dad1dd38a76b9480",
"templateCredsSetupCompleted": true
},
"name": "6 监控竞争对手社交媒体互动：",
"tags": [],
"nodes": [
{
"id": "5eed5537-b38c-4a15-965b-6aa0433c6409",
"name": "🔘 触发器：手动启动",
"type": "n8n-nodes-base.manualTrigger",
"position": [
180,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c45a95e6-3a8f-4198-9b29-ee9a36059ac4",
"name": "🔗 设置 LinkedIn 公司 URL",
"type": "n8n-nodes-base.set",
"position": [
400,
0
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "01b30c4d-3a89-418a-b939-ac1e886002a4",
"name": "URL",
"type": "string",
"value": "https://www.linkedin.com/company/hubspot/"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "c7b82e78-1ef2-4c5f-aff2-a03e3a7ea4b6",
"name": "🤖 代理：获取 LinkedIn 帖子（通过 MCP 工具）",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
660,
0
],
"parameters": {
"text": "=Scrape the below user profile on LinkedIn and get the latest 5 post data:\n{{ $json.URL }}",
"options": {},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2
},
{
"id": "4a43225a-b400-47cf-b252-36516d382ff1",
"name": "🌐 Bright Data MCP 客户端",
"type": "n8n-nodes-mcp.mcpClientTool",
"position": [
820,
300
],
"parameters": {
"toolName": "web_data_linkedin_company_profile",
"operation": "executeTool",
"toolParameters": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Tool_Parameters', ``, 'json') }}"
},
"credentials": {
"mcpClientApi": {
"id": "eqq94k789oJCd6jU",
"name": "MCP Client (STDIO) account"
}
},
"typeVersion": 1
},
{
"id": "21324291-7117-44d4-aaff-601d80b93580",
"name": "📈 分析互动指标",
"type": "n8n-nodes-base.code",
"position": [
1160,
0
],
"parameters": {
"jsCode": "// Get the posts array from Agent output\nconst posts = $json.output;\n\n// Initialize counters\nlet totalLikes = 0;\nlet totalComments = 0;\n\n// Loop through posts and sum likes and comments\nfor (const post of posts) {\n totalLikes += post.likes;\n totalComments += post.comments;\n}\n\n// Calculate averages\nconst averageLikes = totalLikes / posts.length;\nconst averageComments = totalComments / posts.length;\n\n// Return summary object\nreturn [\n {\n json: {\n totalPosts: posts.length,\n totalLikes: totalLikes,\n totalComments: totalComments,\n averageLikes: averageLikes,\n averageComments: averageComments\n }\n }\n];\n"
},
"typeVersion": 2
},
{
"id": "469f5efc-276c-449b-ab50-4cd3454946f6",
"name": "📥 将平均值保存到 Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
1380,
0
],
"parameters": {
"columns": {
"value": {
"Total likes": "={{ $json.totalLikes }}",
"Total posts": "={{ $json.totalPosts }}",
"Average likes": "={{ $json.averageLikes }}",
"Total comments": "={{ $json.totalComments }}",
"Average comments": "={{ $json.averageComments }}"
},
"schema": [
{
"id": "Total posts",
"type": "string",
"display": true,
"required": false,
"displayName": "Total posts",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Total likes",
"type": "string",
"display": true,
"required": false,
"displayName": "Total likes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Total comments",
"type": "string",
"display": true,
"required": false,
"displayName": "Total comments",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Average likes",
"type": "string",
"display": true,
"required": false,
"displayName": "Average likes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Average comments",
"type": "string",
"display": true,
"required": false,
"displayName": "Average comments",
"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/1FzzslRBkdEgz14zuyy1J5IAMAHgkmdmiYiEqYG9AnOI/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1FzzslRBkdEgz14zuyy1J5IAMAHgkmdmiYiEqYG9AnOI",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1FzzslRBkdEgz14zuyy1J5IAMAHgkmdmiYiEqYG9AnOI/edit?usp=drivesdk",
"cachedResultName": "Competitor post analysis average"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "r2mDaisH6e9VkwHl",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "8f554af6-1d6d-4225-9ffb-5814e4ca2773",
"name": "🧾 格式化帖子内容",
"type": "n8n-nodes-base.code",
"position": [
1640,
0
],
"parameters": {
"jsCode": "// Get the Agent output (array of posts)\nconst posts = $('🤖 Agent: Fetch LinkedIn Posts (via MCP Tool)').first().json.output;\n\n// Map each post to its own item\nreturn posts.map(post => {\n return {\n json: post\n };\n});\n"
},
"typeVersion": 2
},
{
"id": "8274a619-f1d2-4e14-9753-665f060611c1",
"name": "📥 将帖子保存到 Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
1860,
0
],
"parameters": {
"columns": {
"value": {
"date": "={{ $json.date }}",
"likes": "={{ $json.likes }}",
"video": "={{ $json.videos }}",
"content": "={{ $json.content }}",
"comments": "={{ $json.comments }}",
"post link": "={{ $json.post_link }}",
"Competitor": "={{ $json.competitor }}",
"Post title": "={{ $json.post_title }}"
},
"schema": [
{
"id": "Competitor",
"type": "string",
"display": true,
"required": false,
"displayName": "Competitor",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Post title",
"type": "string",
"display": true,
"required": false,
"displayName": "Post title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "date",
"type": "string",
"display": true,
"required": false,
"displayName": "date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "likes",
"type": "string",
"display": true,
"required": false,
"displayName": "likes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "comments",
"type": "string",
"display": true,
"required": false,
"displayName": "comments",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "content",
"type": "string",
"display": true,
"required": false,
"displayName": "content",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "post link",
"type": "string",
"display": true,
"required": false,
"displayName": "post link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "video",
"type": "string",
"display": true,
"required": false,
"displayName": "video",
"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/1R-rAkvVh1lhbPrFsxuBUXNMFFFgsyIWzS4OritRiHLU/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1R-rAkvVh1lhbPrFsxuBUXNMFFFgsyIWzS4OritRiHLU",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1R-rAkvVh1lhbPrFsxuBUXNMFFFgsyIWzS4OritRiHLU/edit?usp=drivesdk",
"cachedResultName": "Competitor post analysis"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "r2mDaisH6e9VkwHl",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "da8ebb55-18c8-4f17-882d-6ddee3f17533",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
140,
-720
],
"parameters": {
"color": 3,
"width": 420,
"height": 900,
"content": "### 🔹 **第一部分：开始与输入**"
},
"typeVersion": 1
},
{
"id": "df570435-b29c-444f-99a0-f3d8bf951673",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
600,
300
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "8sEyPDkC5p4w4Jha",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "54b4118c-47d6-4aa4-9f73-d3d2389a7107",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
600,
-860
],
"parameters": {
"color": 5,
"width": 420,
"height": 1040,
"content": "### 🤖 **第二部分：智能抓取代理**"
},
"typeVersion": 1
},
{
"id": "4fe62240-87e5-45ae-991e-a0ca07500c93",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1100,
-680
],
"parameters": {
"color": 6,
"width": 420,
"height": 860,
"content": "### 📊 **第三部分：分析与保存指标**"
},
"typeVersion": 1
},
{
"id": "a2897619-9086-4a99-8fa6-551fffc8893f",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1580,
-640
],
"parameters": {
"color": 2,
"width": 420,
"height": 820,
"content": "### 📄 **第四部分：格式化与存储完整帖子**"
},
"typeVersion": 1
},
{
"id": "55dbafa4-8ad9-4a4d-b5bb-2b42facb55e4",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1660,
-700
],
"parameters": {
"color": 4,
"width": 1300,
"height": 320,
"content": "======================================="
},
"typeVersion": 1
},
{
"id": "d222b12b-dfed-4240-9580-027370214ae0",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1660,
-360
],
"parameters": {
"color": 4,
"width": 1289,
"height": 2578,
"content": "## 🚀 **LinkedIn 公司帖子分析器工作流**"
},
"typeVersion": 1
},
{
"id": "e99f86d4-73cc-4bcb-a8d7-24f640abf7d6",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
2080,
-640
],
"parameters": {
"color": 7,
"width": 380,
"height": 240,
"content": "## 如果您通过此链接加入 Bright Data，我将获得少量佣金 — 感谢您为更多免费内容提供动力！"
},
"typeVersion": 1
},
{
"id": "3991b4a5-b3d8-4869-b620-b0eff43e56b1",
"name": "自动修复输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserAutofixing",
"position": [
980,
300
],
"parameters": {
"options": {}
},
"typeVersion": 1
},
{
"id": "c9cfdde4-39e7-42de-a66c-94a1264d7b33",
"name": "OpenAI 聊天模型1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
940,
560
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "8sEyPDkC5p4w4Jha",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "2e74bb7f-634f-4840-919d-e825feb66b11",
"name": "结构化输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
1120,
560
],
"parameters": {
"jsonSchemaExample": "[\n {\n \"competitor\": \"HubSpot\",\n \"post_title\": \"HubSpot\",\n \"date\": \"3 weeks ago\",\n \"likes\": 54,\n \"comments\": 3,\n \"content\": \"🚨 Nicht weiter scrollen! 🚨 Wir sind das ✨erste✨ CRM mit einem Deep-Research-Connector für ChatGPT Deine HubSpot-Daten + das Hirn von ChatGPT = 🤯 🔗 Hol dir jetzt den Early Access\",\n \"post_link\": \"https://de.linkedin.com/posts/hubspot_hubspot-und-chatgptpdf-activity-7336304617892306944-Ob8h\",\n \"videos\": []\n },\n {\n \"competitor\": \"HubSpot\",\n \"post_title\": \"HubSpot\",\n \"date\": \"1 day ago\",\n \"likes\": 79,\n \"comments\": 10,\n \"content\": \"when you need a social content framework that's effective AND memorable\",\n \"post_link\": null,\n \"videos\": [\n \"https://dms.licdn.com/playlist/vid/v2/D4D10AQEmIrq4MYknpQ/mp4-640p-30fp-crf28/B4DZetK.GFGkA4-/0/1750957032138?e=2147483647&v=beta&t=PtE4WAUXBXb2VkZChI7m-R4BGONJY0vY0IGCHyX4lXQ\"\n ]\n },\n {\n \"competitor\": \"HubSpot\",\n \"post_title\": \"HubSpot\",\n \"date\": \"4 days ago\",\n \"likes\": 116,\n \"comments\": 12,\n \"content\": \"plot twist: the co-worker who complained about being cold all winter is now the office hero for knowing where the thermostat is\",\n \"post_link\": \"https://www.linkedin.com/posts/hubspot_plot-twist-the-co-worker-who-complained-activity-7343003120873922560-OIh3\",\n \"videos\": []\n },\n {\n \"competitor\": \"HubSpot\",\n \"post_title\": \"HubSpot\",\n \"date\": \"1 week ago\",\n \"likes\": 112,\n \"comments\": 4,\n \"content\": \"meet my new work bestie: Breeze Customer Agent\",\n \"post_link\": null,\n \"videos\": [\n \"https://dms.licdn.com/playlist/vid/v2/D4D10AQGcS77ueYgGeQ/mp4-720p-30fp-crf28/B4DZeITpeIGgBM-/0/1750338545668?e=2147483647&v=beta&t=NrehXjQVj_uk7nHVFrvs18p4-tLUleLObMGKrmsCoqY\"\n ]\n },\n {\n \"competitor\": \"HubSpot\",\n \"post_title\": \"HubSpot\",\n \"date\": \"1 week ago\",\n \"likes\": 104,\n \"comments\": 11,\n \"content\": \"must have been the wind\",\n \"post_link\": null,\n \"videos\": [\n \"https://dms.licdn.com/playlist/vid/v2/D4D05AQG6kJ8EqkBmAw/mp4-640p-30fp-crf28/B4DZeEjsVIGUBg-/0/1750275644735?e=2147483647&v=beta&t=7Pfujdbu6rXW34zKPoDHXrnHG93T900bKVQBFBllbLA\"\n ]\n }\n]\n"
},
"typeVersion": 1.2
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "a97cbb59-0a34-41a1-9649-3ef22f0f3b7d",
"connections": {
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "🤖 Agent: Fetch LinkedIn Posts (via MCP Tool)",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"OpenAI Chat Model1": {
"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
}
]
]
},
"🧾 Format Post Content": {
"main": [
[
{
"node": "📥 Save Posts to Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Auto-fixing Output Parser": {
"ai_outputParser": [
[
{
"node": "🤖 Agent: Fetch LinkedIn Posts (via MCP Tool)",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"🔘 Trigger: Manual Start": {
"main": [
[
{
"node": "🔗 Set LinkedIn Company URL",
"type": "main",
"index": 0
}
]
]
},
"🌐 Bright Data MCP Client": {
"ai_tool": [
[
{
"node": "🤖 Agent: Fetch LinkedIn Posts (via MCP Tool)",
"type": "ai_tool",
"index": 0
}
]
]
},
"🔗 Set LinkedIn Company URL": {
"main": [
[
{
"node": "🤖 Agent: Fetch LinkedIn Posts (via MCP Tool)",
"type": "main",
"index": 0
}
]
]
},
"📈 Analyze Engagement Metrics": {
"main": [
[
{
"node": "📥 Save Averages to Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"📥 Save Averages to Google Sheets": {
"main": [
[
{
"node": "🧾 Format Post Content",
"type": "main",
"index": 0
}
]
]
},
"🤖 Agent: Fetch LinkedIn Posts (via MCP Tool)": {
"main": [
[
{
"node": "📈 Analyze Engagement Metrics",
"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 MCP和AI分析本地Google趋势搜索数据
Set
Code
Google Sheets
+7
16 节点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
市场调研
工作流信息
难度等级
高级
节点数量19
分类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 查看 →
分享此工作流