AI驱动客户反馈分析与路由，集成Gmail、Zendesk、Slack和Pipedrive
高级
这是一个自动化工作流，包含 23 个节点。主要使用 Set, GmailTool, SlackTool, NotionTool, ZendeskTool 等节点。 AI驱动客户反馈分析与路由，集成Gmail、Zendesk、Slack和Pipedrive
前置要求
- •Google 账号和 Gmail API 凭证
- •Slack Bot Token 或 Webhook URL
- •Notion API Key
- •OpenAI API Key
使用的节点 (23)
分类
-
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"nodes": [
{
"id": "60256706-eabb-4ff1-abf0-78b5a9ca0869",
"name": "手动触发器：启动 VOC 分析",
"type": "n8n-nodes-base.manualTrigger",
"position": [
48,
368
],
"parameters": {},
"typeVersion": 1
},
{
"id": "be859333-a941-4a71-951f-eeb6adcd0e4f",
"name": "设置：初始参数",
"type": "n8n-nodes-base.set",
"position": [
320,
368
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "d69bdbe2-f51a-4956-9d5d-bfe3a82ec82d",
"name": "CSM email",
"type": "string",
"value": "your-email@example.com"
},
{
"id": "3efe4a59-2983-4f07-8e5c-130a5aad6fdb",
"name": "slack_billing_channel",
"type": "string",
"value": "#billing-feedback"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "c263ec19-9bdb-46fb-afde-4a17da961d3c",
"name": "配置：设置 Agent 的 LLM",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
1552,
928
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {
"temperature": 0
}
},
"typeVersion": 1.2
},
{
"id": "bf4488bd-0e20-4827-b370-77396415f7c8",
"name": "配置：设置 Agent 内存",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
432,
592
],
"parameters": {
"sessionKey": "1",
"sessionIdType": "customKey"
},
"typeVersion": 1.3
},
{
"id": "8f128774-c198-4a13-8d19-8cf5ac19c8b8",
"name": "AI Agent：收集客户反馈",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
736,
368
],
"parameters": {
"text": "=- Get **ALL** the mails sent after {{Date.now() - 7 * 24 * 60 * 60 * 1000}} from the user {{ $('Set: Initial Parameters').item.json['CSM email'] }}. Return only the Subject and the snippet.\n- Get **ALL** the messages from Slack return the user ID as customerId.\n- Get **ALL** the notes from Pipedrive. Use person_id as the customerId\n- Get **ALL** the tickets from Zendesk. Use requester_id as customerId",
"options": {},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2.2
},
{
"id": "6b70f528-bd39-4758-9d04-6b3ff93af6ff",
"name": "AI：结构化反馈数据",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
1184,
592
],
"parameters": {
"autoFix": true,
"jsonSchemaExample": "\n [{\n \"source\": \"Zendesk | Gmail | Slack | Pipedrive\",\n \"customerId\": \"...\",\n \"messageId\": \"\",\n \"subject\": \"...\",\n \"text\": \"...\"\n}]\n\n"
},
"typeVersion": 1.3
},
{
"id": "7c5791aa-2842-47af-818b-004af9685455",
"name": "工具：获取 Gmail 消息",
"type": "n8n-nodes-base.gmailTool",
"position": [
576,
592
],
"webhookId": "d4a1dd6b-781c-4c44-b6a6-2d84a5542281",
"parameters": {
"filters": {
"sender": "=",
"receivedAfter": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Received_After', ``, 'string') }}"
},
"operation": "getAll",
"returnAll": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Return_All', ``, 'boolean') }}"
},
"typeVersion": 2.1
},
{
"id": "fbca39a8-6593-4cdb-a582-3bb81d18cb3a",
"name": "工具：获取 Pipedrive 笔记",
"type": "n8n-nodes-base.pipedriveTool",
"position": [
736,
592
],
"parameters": {
"resource": "note",
"operation": "getAll",
"additionalFields": {}
},
"typeVersion": 1
},
{
"id": "a833e7b4-6510-44a5-934a-9d3b46289717",
"name": "工具：获取 Zendesk 工单",
"type": "n8n-nodes-base.zendeskTool",
"position": [
880,
592
],
"parameters": {
"options": {},
"operation": "getAll"
},
"typeVersion": 1
},
{
"id": "28a49bba-62fa-4896-8604-098903b84450",
"name": "工具：搜索 Slack 消息 导出到 Sheets",
"type": "n8n-nodes-base.slackTool",
"position": [
1024,
592
],
"webhookId": "cfa05622-054d-4981-8b27-79a0c88bfaea",
"parameters": {
"query": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Search_Query', ``, 'string') }}",
"options": {
"searchChannel": ""
},
"operation": "search",
"authentication": "oAuth2"
},
"typeVersion": 2.3
},
{
"id": "b9212f35-c028-481e-908b-12aa3324ac25",
"name": "AI Chain：提取关键信号",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
1552,
368
],
"parameters": {
"text": "=Prompt:\nYou are analyzing raw customer feedback from multiple sources (Gmail, Slack, Pipedrive, Zendesk).\nYour task: compress the \"text\" of each feedback into a concise signal (1–2 sentences max) that captures the core issue, request, or sentiment without losing meaning.\n\nRules:\n\t•\tStrip away greetings, signatures, and filler.\n\t•\tKeep specific product terms, error codes, or feature names if present.\n\t•\tNeutral, factual tone (don’t add assumptions).\n\t•\tIf the text is vague, summarize it at the same level of vagueness.\n\t•\tOutput only the summary text, no extra commentary.\n\nExample:\n\t•\tInput: “Hi team, I’ve tried three times to update my billing info but the system keeps failing with error 502. Can someone help?”\n\t•\tOutput: Customer unable to update billing info due to repeated error 502. \n\nHere is the content:\n{{ JSON.stringify($json.output) }}",
"batching": {
"batchSize": 5
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.7
},
{
"id": "7ec417ac-bc65-4c9e-a1f7-dc3d295403e0",
"name": "AI：结构化关键信号",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
1696,
592
],
"parameters": {
"jsonSchemaExample": "[\n\t{\"original_text\": \"\",\n\t\"signals\": [\"\", \"\"]\n}]"
},
"typeVersion": 1.3
},
{
"id": "09797f66-2ce6-4392-afb4-a646ba733799",
"name": "AI Chain：将信号聚类为主题",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
1904,
368
],
"parameters": {
"text": "=Prompt:\nYou will receive a set of short customer feedback signals.\nYour task: group them by shared topic or problem and assign each group a clear, human-readable label.\n\nRules:\n\t•\tLabels should be broad enough to cover all items in the group, but still actionable (e.g. Billing, Onboarding, Performance, Feature Requests).\n\t•\tAvoid vague labels like General Feedback unless no pattern exists.\n\t•\tEach cluster must include:\n\t•\tLabel\n\t•\tCount of items\n\t•\tRepresentative examples (1–3 feedback snippets).\n\n {{ JSON.stringify($json.output) }}",
"batching": {},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.7
},
{
"id": "d31b8993-f7c4-496f-9515-ae2e39e84f17",
"name": "AI：结构化聚类主题 导出到 Sheets",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
2048,
592
],
"parameters": {
"jsonSchemaExample": "[\n {\n \"label\": \"Billing\",\n \"count\": 8,\n \"examples\": [\n \"Unable to update billing info due to error 502\",\n \"Invoice shows wrong amount\"\n ]\n }\n]"
},
"typeVersion": 1.3
},
{
"id": "b26017dd-99f0-4033-9fb4-cfcf3be03c14",
"name": "AI Agent：将主题路由到操作",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
2320,
368
],
"parameters": {
"text": "=Prompt:\nYou will receive a list of feedback clusters, each with a label, count, and examples.\nFirst you will send the processed input to \"{{ $('Set: Initial Parameters').item.json['CSM email'] }}\" with the subject \"Weekly digest\"\nYour task: decide the correct destination action for each cluster based on the label and the count if it is superior to 1. Each message will have the examples in it.\n\n## Routing Rules:\n### Performance / Feature gaps → Product\n - Create a zendesk ticket with the label as the title and the examples as the description\n### Billing / Contract issues → Finance or Sales Ops\n - Post message to Slack channel {{ $('Set: Initial Parameters').item.json.slack_billing_channel }} with the examples as the text\n### Onboarding / Training → CS Enablement\n - Create Notion task with the label as the title and the examples as the content\n### High-risk sentiment / VIP account → CS Manager\n - Send direct email to cs Manager \"{{ $('Set: Initial Parameters').item.json['CSM email'] }}\" with tzhe subject \"Problem with the software\" and the examples as the text\n### Sales and customer engagement\n - Send direct email to cs Manager \"{{ $('Set: Initial Parameters').item.json['CSM email'] }}\" with the subject \"Customer engagement\" and the examples as the text\n\n### Client Management and Proposals\n - Send direct email to cs Manager \"{{ $('Set: Initial Parameters').item.json['CSM email'] }}\" with the subject \"Client Management and Proposals\" with the examples as the text\n \nIf the cluster doesn’t fit above, mark as \"unassigned\" but keep it in the output.\nThe input:\n {{ JSON.stringify($json.output) }}",
"options": {},
"promptType": "=define"
},
"typeVersion": 2.2
},
{
"id": "ebefbd63-8ea6-49e3-be48-4aaf1b4f7011",
"name": "工具：创建 Zendesk 工单",
"type": "n8n-nodes-base.zendeskTool",
"position": [
2320,
592
],
"parameters": {
"description": "由 n8n 生成的工单",
"jsonParameters": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('JSON_Parameters', ``, 'boolean') }}",
"additionalFields": {}
},
"typeVersion": 1
},
{
"id": "2b0c3dc2-cf60-4d2b-8127-4141d34e7bee",
"name": "工具：发送邮件提醒",
"type": "n8n-nodes-base.gmailTool",
"position": [
2464,
592
],
"webhookId": "127092c9-48cd-40be-9d99-afd264bd95fb",
"parameters": {
"sendTo": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('To', ``, 'string') }}",
"message": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Message', ``, 'string') }}",
"options": {},
"subject": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Subject', ``, 'string') }}",
"emailType": "text"
},
"typeVersion": 2.1
},
{
"id": "b47fc28d-72f5-42f9-a661-254a392ae443",
"name": "工具：创建 Notion 页面",
"type": "n8n-nodes-base.notionTool",
"position": [
2608,
592
],
"parameters": {
"title": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Title', ``, 'string') }}",
"simple": false,
"options": {},
"resource": "databasePage",
"databaseId": {
"__rl": true,
"mode": "id",
"value": ""
},
"propertiesUi": {
"propertyValues": [
{
"key": "Content|rich_text",
"textContent": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('propertyValues0_Text', ``, 'string') }}"
}
]
}
},
"notesInFlow": false,
"typeVersion": 2.2
},
{
"id": "fdac92b0-5b36-4fdc-a384-93c2d6c20cc6",
"name": "注释：数据收集",
"type": "n8n-nodes-base.stickyNote",
"position": [
704,
176
],
"parameters": {
"color": 7,
"width": 380,
"height": 128,
"content": "### 数据收集 Agent"
},
"typeVersion": 1
},
{
"id": "ab1edac7-c359-433a-bad5-70c876d9cfb1",
"name": "注释：分析链",
"type": "n8n-nodes-base.stickyNote",
"position": [
1616,
160
],
"parameters": {
"color": 7,
"width": 476,
"height": 152,
"content": "### AI 分析链"
},
"typeVersion": 1
},
{
"id": "0e500b93-135e-4a03-91e8-2159cc58718b",
"name": "注释：操作 Agent",
"type": "n8n-nodes-base.stickyNote",
"position": [
2224,
160
],
"parameters": {
"color": 7,
"width": 412,
"height": 152,
"content": "### 操作与路由 Agent"
},
"typeVersion": 1
},
{
"id": "0642f4ae-f111-4446-9e9a-c9bb0c1e609c",
"name": "工作流文档",
"type": "n8n-nodes-base.stickyNote",
"position": [
16,
-320
],
"parameters": {
"color": 4,
"width": 980,
"height": 392,
"content": "### **客户之声 AI 分析与路由**"
},
"typeVersion": 1
},
{
"id": "eff608be-8f8d-4379-a9f0-5ab1beb26b3d",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
32,
960
],
"parameters": {
"color": 6,
"width": 432,
"height": 176,
"content": "## 联系我"
},
"typeVersion": 1
}
],
"connections": {
"Tool: Send Email Alert": {
"ai_tool": [
[
{
"node": "AI Agent: Route Topics to Actions",
"type": "ai_tool",
"index": 0
}
]
]
},
"Set: Initial Parameters": {
"main": [
[
{
"node": "AI Agent: Gather Customer Feedback",
"type": "main",
"index": 0
}
]
]
},
"Config: Set Agent Memory": {
"ai_memory": [
[
{
"node": "AI Agent: Gather Customer Feedback",
"type": "ai_memory",
"index": 0
}
]
]
},
"Tool: Create Notion Page": {
"ai_tool": [
[
{
"node": "AI Agent: Route Topics to Actions",
"type": "ai_tool",
"index": 0
}
]
]
},
"Tool: Get Gmail Messages": {
"ai_tool": [
[
{
"node": "AI Agent: Gather Customer Feedback",
"type": "ai_tool",
"index": 0
}
]
]
},
"AI: Structure Key Signals": {
"ai_outputParser": [
[
{
"node": "AI Chain: Extract Key Signals",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Tool: Get Pipedrive Notes": {
"ai_tool": [
[
{
"node": "AI Agent: Gather Customer Feedback",
"type": "ai_tool",
"index": 0
}
]
]
},
"Tool: Get Zendesk Tickets": {
"ai_tool": [
[
{
"node": "AI Agent: Gather Customer Feedback",
"type": "ai_tool",
"index": 0
}
]
]
},
"Config: Set LLM for Agents": {
"ai_languageModel": [
[
{
"node": "AI: Structure Feedback Data",
"type": "ai_languageModel",
"index": 0
},
{
"node": "AI Agent: Gather Customer Feedback",
"type": "ai_languageModel",
"index": 0
},
{
"node": "AI Chain: Extract Key Signals",
"type": "ai_languageModel",
"index": 0
},
{
"node": "AI Chain: Cluster Signals into Topics",
"type": "ai_languageModel",
"index": 0
},
{
"node": "AI Agent: Route Topics to Actions",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"AI: Structure Feedback Data": {
"ai_outputParser": [
[
{
"node": "AI Agent: Gather Customer Feedback",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Tool: Create Zendesk Ticket": {
"ai_tool": [
[
{
"node": "AI Agent: Route Topics to Actions",
"type": "ai_tool",
"index": 0
}
]
]
},
"AI Chain: Extract Key Signals": {
"main": [
[
{
"node": "AI Chain: Cluster Signals into Topics",
"type": "main",
"index": 0
}
]
]
},
"AI Agent: Gather Customer Feedback": {
"main": [
[
{
"node": "AI Chain: Extract Key Signals",
"type": "main",
"index": 0
}
]
]
},
"Manual Trigger: Start VOC Analysis": {
"main": [
[
{
"node": "Set: Initial Parameters",
"type": "main",
"index": 0
}
]
]
},
"AI Chain: Cluster Signals into Topics": {
"main": [
[
{
"node": "AI Agent: Route Topics to Actions",
"type": "main",
"index": 0
}
]
]
},
"Tool: Search Slack Messages Export to Sheets": {
"ai_tool": [
[
{
"node": "AI Agent: Gather Customer Feedback",
"type": "ai_tool",
"index": 0
}
]
]
},
"AI: Structure Clustered Topics Export to Sheets": {
"ai_outputParser": [
[
{
"node": "AI Chain: Cluster Signals into Topics",
"type": "ai_outputParser",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
通过AI分析HubSpot和Google Sheets数据预测客户流失
通过AI分析HubSpot和Google Sheets数据预测客户流失
Set
Code
Merge
+17
27 节点PollupAI
客户关系管理
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
使用 Browserflow 和 Google Sheets 自动化 LinkedIn 请求与破冰消息
使用 Browserflow 和 Google Sheets 自动化 LinkedIn 请求与破冰消息
If
Set
Sort
+15
44 节点PollupAI
销售
支持工单分类与路由自动化
使用GPT自动化从HubSpot到Jira的支持工单分类与路由
Set
Jira
Switch
+12
23 节点PollupAI
AI 摘要总结
高级多代理AI个人助手（250+任务能力，WhatsApp + GPT）
高级多代理AI个人助手（250+任务能力，WhatsApp + GPT）
Set
Switch
Whats App
+26
213 节点Electrabot
个人效率
博客WordPress复制销售
使用GPT-4、Perplexity AI和WordPress自动化SEO博客内容创建
Set
Code
Notion
+16
39 节点LukaszB
人工智能
工作流信息
难度等级
高级
节点数量23
分类-
节点类型13
作者
PollupAI
@zeerobugWe create bespoke AI solutions, automations and agents that help your business as it scales.
外部链接
在 n8n.io 查看 →
分享此工作流