社交监听
高级
这是一个Product, AI领域的自动化工作流，包含 34 个节点。主要使用 Set, Code, Gmail, Merge, Filter 等节点，结合人工智能技术实现智能自动化。 使用 AI、QuickChart 和 HTML 报告生成器进行客户反馈分析
前置要求
- •Google 账号和 Gmail API 凭证
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (34)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "DTdojLaqC01QCcXz",
"meta": {
"instanceId": "1fc85153dfc4ea22a8172f0d7347fa9f591f71e2064dc331f7bdc1d7ee422e7a",
"templateCredsSetupCompleted": true
},
"name": "社交监听",
"tags": [],
"nodes": [
{
"id": "09244606-227e-42ee-8eee-b39fd9ec1353",
"name": "当点击“测试工作流”时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-840,
1660
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d4f30c2d-60c5-4b25-a6ba-945c59fe29a8",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
-640,
1660
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "48e81d30-2892-43a3-876c-e46011739a30",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
660,
1480
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "23fbd89a-1d14-413d-8798-2f1915651fc3",
"name": "准备提示1",
"type": "n8n-nodes-base.function",
"position": [
520,
1260
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c55ccffc-d620-4162-a944-508775ba8a21",
"name": "结构化输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
840,
1460
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "1e136fc1-055e-42c3-b77e-51dcb2bf60e6",
"name": "分析主题提案",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-40,
1240
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "60bd98f4-4824-40a7-936b-466bf60b921f",
"name": "OpenAI 聊天模型1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-20,
1440
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "4de9964d-d2c9-42a6-bbb6-9b7da096dbc9",
"name": "结构化输出解析器1",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
160,
1440
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "55abf7b6-8c29-4f4e-bd9c-cd7813529dd9",
"name": "合并原始表和提示",
"type": "n8n-nodes-base.merge",
"position": [
360,
1260
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "7ed2c444-82f9-4ca3-a7c8-446f0e9ac1e6",
"name": "OpenAI 聊天模型2",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
1300,
1500
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "baa054dd-40cd-4176-9c5b-5c3e3efbee36",
"name": "统一AI代理进行分析",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
660,
1260
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "d835b7ea-c636-49ff-b503-757986aee1ca",
"name": "将结果转换为列",
"type": "n8n-nodes-base.code",
"position": [
1000,
1260
],
"parameters": {},
"typeVersion": 2
},
{
"id": "b57d48a5-44a7-4b0f-984b-69d648614d35",
"name": "所有唯一元素合并",
"type": "n8n-nodes-base.code",
"position": [
1160,
1260
],
"parameters": {},
"typeVersion": 2
},
{
"id": "71e3cd1f-b1c8-4dd5-b7ad-96a638db61ea",
"name": "结构化输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
1480,
1480
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "871c5348-be6b-4eb7-9cca-4311b7bed571",
"name": "提案优化代理",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1320,
1260
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "0b5e0e03-6faf-42ce-ac2b-464e76f50924",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
1860,
1840
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "7b89e91c-f849-4786-89bd-86f07d9d8ad3",
"name": "第二轮分析",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1860,
1640
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "a1a57ceb-2bf4-4fed-9e74-fd548db98491",
"name": "结构化输出解析器3",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
2020,
1800
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "3ab8569d-d3cd-46a4-afe7-e2b359416b50",
"name": "合并",
"type": "n8n-nodes-base.merge",
"position": [
1680,
1640
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "921e60f6-72bf-4f32-9721-3f4636353ae3",
"name": "未分析结果的总结",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
2340,
1640
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "8acb5abd-733f-492c-897c-9ef9eeaf1775",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
2340,
1900
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "51c84d52-f235-434a-a484-7a82d385be53",
"name": "结构化输出解析器4",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
2500,
1840
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "ae251045-850a-4a60-a587-7162fcc78ecc",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
2660,
1880
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "c94f55ec-721c-489b-89e4-0d02ef73b25e",
"name": "最终报告编辑器",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
2660,
1640
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "86c00be2-5ecf-4627-8a78-67ef1a3eef16",
"name": "结构化输出解析器5",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
2820,
1800
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "c916fd36-4601-486b-9da3-d441e90be074",
"name": "修订器和HTML格式化代理",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
2980,
1640
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "03c2bf53-05eb-492a-924c-db708df11b11",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
2980,
1900
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "1534a011-ff33-4bbb-a9bc-3ffe0c9443fd",
"name": "获取前n行",
"type": "n8n-nodes-base.filter",
"position": [
-480,
1240
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "69c50f29-183a-40f3-99e0-4911cb600e57",
"name": "将整个结果打包成一个Json文件",
"type": "n8n-nodes-base.code",
"position": [
2180,
1640
],
"parameters": {},
"typeVersion": 2
},
{
"id": "7c04c879-bb9f-49ff-85d4-4e9b459fe065",
"name": "合并首批样本行",
"type": "n8n-nodes-base.code",
"position": [
-280,
1240
],
"parameters": {},
"typeVersion": 2
},
{
"id": "5677b81b-0ebe-4e8f-85d5-0c403a672763",
"name": "完成代理（可选）",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
3340,
1640
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "1d02eb7f-7c33-4278-8ce9-b225bff4dd99",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
3340,
1900
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "cb4d0d10-5301-488c-861f-98bd873ea1a8",
"name": "编辑字段",
"type": "n8n-nodes-base.set",
"position": [
3720,
1640
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "50d0ba8f-6635-414d-946b-1d785992b5fb",
"name": "Gmail",
"type": "n8n-nodes-base.gmail",
"position": [
3940,
1640
],
"webhookId": "b2f8ff12-631f-4a39-9949-fbbc56d0ebe0",
"parameters": {},
"typeVersion": 2.1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "ac5647ac-6c15-4451-a8ff-4e2d1aed32b2",
"connections": {
"Merge": {
"main": [
[
{
"node": "Second iteration of analysis",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "Gmail",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets": {
"main": [
[
{
"node": "Get the first n rows",
"type": "main",
"index": 0
},
{
"node": "Merge original table and the prompts",
"type": "main",
"index": 1
},
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Prepare Prompts1": {
"main": [
[
{
"node": "Unified AI Agent for analysis",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Unified AI Agent for analysis",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"OpenAI Chat Model1": {
"ai_languageModel": [
[
{
"node": "analysis topics proposal",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"OpenAI Chat Model2": {
"ai_languageModel": [
[
{
"node": "proposal refinement agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"OpenAI Chat Model3": {
"ai_languageModel": [
[
{
"node": "Second iteration of analysis",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"OpenAI Chat Model4": {
"ai_languageModel": [
[
{
"node": "Summarization of the unalysed results",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"OpenAI Chat Model5": {
"ai_languageModel": [
[
{
"node": "Final report editor",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"OpenAI Chat Model6": {
"ai_languageModel": [
[
{
"node": "Revisor and HTML formating agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"OpenAI Chat Model7": {
"ai_languageModel": [
[
{
"node": "Completion agents (optional)",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Final report editor": {
"main": [
[
{
"node": "Revisor and HTML formating agent",
"type": "main",
"index": 0
}
]
]
},
"Get the first n rows": {
"main": [
[
{
"node": "Merging first sample rows",
"type": "main",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "Unified AI Agent for analysis",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"analysis topics proposal": {
"main": [
[
{
"node": "Merge original table and the prompts",
"type": "main",
"index": 0
}
]
]
},
"All unique elements merge": {
"main": [
[
{
"node": "proposal refinement agent",
"type": "main",
"index": 0
}
]
]
},
"Merging first sample rows": {
"main": [
[
{
"node": "analysis topics proposal",
"type": "main",
"index": 0
}
]
]
},
"Structured Output Parser1": {
"ai_outputParser": [
[
{
"node": "analysis topics proposal",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Structured Output Parser2": {
"ai_outputParser": [
[
{
"node": "proposal refinement agent",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Structured Output Parser3": {
"ai_outputParser": [
[
{
"node": "Second iteration of analysis",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Structured Output Parser4": {
"ai_outputParser": [
[
{
"node": "Summarization of the unalysed results",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Structured Output Parser5": {
"ai_outputParser": [
[
{
"node": "Final report editor",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"proposal refinement agent": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Completion agents (optional)": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"Second iteration of analysis": {
"main": [
[
{
"node": "wrap up the whole results into one Json file",
"type": "main",
"index": 0
}
]
]
},
"Unified AI Agent for analysis": {
"main": [
[
{
"node": "Transform results into columns",
"type": "main",
"index": 0
}
]
]
},
"Transform results into columns": {
"main": [
[
{
"node": "All unique elements merge",
"type": "main",
"index": 0
}
]
]
},
"Revisor and HTML formating agent": {
"main": [
[
{
"node": "Completion agents (optional)",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Test workflow’": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Merge original table and the prompts": {
"main": [
[
{
"node": "Prepare Prompts1",
"type": "main",
"index": 0
}
]
]
},
"Summarization of the unalysed results": {
"main": [
[
{
"node": "Final report editor",
"type": "main",
"index": 0
}
]
]
},
"wrap up the whole results into one Json file": {
"main": [
[
{
"node": "Summarization of the unalysed results",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 产品, 人工智能
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
敏捷团队冲刺规划自动化
使用OpenAI、Google日历和Gmail为敏捷团队自动化冲刺规划
If
Set
Code
+17
52 节点Willemijn
产品
与数据对话：将文本转换为 SQL 查询和可视化曲线
与数据对话：将文本转换为 SQL 查询和可视化曲线
If
Set
Merge
+12
36 节点hippolyte-hu
工程
自动化新闻到简报AI代理v13
AI新闻研究团队：24/7简报自动化，含Perplexity引用
Set
Code
Gmail
+15
37 节点Derek Cheung
产品
使用Gmail、OpenAI和Google表格自动化敏捷细化准备
使用Gmail、OpenAI和Google表格自动化敏捷细化准备
If
Set
Gmail
+14
51 节点Willemijn
产品
自动化博客撰写与社交媒体推广代理
使用GPT-4、Perplexity和WordPress自动化SEO博客创建+社交媒体
Set
Code
Gmail
+21
79 节点LukaszB
设计
（Duc）深度研究市场模板
集成PerplexityAI研究和OpenAI内容的多层级WordPress博客生成器
If
Set
Xml
+28
132 节点Daniel Ng
人工智能
