使用Freshdesk自动化CSAT调查并将响应存储在Google Sheets中
高级
这是一个Support领域的自动化工作流，包含 21 个节点。主要使用 If, Set, Markdown, EmailSend, Freshdesk 等节点。 使用Freshdesk自动化CSAT调查并将响应存储在Google Sheets中
前置要求
- •Google Sheets API 凭证
使用的节点 (21)
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"nodes": [
{
"id": "7e821a77-1db8-4d91-8500-7785b195151b",
"name": "当点击\"测试工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
0,
-260
],
"parameters": {},
"typeVersion": 1
},
{
"id": "999e52f3-c10d-450a-ab13-f0d01318f1b4",
"name": "如果工单已解决",
"type": "n8n-nodes-base.if",
"position": [
880,
-360
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "e70ba235-bc7d-400f-a0e1-8e0baa815918",
"operator": {
"type": "number",
"operation": "notEquals"
},
"leftValue": "={{ $('get tickets').item.json.status }}",
"rightValue": "={{ $('get existing tickets').item.json.status }}"
},
{
"id": "82e34950-8e33-4f13-b562-c73b79c584fa",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $('get tickets').item.json.status }}",
"rightValue": 4
}
]
},
"looseTypeValidation": true
},
"typeVersion": 2.2
},
{
"id": "fbe9f747-e591-491e-b47d-4a1875daa898",
"name": "发送邮件",
"type": "n8n-nodes-base.emailSend",
"position": [
1980,
-360
],
"webhookId": "28ebac0e-0387-4f8a-a574-a867e51de272",
"parameters": {
"html": "={{ $json.data }}",
"options": {
"appendAttribution": false
},
"subject": "={{ $json.subject }}",
"toEmail": "={{ $('get client').first().json.email }}",
"fromEmail": "thomas@pollup.net"
},
"credentials": {
"smtp": {
"id": "yrsGGdbYvSB8u7sx",
"name": "SMTP account"
}
},
"typeVersion": 2.1
},
{
"id": "fdc22898-b6ad-4489-8562-fe29e68a0832",
"name": "获取客户",
"type": "n8n-nodes-base.freshdesk",
"position": [
1320,
-360
],
"parameters": {
"resource": "contact",
"contactId": "={{ $('get tickets').item.json.requester_id }}",
"operation": "get"
},
"credentials": {
"freshdeskApi": {
"id": "op9AMlUqPbk3ZD8n",
"name": "Freshdesk account"
}
},
"typeVersion": 1
},
{
"id": "e9001b35-1d1f-4d23-bd84-92a471a043e5",
"name": "获取工单",
"type": "n8n-nodes-base.freshdesk",
"position": [
660,
-360
],
"parameters": {
"options": {},
"operation": "getAll"
},
"credentials": {
"freshdeskApi": {
"id": "op9AMlUqPbk3ZD8n",
"name": "Freshdesk account"
}
},
"typeVersion": 1
},
{
"id": "053a1afe-5f25-418e-936a-7770d9bb487e",
"name": "更新状态",
"type": "n8n-nodes-base.googleSheets",
"position": [
1100,
-360
],
"parameters": {
"columns": {
"value": {
"status": "={{ $('get tickets').item.json.status }}",
"row_number": "={{ $('get existing tickets').item.json.row_number }}"
},
"schema": [
{
"id": "cc_emails",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "cc_emails",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "fwd_emails",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "fwd_emails",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reply_cc_emails",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "reply_cc_emails",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ticket_cc_emails",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "ticket_cc_emails",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ticket_bcc_emails",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "ticket_bcc_emails",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "fr_escalated",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "fr_escalated",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "spam",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "spam",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email_config_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "email_config_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "group_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "group_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "priority",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "priority",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "requester_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "requester_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "responder_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "responder_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "source",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "source",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "subject",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "subject",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "association_type",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "association_type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "support_email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "support_email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "to_emails",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "to_emails",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "product_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "product_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "type",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "due_by",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "due_by",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "fr_due_by",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "fr_due_by",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_escalated",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "is_escalated",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "custom_fields",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "custom_fields",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "created_at",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "created_at",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "updated_at",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "updated_at",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "associated_tickets_count",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "associated_tickets_count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "tags",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "tags",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "structured_description",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "structured_description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "sentiment_score",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "sentiment_score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "initial_sentiment_score",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "initial_sentiment_score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "nr_due_by",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "nr_due_by",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "nr_escalated",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "nr_escalated",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "active",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "active",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "description",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "job_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "language",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "language",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "mobile",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "mobile",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "phone",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "time_zone",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "time_zone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "twitter_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "twitter_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "other_emails",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "other_emails",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "facebook_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "facebook_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "csat_rating",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "csat_rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "preferred_source",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "preferred_source",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "view_all_tickets",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "view_all_tickets",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "other_companies",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "other_companies",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "unique_external_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "unique_external_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "avatar",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "avatar",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "first_name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "first_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "last_name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "last_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "visitor_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "visitor_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "org_contact_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "org_contact_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "other_phone_numbers",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "other_phone_numbers",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1G8ULQOK9WWsalHUs2RMTozLfQcYfFm4BLPnBSfVKYa8/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1G8ULQOK9WWsalHUs2RMTozLfQcYfFm4BLPnBSfVKYa8",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1G8ULQOK9WWsalHUs2RMTozLfQcYfFm4BLPnBSfVKYa8/edit?usp=drivesdk",
"cachedResultName": "Freshdesk Tickets"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gdLmm513ROUyH6oU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "2f192048-9b73-4687-a357-e84d1818209e",
"name": "计划触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
0,
-460
],
"parameters": {
"rule": {
"interval": [
{
"field": "hours"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "b6690a95-d6b9-4283-a709-ad1a6b8502fe",
"name": "设置您的数据",
"type": "n8n-nodes-base.set",
"position": [
220,
-360
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "d372b3e3-31bf-45f7-a407-b59916c38bee",
"name": "your name",
"type": "string",
"value": "Thomas Vié"
},
{
"id": "96626d9c-77f1-44e1-aa6f-f2df9f5680ac",
"name": "Your email",
"type": "string",
"value": "thomas@pollup.net"
},
{
"id": "48de3b9d-e582-4d31-9e24-9600c64ef20b",
"name": "your company name",
"type": "string",
"value": "Pollup Data services"
},
{
"id": "c83824e8-498d-4957-a7a9-12c939d7f989",
"name": "your position",
"type": "string",
"value": "C.T.O."
},
{
"id": "09065360-22c6-4c92-be2a-c6129b4dd3a0",
"name": "survey link",
"type": "string",
"value": "https://n8n.pollup.net/form/a05aa4bc-20a7-488d-8249-4d79a94c3a69"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "013c1ba5-d3ff-4304-88c5-ec824686a372",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
140,
-540
],
"parameters": {
"color": 4,
"height": 340,
"content": "## 在此设置您的数据"
},
"typeVersion": 1
},
{
"id": "cfcc442f-e885-43dc-ae0e-0bf27443c6ac",
"name": "调查",
"type": "n8n-nodes-base.formTrigger",
"position": [
0,
0
],
"webhookId": "a05aa4bc-20a7-488d-8249-4d79a94c3a69",
"parameters": {
"options": {},
"formTitle": "Quick Feedback",
"formFields": {
"values": [
{
"fieldType": "dropdown",
"fieldLabel": "On a scale of 1-5, how satisfied are you with the support you received?",
"fieldOptions": {
"values": [
{
"option": "1"
},
{
"option": "2"
},
{
"option": "3"
},
{
"option": "4"
},
{
"option": "5"
}
]
},
"requiredField": true
},
{
"fieldType": "textarea",
"fieldLabel": "Could you share what went wrong so we can improve?",
"requiredField": true
}
]
},
"formDescription": "Help Us Improve!"
},
"typeVersion": 2.2
},
{
"id": "cc3f18ff-6967-42f4-aa2a-23ec503a9b43",
"name": "获取现有工单",
"type": "n8n-nodes-base.googleSheets",
"position": [
440,
-360
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1G8ULQOK9WWsalHUs2RMTozLfQcYfFm4BLPnBSfVKYa8/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1G8ULQOK9WWsalHUs2RMTozLfQcYfFm4BLPnBSfVKYa8",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1G8ULQOK9WWsalHUs2RMTozLfQcYfFm4BLPnBSfVKYa8/edit?usp=drivesdk",
"cachedResultName": "Freshdesk Tickets"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gdLmm513ROUyH6oU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5,
"alwaysOutputData": true
},
{
"id": "a6590283-4b5c-44d7-9384-40708e38a8e4",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
400,
-540
],
"parameters": {
"color": 4,
"width": 180,
"height": 340,
"content": "## 保存工单"
},
"typeVersion": 1
},
{
"id": "878ba0f7-cad0-443a-884e-8ff1259fa02f",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
600,
-540
],
"parameters": {
"color": 4,
"width": 200,
"height": 340,
"content": "## 获取工单"
},
"typeVersion": 1
},
{
"id": "c114af56-5686-40fa-b63d-158d14f87131",
"name": "创建电子邮件文本",
"type": "n8n-nodes-base.set",
"position": [
1540,
-360
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "63d258ad-77b4-4aab-9380-3a66152ac133",
"name": "subject",
"type": "string",
"value": "=Quick Feedback? Help Us Improve"
},
{
"id": "54baa177-0163-47d1-937a-b58547cc4767",
"name": "body",
"type": "string",
"value": "=Hi,\n\nWe recently closed the ticket \"{{ $('get tickets').item.json.subject }}\". How satisfied were you with your recent support experience? Could you answer a [very fast survey]({{ $('Set your data').item.json['survey link'] }})?\n\nThank you for your time — we value your voice.\n\nBest regards,\n\n{{ $('Set your data').item.json['your name'] }}\n{{ $('Set your data').item.json['your position'] }}\n{{ $('Set your data').item.json['your company name'] }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "c5c217d5-7d2e-4c27-828f-a758a35c0f9c",
"name": "将电子邮件文本转换为 HTML",
"type": "n8n-nodes-base.markdown",
"position": [
1760,
-360
],
"parameters": {
"mode": "markdownToHtml",
"options": {},
"markdown": "={{ $json.body }}"
},
"typeVersion": 1
},
{
"id": "64bebbc9-a8a3-459f-8938-d9b17b1c64a2",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1920,
-540
],
"parameters": {
"color": 6,
"width": 200,
"height": 340,
"content": "## 电子邮件发送设置"
},
"typeVersion": 1
},
{
"id": "1372a887-042f-401c-bc39-38bccdb943e8",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1260,
-540
],
"parameters": {
"color": 4,
"width": 200,
"height": 340,
"content": "## 获取客户"
},
"typeVersion": 1
},
{
"id": "07287a6a-16e8-40da-a45e-bdc0e01f14d5",
"name": "将调查保存到 Google 表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
200,
0
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "On a scale of 1-5, how satisfied are you with the support you received?",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "On a scale of 1-5, how satisfied are you with the support you received?",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Could you share what went wrong so we can improve?",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Could you share what went wrong so we can improve?",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "submittedAt",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "submittedAt",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "formMode",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "formMode",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1owSLNTGyoDUw0IB6RFqRYyF_P-KFPiIvS8MM-RrDPjI/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1owSLNTGyoDUw0IB6RFqRYyF_P-KFPiIvS8MM-RrDPjI",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1owSLNTGyoDUw0IB6RFqRYyF_P-KFPiIvS8MM-RrDPjI/edit?usp=drivesdk",
"cachedResultName": "Feedback freshdesk"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gdLmm513ROUyH6oU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "78fa9cde-7135-4dd2-8d74-9b6c826fbd6b",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
140,
-100
],
"parameters": {
"color": 4,
"width": 220,
"height": 340,
"content": "## 保存调查"
},
"typeVersion": 1
},
{
"id": "001ff1c0-515c-410f-a460-c52867af8cb9",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
-780
],
"parameters": {
"width": 880,
"height": 220,
"content": "## 联系我"
},
"typeVersion": 1
},
{
"id": "e5420f8a-b734-4d7c-af02-204c3d263457",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-100,
-100
],
"parameters": {
"color": 6,
"width": 220,
"height": 340,
"content": "## 修改调查"
},
"typeVersion": 1
}
],
"connections": {
"Survey": {
"main": [
[
{
"node": "Save survey to google sheet",
"type": "main",
"index": 0
}
]
]
},
"get client": {
"main": [
[
{
"node": "Create the email text",
"type": "main",
"index": 0
}
]
]
},
"get tickets": {
"main": [
[
{
"node": "If ticket resolved",
"type": "main",
"index": 0
}
]
]
},
"Set your data": {
"main": [
[
{
"node": "get existing tickets",
"type": "main",
"index": 0
}
]
]
},
"Updates status": {
"main": [
[
{
"node": "get client",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Set your data",
"type": "main",
"index": 0
}
]
]
},
"If ticket resolved": {
"main": [
[
{
"node": "Updates status",
"type": "main",
"index": 0
}
]
]
},
"get existing tickets": {
"main": [
[
{
"node": "get tickets",
"type": "main",
"index": 0
}
]
]
},
"Create the email text": {
"main": [
[
{
"node": "Convert the email text to HTML",
"type": "main",
"index": 0
}
]
]
},
"Convert the email text to HTML": {
"main": [
[
{
"node": "Send Email",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Test workflow’": {
"main": [
[
{
"node": "Set your data",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 客户支持
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用Google Sheets、Forms和Gmail通知自动化多步骤入职流程
使用Google Sheets、Forms和Gmail通知自动化多步骤入职流程
If
Set
Code
+11
31 节点PollupAI
人力资源
Noco看板与AI优先级排序
使用AI分配请求并根据NocoDB看板状态发送提醒
If
Set
Slack
+11
27 节点Łukasz
客户支持
使用 Unipile 和 Google Sheets 自动发送 LinkedIn 联系人请求与破冰消息
使用 Unipile 和 Google Sheets 自动发送 LinkedIn 联系人请求与破冰消息
If
Set
Code
+12
44 节点PollupAI
其他
使用 Browserflow 和 Google Sheets 自动化 LinkedIn 请求与破冰消息
使用 Browserflow 和 Google Sheets 自动化 LinkedIn 请求与破冰消息
If
Set
Sort
+15
44 节点PollupAI
销售
CSV到HubSpot上传器（动态字段映射与Google Sheets集成）
具有动态字段映射和Google Sheets集成的CSV到HubSpot上传器
If
Set
Code
+10
36 节点PollupAI
人工智能
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
工作流信息
难度等级
高级
节点数量21
分类1
节点类型10
作者
PollupAI
@zeerobugWe create bespoke AI solutions, automations and agents that help your business as it scales.
外部链接
在 n8n.io 查看 →
分享此工作流