AI自动化反馈处理
中级
这是一个Marketing领域的自动化工作流，包含 9 个节点。主要使用 If, WhatsApp, EmailSend, FormTrigger, GoogleSheets 等节点。 使用表单、AI、Google表格和WhatsApp自动分析客户反馈
前置要求
- •Google Sheets API 凭证
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "h47UJYYjZeKuBLTn",
"meta": {
"instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
"templateCredsSetupCompleted": true
},
"name": "AI自动化反馈处理",
"tags": [],
"nodes": [
{
"id": "553d9f71-a750-4152-84bb-9d2956441aa8",
"name": "表单提交时",
"type": "n8n-nodes-base.formTrigger",
"position": [
260,
220
],
"webhookId": "998e3daa-1e42-4a50-913f-e0dfb10b66b7",
"parameters": {
"options": {
"path": "feedback",
"customCss": "",
"appendAttribution": false
},
"formTitle": "Customer Feedback Questions for IT Services",
"formFields": {
"values": [
{
"fieldLabel": "What is your Name?",
"requiredField": true
},
{
"fieldType": "email",
"fieldLabel": "Email ID",
"requiredField": true
},
{
"fieldLabel": "Contact Number",
"placeholder": "(e.g, +1234567890)",
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "How satisfied are you with the quality of our IT services or solutions?",
"fieldOptions": {
"values": [
{
"option": "Very Dissatisfied"
},
{
"option": "Dissatisfied"
},
{
"option": "Neutral"
},
{
"option": "Satisfied"
},
{
"option": "Very Satisfied"
}
]
},
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "Did our team understand your technical requirements clearly?",
"fieldOptions": {
"values": [
{
"option": "Yes"
},
{
"option": "No"
}
]
},
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "How would you rate our communication throughout the project/support process?",
"fieldOptions": {
"values": [
{
"option": "Poor"
},
{
"option": "Fair"
},
{
"option": "Good"
},
{
"option": "Excellent"
}
]
},
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "Was your project/service delivered on time and within the expected timeline?",
"fieldOptions": {
"values": [
{
"option": "Yes"
},
{
"option": "No"
}
]
},
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "Did our solution meet your business needs or solve your problem effectively?",
"fieldOptions": {
"values": [
{
"option": "Yes"
},
{
"option": "No"
}
]
},
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "How responsive was our support team when you needed assistance?",
"fieldOptions": {
"values": [
{
"option": "Slow"
},
{
"option": "Average"
},
{
"option": "Fast"
},
{
"option": "Very Fast"
}
]
},
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "How would you rate the technical expertise of our team?",
"fieldOptions": {
"values": [
{
"option": "1"
},
{
"option": "2"
},
{
"option": "3"
},
{
"option": "4"
},
{
"option": "5"
}
]
},
"requiredField": true
},
{
"fieldType": "textarea",
"fieldLabel": "What could we do to improve your experience with our IT services?",
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "Would you recommend our IT services to others?",
"fieldOptions": {
"values": [
{
"option": "Yes"
},
{
"option": "=No"
}
]
},
"requiredField": true
},
{
"fieldType": "textarea",
"fieldLabel": "Any additional comments or suggestions?",
"requiredField": true
}
]
}
},
"notesInFlow": false,
"typeVersion": 2.2
},
{
"id": "0f02714d-0da3-4f86-ba62-97ce92883201",
"name": "如果同时提供邮箱和手机号",
"type": "n8n-nodes-base.if",
"position": [
520,
440
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "8cc5cb6d-8aee-4547-bb67-aa8465789473",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.Phone.toString() }}",
"rightValue": ""
},
{
"id": "2a0ba5ea-f76c-4cf2-9b77-6fc0e2d269da",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.Email }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "2890694e-c503-4eda-825b-b569e7f8831a",
"name": "如果仅提供手机号",
"type": "n8n-nodes-base.if",
"position": [
520,
640
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "84c363c4-8ae2-4b56-b9f7-a83de196be4b",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.Phone.toString() }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "cf9d2612-b582-4352-809e-31a38f4126b5",
"name": "通过Whatsapp发送消息",
"type": "n8n-nodes-base.whatsApp",
"notes": "Set the WhatsApp template from the WhatsApp Business Account.",
"position": [
780,
620
],
"webhookId": "857eab1a-f5e2-4937-be2c-90b47bae3947",
"parameters": {
"template": "feedback_n8n|en_US",
"components": {
"component": [
{
"bodyParameters": {
"parameter": [
{
"text": "={{ $('Google Sheets Trigger').item.json.User }}"
}
]
}
}
]
},
"phoneNumberId": "550325331503475",
"recipientPhoneNumber": "={{ $json.Phone.toString() }}"
},
"credentials": {
"whatsAppApi": {
"id": "3hy4gzpVJrY1sFcR",
"name": "WhatsApp account API"
}
},
"typeVersion": 1
},
{
"id": "ce02dda2-111e-4bde-99a9-393547c40435",
"name": "Google Sheets 触发器",
"type": "n8n-nodes-base.googleSheetsTrigger",
"notes": "Set Google Credentials and then select Google Sheets.\nSelect the Sheet on which you want to set the trigger.\n\nIf any changes are made to the selected Sheet. Node will trigger.",
"position": [
200,
520
],
"parameters": {
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": ""
},
"documentId": {
"__rl": true,
"mode": "list",
"value": ""
}
},
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"id": "9XWklJMdHOljJ9Ar",
"name": "Google Sheets Trigger account"
}
},
"notesInFlow": false,
"typeVersion": 1
},
{
"id": "153adc14-68c1-4b4d-bb93-8dc5204ec7e9",
"name": "Google Sheets1",
"type": "n8n-nodes-base.googleSheets",
"notes": "Follow this steps:\n- Set Google Credentials and then select Google Sheets account.\n- Select \"Sheet Within Document\" option in Resource tab.\n- Select \"Append or Update Row\" in Operation tab.\n- In Document tab select your google sheets which you want to update.\n- In Sheets tab select sheet from your google sheets document.\n- In Mapping select \"Map Each Column Manually\"\n- Now from list of colums select colum which you want to match from selected sheet. The column to use when matching rows in Google Sheets to the input items of this node. Usually an ID.\n- Now you can see all colume in \"Values to Send\" section. Here you need to map (using drag and drop) the filed with the form filed name. ",
"position": [
520,
220
],
"parameters": {
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": ""
},
"documentId": {
"__rl": true,
"mode": "list",
"value": ""
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "rgIk6EXVdPbmPYAl",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "65b5cb47-12d0-42a5-bb95-c023710dd310",
"name": "邮箱",
"type": "n8n-nodes-base.emailSend",
"position": [
780,
420
],
"webhookId": "4f5aacbc-7967-44c0-9e24-00472ec25b48",
"parameters": {
"text": "Please give us your valuable feedback at:\n<<< Your Form Production URL >>>",
"options": {
"appendAttribution": false
},
"subject": "Feedback",
"toEmail": "={{ $json.Email }}",
"fromEmail": "XYZ@gmail.com",
"emailFormat": "text"
},
"credentials": {
"smtp": {
"id": "3QSx1pWoS0BZcK4c",
"name": "SMTP account"
}
},
"typeVersion": 2.1
},
{
"id": "457b43d6-fa50-4259-bf56-b637b1819445",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-240,
140
],
"parameters": {
"width": 380,
"height": 600,
"content": "## Google Sheets集成"
},
"typeVersion": 1
},
{
"id": "cc0786b3-2340-4fa1-812b-49dc76a3ef0d",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-240,
20
],
"parameters": {
"width": 380,
"height": 100,
"content": "## 集成说明"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "481b316a-890a-4a24-812a-b402638ff547",
"connections": {
"On form submission": {
"main": [
[
{
"node": "Google Sheets1",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets Trigger": {
"main": [
[
{
"node": "If E-mail and Phone Number Both are given",
"type": "main",
"index": 0
},
{
"node": "If only Phone Number is given",
"type": "main",
"index": 0
}
]
]
},
"Send Message on Whatsapp": {
"main": [
[]
]
},
"If only Phone Number is given": {
"main": [
[
{
"node": "Send Message on Whatsapp",
"type": "main",
"index": 0
}
],
[]
]
},
"If E-mail and Phone Number Both are given": {
"main": [
[
{
"node": "Email",
"type": "main",
"index": 0
}
],
[]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 营销
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
LinkedIn潜在客户抓取与数据丰富副本
使用Apollo.io、LinkedIn API、Mail.so和GPT-3.5生成并丰富LinkedIn潜在客户
If
Set
Code
+8
53 节点Joseph
销售
LinkedIn自动连接与销售个性化消息
LinkedIn自动连接与销售个性化消息
If
Set
Wait
+12
32 节点Vansh Arora
销售
社交媒体分析与自动邮件生成
社交媒体分析与自动邮件生成
If
Set
Code
+8
19 节点PollupAI
人工智能
潜在客户生成系统的唯一QR码优惠券分配和验证
基于SuiteCRM的潜在客户生成系统唯一QR码优惠券分配和验证
If
Set
Webhook
+6
29 节点Davide
销售
🔐 双重确认邮件验证系统（使用Google Sheets）
🔐 使用Google Sheets的双重确认邮件验证系统
If
Code
Form
+5
24 节点Un tal Camilo Medina
营销
AI 招聘省时助手 - 自动化筛选、评估、提醒和面试
AI 招聘省时助手 - 自动化筛选、评估、提醒和面试
If
Slack
Switch
+17
60 节点Aayushman Sharma
人力资源
工作流信息
难度等级
中级
节点数量9
分类1
节点类型7
作者
OneClick IT Consultancy P Limited
@oneclick-itOneClick is an award-winning offshore software development services company. Clients trust us for quality of service, innovation and AI driven technology solutions.
外部链接
在 n8n.io 查看 →
分享此工作流