多平台评论聚合器
中级
这是一个Market Research领域的自动化工作流，包含 13 个节点。主要使用 If、Code、Shopify、HttpRequest、GoogleSheets 等节点。 集中式评论聚合器：从Trustpilot、Google、Facebook汇总到Google Sheets
前置要求
- •Shopify Admin API 凭证
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "VaL3XAWomsvW7ibb",
"meta": {
"instanceId": "2000c64071c20843606b95c63795bb0797c41036047055a6586498e855b96efc"
},
"name": "多平台评论聚合器",
"tags": [],
"nodes": [
{
"id": "746adbc5-aeb8-40fd-ae0c-a3fd9e6fab5a",
"name": "每日评论同步",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-880,
340
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "d3c5a37e-9c39-4b81-a6b8-8752dae02ec2",
"name": "获取产品",
"type": "n8n-nodes-base.shopify",
"position": [
-660,
340
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a19fd031-7998-48d4-854d-cb3bd2377686",
"name": "获取Trustpilot评论",
"type": "n8n-nodes-base.httpRequest",
"position": [
-440,
240
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "c7552932-9ffd-458d-90dd-8876756ce012",
"name": "获取Google评论",
"type": "n8n-nodes-base.httpRequest",
"position": [
-440,
340
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "dc3e88e5-0e55-4a59-a983-c813a6328dda",
"name": "获取Facebook评论",
"type": "n8n-nodes-base.httpRequest",
"position": [
-440,
440
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "44d7f0d0-cb0b-4670-ad93-b5e38246dc24",
"name": "标准化评论数据",
"type": "n8n-nodes-base.code",
"position": [
-220,
340
],
"parameters": {},
"typeVersion": 2
},
{
"id": "1127884c-a3b7-4c31-9b3d-442eb4cebc4e",
"name": "检查是否找到评论",
"type": "n8n-nodes-base.if",
"position": [
0,
340
],
"parameters": {},
"typeVersion": 2
},
{
"id": "91234883-4c8e-4400-9146-079c0746ff67",
"name": "存储评论数据库",
"type": "n8n-nodes-base.googleSheets",
"position": [
220,
340
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "7a310f10-d88e-45eb-b112-0c59187e4a10",
"name": "工作流信息",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1220,
120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "30572c35-33fe-4b41-8b63-0ce8009eb65d",
"name": "功能与配置",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a80c8009-0090-4f2f-ad8a-805af9d5c7b6",
"name": "商业价值",
"type": "n8n-nodes-base.stickyNote",
"position": [
80,
500
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "93776d7d-8bae-431b-b424-f193cd88d593",
"name": "平台与流程",
"type": "n8n-nodes-base.stickyNote",
"position": [
-520,
60
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "86bdf061-24a5-4a2e-93e2-54c75c76822a",
"name": "API要求",
"type": "n8n-nodes-base.stickyNote",
"position": [
220,
40
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "357f793e-603a-438f-892e-1ed52132c8a6",
"connections": {
"Get Products": {
"main": [
[
{
"node": "Fetch Trustpilot Reviews",
"type": "main",
"index": 0
},
{
"node": "Fetch Google Reviews",
"type": "main",
"index": 0
},
{
"node": "Fetch Facebook Reviews",
"type": "main",
"index": 0
}
]
]
},
"Daily Review Sync": {
"main": [
[
{
"node": "Get Products",
"type": "main",
"index": 0
}
]
]
},
"Fetch Google Reviews": {
"main": [
[
{
"node": "Normalize Review Data",
"type": "main",
"index": 0
}
]
]
},
"Normalize Review Data": {
"main": [
[
{
"node": "Check if Reviews Found",
"type": "main",
"index": 0
}
]
]
},
"Check if Reviews Found": {
"main": [
[
{
"node": "Store Reviews Database",
"type": "main",
"index": 0
}
]
]
},
"Fetch Facebook Reviews": {
"main": [
[
{
"node": "Normalize Review Data",
"type": "main",
"index": 0
}
]
]
},
"Fetch Trustpilot Reviews": {
"main": [
[
{
"node": "Normalize Review Data",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
这是一个中级难度的工作流，适用于Market Research等场景。适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
LinkedIn潜在客户生成与CRM自动化套件
使用Apify提取LinkedIn个人资料并为Google Sheets CRM自动生成潜在客户数据
If
Set
Code
+7
18 节点David Olusola
Lead Generation
基于AI、Bright Data、Sheets和Slack的联盟竞争对手追踪与分析
使用AI、Bright Data、Sheets和Slack进行联盟竞争对手追踪与分析
If
Set
Code
+6
23 节点Daniel Shashko
Market Research
MetaAds创意洞察研究员v1.4
使用Google Vision和Video Intelligence API分析Meta广告创意
If
Set
Code
+9
32 节点Kirill Khatkevich
Market Research
医疗账单自动化模板
使用Google Sheets和Gmail自动化医疗账单处理
If
Set
Code
+5
11 节点David Olusola
Finance
我的工作流 2
结合 AI 竞品监控和收入优化的自动化动态定价
If
Code
Merge
+8
25 节点vinci-king-01
Market Research
AI潜在客户机器专业版：Google地图→Slack→HubSpot→$$$
使用Google地图、GPT-4和HubSpot的自动化潜在客户生成与资格认证
If
Set
Code
+7
16 节点David Olusola
Sales
工作流信息
难度等级
中级
节点数量13
分类1
节点类型7
作者
David Olusola
@dae221I help ambitious businesses eliminate operational bottlenecks and scale faster with AI automation. My clients typically see 40-60% efficiency gains within 90 days. Currently accepting 3 new projects this quarter - david@daexai.com
外部链接
在 n8n.io 上查看 →
分享此工作流