AI驱动的反馈分诊系统
高级
这是一个Market Research, AI Summarization领域的自动化工作流，包含 21 个节点。主要使用 If, Set, Gmail, Slack, Trello 等节点。 AI驱动的反馈分诊系统：Jotform到Trello、Airtable和Slack，集成Gemini
前置要求
- •Google 账号和 Gmail API 凭证
- •Slack Bot Token 或 Webhook URL
- •Airtable API Key
- •Google Gemini API Key
使用的节点 (21)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "51295e4a2441063c8b3c5b0c823451e48c57f5baaf713c6f2f9d792402274528",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "f29975d2-a156-411b-a647-168cbb517d94",
"name": "JotForm 触发器",
"type": "n8n-nodes-base.jotFormTrigger",
"position": [
-288,
0
],
"webhookId": "323a975b-6b2e-4b03-aeef-169e8e8e7075",
"parameters": {
"form": "252934846764067"
},
"credentials": {
"jotFormApi": {
"id": "0rXRUH1s8t1hYA56",
"name": "JotForm account"
}
},
"typeVersion": 1
},
{
"id": "693d8fe9-0b13-455e-9719-229e9758edea",
"name": "AI 反馈分类",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1056,
0
],
"parameters": {
"text": "=You are an expert product manager's assistant, responsible for triaging all incoming feedback.\n\nA user has submitted the following feedback:\n\"{{ $('JotForm Trigger').item.json['Feedback Details'] }}\"\n\nPlease analyze this feedback and follow these steps:\n1. First, create a short, clear `task_title` for it.\n2. Second, determine the `category`. Is this a 'Bug' (something is broken), a 'Feature Request' (a new idea), or 'General Feedback' (an opinion or comment)?\n3. Third, assess the `suggested_priority` based on the user's tone and the potential impact described.\n4. Fourth, extract an array of relevant `tags` (keywords).\n\nProvide your final analysis ONLY in the requested JSON format.",
"options": {},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2.2
},
{
"id": "212689e8-f1ab-4fbc-bdcd-ca9a69041c7e",
"name": "多表：您可以连接多个表以实现有组织的数据结构",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
1248,
208
],
"parameters": {
"jsonSchemaExample": "{\n \"task_title\": \"A short, 5-10 word title for this feedback\",\n \"category\": \"Must be one of: 'Bug', 'Feature Request', or 'General Feedback'\",\n \"suggested_priority\": \"Must be one of: 'High', 'Medium', or 'Low'\",\n \"tags\": [\n \"keyword1\",\n \"keyword2\"\n ]\n}"
},
"typeVersion": 1.3
},
{
"id": "61f942ca-9996-4802-9303-c31dd5731ac7",
"name": "Google Gemini 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
1056,
208
],
"parameters": {
"options": {}
},
"credentials": {
"googlePalmApi": {
"id": "mzeuL0IEjP3FgRof",
"name": "Google Gemini(PaLM) Api account"
}
},
"typeVersion": 1
},
{
"id": "70ce77fe-3fe2-4de0-a172-45dd42410dde",
"name": "是错误还是功能？",
"type": "n8n-nodes-base.if",
"position": [
1568,
0
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "or",
"conditions": [
{
"id": "9001cb9f-6160-40df-9fc9-a94c8852b4ea",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.output.category.trim().toLowerCase() }}",
"rightValue": "bug"
},
{
"id": "6acdcfdc-70be-4f7d-be5b-5103b9a38067",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.output.category.trim().toLowerCase() }}",
"rightValue": "feature request"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "2dd9abbb-3333-43a0-b595-1fba66b4b7ed",
"name": "创建 Trello 卡片",
"type": "n8n-nodes-base.trello",
"position": [
2016,
-352
],
"parameters": {
"name": "={{ $('AI Feedback Triage').item.json.output.task_title }}",
"listId": "={{ $json.output.category.trim().toLowerCase() === 'bug' ? '68f7a8a8d35b96b34942f6f4' : '68f7a8a8d35b96b34942f6f3' }}",
"description": "=**反馈来源：**",
"additionalFields": {
"pos": "top",
"idLabels": "={{ (['Customer', 'Staff', 'Other'].includes($('JotForm Trigger').item.json['I am a...']) ? ($('JotForm Trigger').item.json['I am a...'] === 'Customer' ? $('Config').item.json.customer_label_id : ($('JotForm Trigger').item.json['I am a...'] === 'Staff' ? $('Config').item.json.staff_label_id : $('Config').item.json.other_label_id)) : '') + ($('AI Feedback Triage').item.json.output.suggested_priority.trim().toLowerCase() === 'high' ? ','+$('Config').item.json.urgent_label_id : '') }}"
}
},
"credentials": {
"trelloApi": {
"id": "PT1lBr6mfSo72DbH",
"name": "Trello account"
}
},
"typeVersion": 1
},
{
"id": "fae71b7e-5c81-4dca-a092-cf5a9ba66842",
"name": "配置",
"type": "n8n-nodes-base.set",
"position": [
416,
0
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "c320b912-9afe-4bfd-83b9-350b424ab39e",
"name": "feature_backlog_list_id",
"type": "string",
"value": "68f7a8a8d35b96b34942f6f3"
},
{
"id": "34354023-c982-4c78-9ca8-bf190453d2d0",
"name": "bugs_list_id",
"type": "string",
"value": "68f7a8a8d35b96b34942f6f4"
},
{
"id": "875f9be5-98fb-4ec3-8c4a-354444cc55fe",
"name": "customer_label_id",
"type": "string",
"value": "68f7a8a8d35b96b34942f6f1"
},
{
"id": "bbec900c-74a9-4160-8610-ce28d19bb21b",
"name": "staff_label_id",
"type": "string",
"value": "68f7a8a8d35b96b34942f6ec"
},
{
"id": "2b94d809-8ef3-4fca-8a2d-1a3e6f928a64",
"name": "other_label_id",
"type": "string",
"value": "68f7ae69d2c2a4e0e83d8f75"
},
{
"id": "ac6ca56e-d753-43ec-a589-dd14ec828f27",
"name": "urgent_label_id",
"type": "string",
"value": "68f7a8a8d35b96b34942f6ef"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "3c4059e5-4321-4f1c-9f78-54ba336ce9ee",
"name": "将一般反馈记录到 Airtable",
"type": "n8n-nodes-base.airtable",
"position": [
2016,
128
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appKqfaCnM6Ea50x6",
"cachedResultUrl": "https://airtable.com/appKqfaCnM6Ea50x6",
"cachedResultName": "Product Feedback Log"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblfQMf9cDi9LSds4",
"cachedResultUrl": "https://airtable.com/appKqfaCnM6Ea50x6/tblfQMf9cDi9LSds4",
"cachedResultName": "Feedback Submissions"
},
"columns": {
"value": {
"Email": "={{ $('JotForm Trigger').item.json['Your Email (Optional)'] ? $('JotForm Trigger').item.json['Your Email (Optional)'] : '' }}",
"Source": "={{ $('JotForm Trigger').item.json['I am a...'] }}",
"AI Tags": "={{ $('AI Feedback Triage').item.json.output.tags }}",
"Full Feedback": "={{ $('JotForm Trigger').item.json['Feedback Details'] }}",
"Feedback Summary": "={{ $('AI Feedback Triage').item.json.output.task_title }}"
},
"schema": [
{
"id": "Feedback Summary",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Feedback Summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Full Feedback",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Full Feedback",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Source",
"type": "options",
"display": true,
"options": [
{
"name": "Customer",
"value": "Customer"
},
{
"name": "Staff",
"value": "Staff"
},
{
"name": "Other",
"value": "Other"
}
],
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Source",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "AI Tags",
"type": "array",
"display": true,
"options": [],
"removed": false,
"readOnly": false,
"required": false,
"displayName": "AI Tags",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Submitted At",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Submitted At",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {
"typecast": true
},
"operation": "create"
},
"credentials": {
"airtableTokenApi": {
"id": "jOvZXtRgEMuq8MFN",
"name": "Airtable Personal Access Token account"
}
},
"typeVersion": 2.1
},
{
"id": "655b2db1-987c-49a8-885c-2edb58c5cdd2",
"name": "是紧急错误吗？",
"type": "n8n-nodes-base.if",
"position": [
2464,
-352
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e7be6c85-a279-4c6a-b23d-a4aa8128d11e",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('AI Feedback Triage').item.json.output.category.trim().toLowerCase() }}",
"rightValue": "bug"
},
{
"id": "7a704de2-e3b4-438a-bc65-c9eb9966ef0e",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('AI Feedback Triage').item.json.output.suggested_priority.trim().toLowerCase() }}",
"rightValue": "high"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "979cb2ef-f5d1-4a2e-80a8-3043faf89427",
"name": "提醒开发团队",
"type": "n8n-nodes-base.slack",
"position": [
2848,
-544
],
"webhookId": "85577b91-fe0e-44a9-bd7a-983f561e548b",
"parameters": {
"text": "=🚨 *High Priority Bug Reported!* 🚨\n\n*Title:* {{ $('AI Feedback Triage').item.json.output.task_title }}\n*Source:* {{ $('JotForm Trigger').item.json['I am a...'] }}\n*Feedback:* {{ $('JotForm Trigger').item.json['Feedback Details'] }}\n\n*Trello Card:*\n{{ $('Create Trello Card').item.json.shortUrl }}",
"select": "channel",
"channelId": {
"__rl": true,
"mode": "list",
"value": "C09MQB3PWUE",
"cachedResultName": "dev-alerts"
},
"otherOptions": {
"includeLinkToWorkflow": false
}
},
"credentials": {
"slackApi": {
"id": "yP6Hr4wJ20zxMNey",
"name": "Slack account"
}
},
"typeVersion": 2.3
},
{
"id": "fd3fd616-10fb-4f26-b79e-22b0529ad6ca",
"name": "无需提醒",
"type": "n8n-nodes-base.noOp",
"position": [
2864,
-224
],
"parameters": {},
"typeVersion": 1
},
{
"id": "05b38448-f651-4c56-9340-0a40a9ed851a",
"name": "提供了电子邮件吗？",
"type": "n8n-nodes-base.if",
"position": [
224,
432
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "21dc6a68-9229-48e5-a568-ea317dc94223",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json['Your Email (Optional)'] }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "e003b999-4797-47e9-8e92-6ac237e74da8",
"name": "发送确认邮件",
"type": "n8n-nodes-base.gmail",
"position": [
496,
288
],
"webhookId": "39c13fca-decb-4938-8207-e3153b2ed2c4",
"parameters": {
"sendTo": "={{ $json['Your Email (Optional)'] }}",
"message": "=Hi there,\n\nThanks for taking the time to share your feedback about IdeaToBiz.\n\nThis email confirms we've received your submission. Our product team reviews all feedback as we work to improve the platform.\n\nBest regards,\nThe IdeaToBiz Team",
"options": {
"appendAttribution": false
},
"subject": "Thanks for your feedback on IdeaToBiz!",
"emailType": "text"
},
"credentials": {
"gmailOAuth2": {
"id": "8kdHW2rLvRIwn673",
"name": "Gmail account"
}
},
"typeVersion": 2.1
},
{
"id": "36232076-daa5-453b-9e00-d3d4c5c5db26",
"name": "跳过确认邮件",
"type": "n8n-nodes-base.noOp",
"position": [
496,
528
],
"parameters": {},
"typeVersion": 1
},
{
"id": "30c0174d-d658-458f-b5d0-f473a639479e",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-576,
-944
],
"parameters": {
"color": 5,
"width": 672,
"height": 1104,
"content": "## 🚪 设置您的反馈表单"
},
"typeVersion": 1
},
{
"id": "fc29f80e-47b3-4683-a218-f0f41bf73fc8",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1392,
-944
],
"parameters": {
"color": 5,
"width": 800,
"height": 1104,
"content": "## 表单预览"
},
"typeVersion": 1
},
{
"id": "68baa9dc-d231-49c1-99c2-c346f5f440f8",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
144,
-416
],
"parameters": {
"color": 6,
"width": 624,
"height": 576,
"content": "## 🔑 输入您的 Trello ID"
},
"typeVersion": 1
},
{
"id": "c0dd48ad-7b79-40d9-ba7a-877f0cb7bbb8",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
816,
-480
],
"parameters": {
"color": 3,
"width": 688,
"height": 848,
"content": "## 🧠 AI 分析"
},
"typeVersion": 1
},
{
"id": "a23cd654-0bb0-4ee0-bb44-c441f4fa63e2",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1760,
-848
],
"parameters": {
"width": 608,
"height": 672,
"content": "## 创建可执行任务"
},
"typeVersion": 1
},
{
"id": "3adf6775-dec1-4009-89a2-8a1c1bf82b82",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1760,
96
],
"parameters": {
"color": 4,
"width": 608,
"height": 752,
"content": "## 记录非可执行反馈"
},
"typeVersion": 1
},
{
"id": "8da4c83f-8654-4404-9dd4-868d5e07d1cf",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
2608,
-944
],
"parameters": {
"color": 2,
"width": 592,
"height": 560,
"content": "## 提醒团队关于紧急错误"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"fae71b7e-5c81-4dca-a092-cf5a9ba66842": {
"main": [
[
{
"node": "693d8fe9-0b13-455e-9719-229e9758edea",
"type": "main",
"index": 0
}
]
]
},
"05b38448-f651-4c56-9340-0a40a9ed851a": {
"main": [
[
{
"node": "e003b999-4797-47e9-8e92-6ac237e74da8",
"type": "main",
"index": 0
}
],
[
{
"node": "36232076-daa5-453b-9e00-d3d4c5c5db26",
"type": "main",
"index": 0
}
]
]
},
"f29975d2-a156-411b-a647-168cbb517d94": {
"main": [
[
{
"node": "fae71b7e-5c81-4dca-a092-cf5a9ba66842",
"type": "main",
"index": 0
},
{
"node": "05b38448-f651-4c56-9340-0a40a9ed851a",
"type": "main",
"index": 0
}
]
]
},
"693d8fe9-0b13-455e-9719-229e9758edea": {
"main": [
[
{
"node": "70ce77fe-3fe2-4de0-a172-45dd42410dde",
"type": "main",
"index": 0
}
]
]
},
"2dd9abbb-3333-43a0-b595-1fba66b4b7ed": {
"main": [
[
{
"node": "655b2db1-987c-49a8-885c-2edb58c5cdd2",
"type": "main",
"index": 0
}
]
]
},
"655b2db1-987c-49a8-885c-2edb58c5cdd2": {
"main": [
[
{
"node": "979cb2ef-f5d1-4a2e-80a8-3043faf89427",
"type": "main",
"index": 0
}
],
[
{
"node": "fd3fd616-10fb-4f26-b79e-22b0529ad6ca",
"type": "main",
"index": 0
}
]
]
},
"70ce77fe-3fe2-4de0-a172-45dd42410dde": {
"main": [
[
{
"node": "2dd9abbb-3333-43a0-b595-1fba66b4b7ed",
"type": "main",
"index": 0
}
],
[
{
"node": "3c4059e5-4321-4f1c-9f78-54ba336ce9ee",
"type": "main",
"index": 0
}
]
]
},
"61f942ca-9996-4802-9303-c31dd5731ac7": {
"ai_languageModel": [
[
{
"node": "693d8fe9-0b13-455e-9719-229e9758edea",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"212689e8-f1ab-4fbc-bdcd-ca9a69041c7e": {
"ai_outputParser": [
[
{
"node": "693d8fe9-0b13-455e-9719-229e9758edea",
"type": "ai_outputParser",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 市场调研, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用JotForm、Gemini AI和Slack的线索资质判定与评分
使用JotForm、Gemini AI和Slack的线索资质判定与评分
If
Gmail
Slack
+
If
Gmail
Slack
17 节点Atta
23 分析客户终身价值
使用GPT-4和Bright Data MCP分析与定位高价值客户
If
Set
Code
+
If
Set
Code
20 节点Yaron Been
市场调研
AI邮件分诊与GPT-4警报系统及Telegram通知
AI邮件分诊与GPT-4警报系统及Telegram通知
If
Set
Gmail
+
If
Set
Gmail
104 节点Peter Joslyn
客户支持
亚马逊价格自动追踪与Telegram提醒
使用Google Gemini自动追踪亚马逊价格并发送Telegram提醒
If
Set
Code
+
If
Set
Code
22 节点Issam AGGOUR
市场调研
Twitter监控工作流
使用OpenAI、Google表格和Slack提醒自动化Twitter情感分析
If
Set
Slack
+
If
Set
Slack
15 节点InfyOm Technologies
市场调研
4跟踪竞争对手网站更新
使用Bright Data MCP和OpenAI的自动竞争对手价格监控
If
Set
Google Sheets
+
If
Set
Google Sheets
18 节点Yaron Been
市场调研
工作流信息
难度等级
高级
节点数量21
分类2
节点类型12
作者
Atta
@attakhalighiHi 👋 I design automation workflows with n8n, AI, and custom APIs. My focus is on building reliable systems that save time and boost productivity. Always happy to answer questions about my templates.
外部链接
在 n8n.io 查看 →
分享此工作流