AI驱动的反馈分诊系统：Jotform到Trello、Airtable和Slack，集成Gemini
高级
这是一个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": {
"Config": {
"main": [
[
{
"node": "AI Feedback Triage",
"type": "main",
"index": 0
}
]
]
},
"Email Provided?": {
"main": [
[
{
"node": "Send Confirmation Email",
"type": "main",
"index": 0
}
],
[
{
"node": "Skip Confirmation Email",
"type": "main",
"index": 0
}
]
]
},
"JotForm Trigger": {
"main": [
[
{
"node": "Config",
"type": "main",
"index": 0
},
{
"node": "Email Provided?",
"type": "main",
"index": 0
}
]
]
},
"AI Feedback Triage": {
"main": [
[
{
"node": "Is it a Bug or Feature?",
"type": "main",
"index": 0
}
]
]
},
"Create Trello Card": {
"main": [
[
{
"node": "Is it an Urgent Bug?",
"type": "main",
"index": 0
}
]
]
},
"Is it an Urgent Bug?": {
"main": [
[
{
"node": "Alert Dev Team",
"type": "main",
"index": 0
}
],
[
{
"node": "No Alert Needed",
"type": "main",
"index": 0
}
]
]
},
"Is it a Bug or Feature?": {
"main": [
[
{
"node": "Create Trello Card",
"type": "main",
"index": 0
}
],
[
{
"node": "Log General Feedback to Airtable",
"type": "main",
"index": 0
}
]
]
},
"Google Gemini Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Feedback Triage",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "AI Feedback Triage",
"type": "ai_outputParser",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
这是一个高级难度的工作流，适用于Market Research、AI Summarization等场景。适合高级用户，包含 16+ 个节点的复杂工作流
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用Gemini AI筛选求职者：Jotform到Notion招聘流程
使用Gemini AI筛选求职者：Jotform到Notion招聘流程
If
Gmail
Merge
+10
20 节点Atta
HR
使用Gemini AI视觉分析与Telegram警报监控X平台品牌提及
使用Gemini AI视觉分析与Telegram警报监控X平台品牌提及
If
Set
Code
+13
24 节点Atta
Miscellaneous
使用JotForm、Gemini AI和Slack的线索资质判定与评分
使用JotForm、Gemini AI和Slack的线索资质判定与评分
If
Gmail
Slack
+7
17 节点Atta
基于Google Gemini的智能LinkedIn职位筛选，含简历匹配和Google地图
基于Google Gemini的智能LinkedIn职位筛选，含简历匹配和Google地图
If
Set
Supabase
+10
26 节点Atta
Personal Productivity
使用 Bright Data API 和 AI 抓取分析 Google 广告并发送邮件报告
使用 Bright Data API 和 AI 抓取分析 Google 广告并发送邮件报告
Set
Code
Gmail
+15
45 节点Zacharia Kimotho
Market Research
23 分析客户终身价值
使用GPT-4和Bright Data MCP分析与定位高价值客户
If
Set
Code
+9
20 节点Yaron Been
Market Research
工作流信息
难度等级
高级
节点数量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 上查看 →
分享此工作流