客户评价收集与GPT-4分析、Jotform、Gmail和Google表格
中级
这是一个自动化工作流，包含 15 个节点。主要使用 Set, Code, Gmail, GoogleSheets, JotFormTrigger 等节点。 使用Jotform、Gmail和Google表格收集客户评价，并通过GPT-4进行分析
前置要求
- •Google 账号和 Gmail API 凭证
- •Google Sheets API 凭证
- •OpenAI API Key
分类
-
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "277842713620d9f5554de3b1518b865a152c8c4db680008bd8aec536fc18b4a8"
},
"nodes": [
{
"id": "111a0f7d-7e79-4bce-9499-31f9b05de3c4",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-784,
16
],
"parameters": {
"color": 4,
"width": 360,
"height": 472,
"content": "客户推荐收集器 - 目的：通过AI驱动的分析将零散的推荐转化为有组织的营销资产。主要功能：集中式推荐提交、AI语气和情感检测、自动引用提取、营销就绪内容日志、自动感谢与奖励、社交媒体优化。影响：推荐收集量增加500%，即时生成营销资产"
},
"typeVersion": 1
},
{
"id": "7dd98765-6e75-49fb-85d5-0b3c8f4c4a3e",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-384,
-16
],
"parameters": {
"color": 5,
"width": 340,
"height": 524,
"content": "Jotform推荐字段：客户姓名、客户邮箱、公司名称、职位、使用的产品或服务、推荐文本、评分、分享许可、照片上传、用例或行业。在Jotform上免费创建您的表单"
},
"typeVersion": 1
},
{
"id": "296a41d8-94ff-4eb0-9d73-0e192e5a315b",
"name": "提取推荐数据",
"type": "n8n-nodes-base.set",
"position": [
-192,
352
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "customer_name",
"name": "customerName",
"type": "string",
"value": "={{ $json['Customer Name'] }}"
},
{
"id": "customer_email",
"name": "customerEmail",
"type": "string",
"value": "={{ $json['Customer email'] }}"
},
{
"id": "company_name",
"name": "companyName",
"type": "string",
"value": "={{ $json['Company Name'] }}"
},
{
"id": "product_service",
"name": "productService",
"type": "string",
"value": "={{ $json['Product/service'] }}"
},
{
"id": "testimonial_text",
"name": "testimonialText",
"type": "string",
"value": "={{ $json['Testimonial Text'] }}"
},
{
"id": "rating",
"name": "rating",
"type": "number",
"value": "={{ $json.Rating }}"
},
{
"id": "submitted_at",
"name": "submittedAt",
"type": "string",
"value": "={{ $now.toISO() }}"
}
]
}
},
"typeVersion": 3.3
},
{
"id": "cb2f4ae6-07c1-4441-9634-b719bc13e196",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-16,
0
],
"parameters": {
"color": 6,
"width": 408,
"height": 508,
"content": "AI推荐分析 - AI分析内容：语气和情感、最佳引用提取、提到的关键优势、情感影响评分、营销用例、社交媒体优化。输出：营销就绪的资产"
},
"typeVersion": 1
},
{
"id": "3019c6a9-0a80-4fda-82dc-3d9f5753c1d0",
"name": "AI推荐分析",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
0,
304
],
"parameters": {
"text": "Analyze this customer testimonial and extract marketing insights. Customer name, Company, Title, Product, Rating out of 5, and Testimonial text provided. Return JSON with: overallTone, sentimentScore 0-100, emotionalImpact, authenticity, bestQuote max 280 chars, alternateQuotes array, keyBenefitsMentioned array, painPointsAddressed array, specificResults array, marketingUseCase, targetAudience, twitterVersion 280 chars, linkedinVersion 150 words, websiteVersion 50-75 words, headlineVersion 10 words, calloutWords array, marketingPriority high medium or low",
"agent": "conversationalAgent",
"options": {
"systemMessage": "You are a marketing copywriter. Extract compelling elements from testimonials and optimize for marketing channels."
},
"promptType": "define"
},
"typeVersion": 1.6
},
{
"id": "4dbf0dde-e75d-4e36-9fa5-7482747cd2f2",
"name": "解析AI分析",
"type": "n8n-nodes-base.set",
"position": [
272,
304
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "919aa6bf-5541-4f2d-81a0-54fe9b2bf141",
"name": "output",
"type": "string",
"value": "={{ $json.output }}"
}
]
}
},
"typeVersion": 3.3
},
{
"id": "b679a227-4334-40a8-b017-f19c6f134fa9",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
416,
-48
],
"parameters": {
"color": 2,
"width": 340,
"height": 524,
"content": "推荐内容日志 - Google Sheets数据库：完整的推荐详情、AI分析和引用、营销版本、许可跟踪、可搜索库。实现：轻松营销访问"
},
"typeVersion": 1
},
{
"id": "d30e7007-322b-43c1-9f82-809a3627e365",
"name": "记录到推荐库",
"type": "n8n-nodes-base.googleSheets",
"position": [
512,
192
],
"parameters": {
"columns": {
"value": {
"email": "={{ $('Jotform Trigger').item.json['Customer email'] }}",
"rating": "={{ $('Jotform Trigger').item.json.Rating }}",
"compnay name": "={{ $('Jotform Trigger').item.json['Company Name'] }}",
"Customer name ": "={{ $('Jotform Trigger').item.json['Customer Name'] }}",
"product/service": "={{ $('Jotform Trigger').item.json['Product/service'] }}",
"testiminial text": "={{ $('Jotform Trigger').item.json['Testimonial Text'] }}"
},
"schema": [
{
"id": "Customer name ",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Customer name ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "rating",
"type": "string",
"display": true,
"required": false,
"displayName": "rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "compnay name",
"type": "string",
"display": true,
"required": false,
"displayName": "compnay name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "testiminial text",
"type": "string",
"display": true,
"required": false,
"displayName": "testiminial text",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "product/service",
"type": "string",
"display": true,
"required": false,
"displayName": "product/service",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Customer name "
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "name",
"value": "Sheet2"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1K0lqkb-z0fbdb_pEUDtUfl5N2jQ_nT-YEQtylwB4968",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1K0lqkb-z0fbdb_pEUDtUfl5N2jQ_nT-YEQtylwB4968/edit?usp=drivesdk",
"cachedResultName": "Fleet"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "",
"name": ""
}
},
"typeVersion": 4.4
},
{
"id": "fc5e67db-7ab5-4288-a1c4-bcba869b71b7",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
928,
-48
],
"parameters": {
"color": 3,
"width": 340,
"height": 440,
"content": "客户感谢 - 自动化邮件：感谢客户、展示使用预览、独家优惠码、推荐激励、社交分享版本。驱动：忠诚度和倡导"
},
"typeVersion": 1
},
{
"id": "8d2e5076-9867-4ceb-8867-9fcb910e2380",
"name": "生成优惠码",
"type": "n8n-nodes-base.code",
"position": [
656,
352
],
"parameters": {
"jsCode": "const jotformData = items[0].json;\nconst customerName = jotformData['Customer Name'] || 'Customer';\nconst rating = parseInt(jotformData.Rating) || 3;\n\nconst namePart = customerName.substring(0, 5).replace(/\\s/g, '');\nconst randomNum = Math.floor(Math.random() * 9999);\nconst couponCode = 'THANKS' + namePart + randomNum;\n\nlet discountPercent = 10;\nif (rating === 5) {\n discountPercent = 20;\n} else if (rating === 4) {\n discountPercent = 15;\n}\n\nconst expiryDate = new Date(Date.now() + 30 * 24 * 60 * 60 * 1000).toISOString().slice(0, 10);\n\nreturn [{\n json: {\n couponCode: couponCode,\n discountPercent: discountPercent,\n expiryDays: 30,\n expiryDate: expiryDate,\n customerName: customerName,\n customerEmail: jotformData['Customer email'],\n rating: rating\n }\n}];"
},
"typeVersion": 2
},
{
"id": "8126ef33-ad08-47d5-803e-0ec77f1d8233",
"name": "发送感谢邮件",
"type": "n8n-nodes-base.gmail",
"position": [
1104,
160
],
"webhookId": "0c1d2859-6662-4712-98d3-4e09ee485278",
"parameters": {
"sendTo": "={{ $json.customerEmail }}",
"message": "Hi there, Thank you for your testimonial! Your feedback means the world to us. As a token of appreciation, here is your exclusive coupon code: CODE with DISCOUNT percent off, valid until EXPIRY. We truly appreciate your support! Best regards, The Team",
"options": {},
"subject": "Thank You for Your Testimonial!"
},
"credentials": {
"gmailOAuth2": {
"id": "",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "2c22739d-2bec-49a6-a606-3341cc26e3ee",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
896,
416
],
"parameters": {
"color": 7,
"width": 320,
"height": 328,
"content": "营销团队提醒 - 通知包括：新推荐可用、AI分析摘要、最佳引用、优先级、使用建议。实现：即时活动使用"
},
"typeVersion": 1
},
{
"id": "9960fab6-6012-4e86-9020-fb83c1949946",
"name": "通知营销团队",
"type": "n8n-nodes-base.gmail",
"position": [
1088,
576
],
"webhookId": "7f79cc58-9d80-4582-9385-1f2a2597ceee",
"parameters": {
"sendTo": "marketing@yourcompany.com",
"message": "New testimonial available. Customer details and AI analysis included. Please check the testimonial library for full details.",
"options": {},
"subject": "New Testimonial Received"
},
"credentials": {
"gmailOAuth2": {
"id": "",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "411f477b-f50a-4089-b246-6fde5d782e3d",
"name": "Jotform触发器",
"type": "n8n-nodes-base.jotFormTrigger",
"position": [
-368,
352
],
"webhookId": "testimonial-submission-webhook",
"parameters": {
"form": "252892971568071"
},
"credentials": {
"jotFormApi": {
"id": "W7O1b225FpOwkwDT",
"name": "Jotform account-Deepanshi"
}
},
"typeVersion": 1
},
{
"id": "780472ed-f2ed-4a0e-8844-2cd3ef4d01de",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
0,
464
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "8IkhtT3EbXygnvcr",
"name": "Klinsman OpenAI"
}
},
"typeVersion": 1.2
}
],
"pinData": {},
"connections": {
"Jotform Trigger": {
"main": [
[
{
"node": "Extract Testimonial Data",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Testimonial Analysis",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Parse AI Analysis": {
"main": [
[
{
"node": "Log to Testimonial Library",
"type": "main",
"index": 0
},
{
"node": "Generate Coupon Code",
"type": "main",
"index": 0
}
]
]
},
"Generate Coupon Code": {
"main": [
[
{
"node": "Send Thank You Email",
"type": "main",
"index": 0
},
{
"node": "Notify Marketing Team",
"type": "main",
"index": 0
}
]
]
},
"AI Testimonial Analysis": {
"main": [
[
{
"node": "Parse AI Analysis",
"type": "main",
"index": 0
}
]
]
},
"Extract Testimonial Data": {
"main": [
[
{
"node": "AI Testimonial Analysis",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用 GPT-4 分析和 JotForm 离职面谈自动化员工离职流程
使用 GPT-4 分析和 JotForm 离职面谈实现员工离职流程自动化
If
Set
Code
+6
20 节点Jitesh Dugar
使用 JotForm、GPT-4o-mini 和 Google Workspace 自动化员工入职
使用 JotForm、GPT-4o-mini 和 Google Workspace 实现员工入职自动化
If
Set
Code
+6
14 节点Jitesh Dugar
使用 Jotform、GPT-4 分析和 Gmail 通知自动化贷款预审批
使用 Jotform、GPT-4 分析和 Gmail 通知自动化贷款预审批
If
Set
Code
+6
21 节点Jitesh Dugar
使用GPT-4o-mini、JotForm和Gmail自动化物业维护请求
使用GPT-4o-mini、JotForm和Gmail自动化物业维护请求
If
Set
Code
+6
21 节点Jitesh Dugar
车辆检查与维护工作流自动化
使用OpenAI和JotForm自动化车辆检查与维护工作流
If
Set
Code
+6
20 节点Jitesh Dugar
使用GPT-4、JotForm和Google Sheets的自动化企业培训请求
使用GPT-4、JotForm和Google Sheets的自动化企业培训请求
If
Set
Code
+6
21 节点Jitesh Dugar
工作流信息
难度等级
中级
节点数量15
分类-
节点类型8
作者
Jitesh Dugar
@jiteshdugarAI Automation Specialist - OpenAI, CRM & Automation Expert with a solid understanding of various tools that include Zapier, Make, Zoho CRM, Hubspot, Google Sheets, Airtable, Pipedrive, Google Analytics, and more.
外部链接
在 n8n.io 查看 →
分享此工作流