从Trustpilot抓取评论
高级
这是一个Market Research, AI Summarization领域的自动化工作流，包含 16 个节点。主要使用 Set, Code, GoogleSheets, McpClientTool, ManualTrigger 等节点。 使用OpenAI和Bright Data进行Trustpilot评论情感分析并同步到Google Sheets
前置要求
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (16)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "7xkEgEP44GHwgc2N",
"meta": {
"instanceId": "c38e3b8a7e4240e6cdca062743f016c1029f385bf40345b6291939dfd83bfd77",
"templateCredsSetupCompleted": true
},
"name": "从 Trustpilot 抓取评论",
"tags": [],
"nodes": [
{
"id": "a15211f7-505b-4f2a-ba53-c029f2e9b54a",
"name": "设置 Trustpilot 公司 URL",
"type": "n8n-nodes-base.set",
"position": [
-60,
-140
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "2cf9cb42-883e-40da-9785-47755c9c6e9a",
"name": "URL",
"type": "string",
"value": "https://www.trustpilot.com/review/hubspot.com"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "65afe387-1264-4e71-8308-00f9c7229806",
"name": "手动启动",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-220,
-140
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a8b8737b-592e-4b0f-abd5-844f8c0213ea",
"name": "智能体：获取并分析评论",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
220,
-140
],
"parameters": {
"text": "=`You are a web scraper connected to Bright Data's MCP tool using the scrape_as_markdown function.\n\nScrape the latest 5 reviews from the Trustpilot company page at this URL:\n{{ $json.URL }}\n\nUse the scrape_as_markdown tool with these parameters:\n{\n \"url\": {{ $json.URL }},\n \"max_items\": 5\n}\n\nAfter scraping, analyze each review and return a JSON array of 5 objects with these fields:\n\n- reviewer (string)\n- date (string)\n- rating (number)\n- sentiment (one of \"positive\", \"neutral\", or \"negative\")\n- mainIssue (string — summarize complaint or praise)\n- reviewText (string)\n\nReturn only valid JSON.\n`\n",
"options": {},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2
},
{
"id": "1d8b112c-7917-4f61-8b6e-3d6d98ce1947",
"name": "聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
160,
120
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "kmqnyfHdWfA8k1KC",
"name": "OpenAi account 3"
}
},
"typeVersion": 1.2
},
{
"id": "eb5f2d9a-aed9-48a1-ad61-7903b333314c",
"name": "Bright Data MCP 爬虫工具",
"type": "n8n-nodes-mcp.mcpClientTool",
"position": [
300,
100
],
"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": "4c2639af-44c4-4579-beaa-cff5a9b50ae1",
"name": "将评论拆分为独立对象",
"type": "n8n-nodes-base.code",
"position": [
640,
-140
],
"parameters": {
"jsCode": "// Access the first item in the input (AI Agent output)\nconst outputArray = $('Agent : Fetch and analyze reviews').first().json.output;\n\n// Map each review to a separate item (with `.json` wrapping)\nreturn outputArray.map(review => ({ json: review }));\n\n"
},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "1e4f0309-ac91-4ad7-836c-552b291db2e6",
"name": "将评论保存到 Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
860,
-140
],
"parameters": {
"columns": {
"value": {
"date ": "={{ $json.date }}",
"rating": "={{ $json.rating }}",
"reviewer": "={{ $json.reviewer }}",
"mainIssue ": "={{ $json.mainIssue }}",
"reviewText": "={{ $json.reviewText }}",
"sentiment ": "={{ $json.sentiment }}"
},
"schema": [
{
"id": "reviewer",
"type": "string",
"display": true,
"required": false,
"displayName": "reviewer",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "date ",
"type": "string",
"display": true,
"required": false,
"displayName": "date ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "rating",
"type": "string",
"display": true,
"required": false,
"displayName": "rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "sentiment ",
"type": "string",
"display": true,
"required": false,
"displayName": "sentiment ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "mainIssue ",
"type": "string",
"display": true,
"required": false,
"displayName": "mainIssue ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reviewText",
"type": "string",
"display": true,
"required": false,
"displayName": "reviewText",
"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/1dlaEmLIzSgTxH0whWJnx51lPHyb34bGxMSQig5KI7CQ/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1dlaEmLIzSgTxH0whWJnx51lPHyb34bGxMSQig5KI7CQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1dlaEmLIzSgTxH0whWJnx51lPHyb34bGxMSQig5KI7CQ/edit?usp=drivesdk",
"cachedResultName": "scraped reviews from trustpilot"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "i899RBJ6SKiYYWwx",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "8d3de4f3-b17e-4607-a4d2-75e2bb3dafb8",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-240,
-440
],
"parameters": {
"color": 3,
"width": 340,
"height": 480,
"content": "🔹 第一部分：🚦 启动与输入公司 URL"
},
"typeVersion": 1
},
{
"id": "157a1838-08dd-4866-a770-14d9c91c52c9",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
160,
-820
],
"parameters": {
"color": 5,
"width": 400,
"height": 880,
"content": "🤖 第二部分：🧠 AI 智能体 – 抓取、分析与总结 Trustpilot 评论"
},
"typeVersion": 1
},
{
"id": "30970761-128a-4f35-86ca-ace27105edfd",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
600,
-680
],
"parameters": {
"color": 6,
"width": 420,
"height": 740,
"content": "📊 第三部分：📦 拆分评论 & 📥 保存到 Google Sheets"
},
"typeVersion": 1
},
{
"id": "afd73d97-fb10-4c7a-bb8c-7cc9cdcfc379",
"name": "便签 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1900,
-560
],
"parameters": {
"color": 4,
"width": 1300,
"height": 1820,
"content": "分析评论网站情感"
},
"typeVersion": 1
},
{
"id": "55a5aa8e-c5e5-443d-b71a-4dc2ae3438bb",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1900,
-900
],
"parameters": {
"color": 4,
"width": 1300,
"height": 320,
"content": "======================================="
},
"typeVersion": 1
},
{
"id": "bff313ed-572b-47ec-bdb3-4299bc78bfb5",
"name": "便签 5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1060,
-680
],
"parameters": {
"color": 7,
"width": 380,
"height": 240,
"content": "## 如果您通过此链接加入 Bright Data，我将获得少量佣金——感谢您支持更多免费内容！"
},
"typeVersion": 1
},
{
"id": "4640997a-7f82-4d97-bf1d-60f063038c0d",
"name": "自动修复输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserAutofixing",
"position": [
420,
120
],
"parameters": {
"options": {}
},
"typeVersion": 1
},
{
"id": "784fad38-2ad5-4e31-b6ea-e594a3da6bba",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
420,
320
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "kmqnyfHdWfA8k1KC",
"name": "OpenAi account 3"
}
},
"typeVersion": 1.2
},
{
"id": "17616722-c86c-4741-a1ea-2e30cc2ff420",
"name": "结构化输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
580,
320
],
"parameters": {
"schemaType": "manual",
"inputSchema": "{\n \"type\": \"array\",\n \"items\": {\n \"type\": \"object\",\n \"properties\": {\n \"reviewer\": { \"type\": \"string\" },\n \"date\": { \"type\": \"string\" },\n \"rating\": { \"type\": \"number\" },\n \"sentiment\": {\n \"type\": \"string\",\n \"enum\": [\"positive\", \"neutral\", \"negative\"]\n },\n \"mainIssue\": { \"type\": \"string\" },\n \"reviewText\": { \"type\": \"string\" }\n },\n \"required\": [\"reviewer\", \"date\", \"rating\", \"sentiment\", \"mainIssue\", \"reviewText\"]\n }\n}"
},
"typeVersion": 1.3
}
],
"active": false,
"pinData": {
"Manual Start": [
{
"json": {}
}
]
},
"settings": {
"executionOrder": "v1"
},
"versionId": "cc92153a-30c0-4c8b-9c09-8196a98935ee",
"connections": {
"Chat Model": {
"ai_languageModel": [
[
{
"node": "Agent : Fetch and analyze reviews",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Manual Start": {
"main": [
[
{
"node": "Set Trustpilot company URL",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Auto-fixing Output Parser",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Bright Data MCP Scrapper": {
"ai_tool": [
[
{
"node": "Agent : Fetch and analyze reviews",
"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 : Fetch and analyze reviews",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Set Trustpilot company URL": {
"main": [
[
{
"node": "Agent : Fetch and analyze reviews",
"type": "main",
"index": 0
}
]
]
},
"Agent : Fetch and analyze reviews": {
"main": [
[
{
"node": "Splits Reviews into separate Objects",
"type": "main",
"index": 0
}
]
]
},
"Splits Reviews into separate Objects": {
"main": [
[
{
"node": "Save Reviews 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
市场调研
25收集功能请求
通过AI自动化从评论到Jira的功能请求收集与分析
Set
Code
Jira
+7
16 节点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 查看 →
分享此工作流