从Gmail和Slack自动创建Zendesk工单并进行跟踪
高级
这是一个Content Creation, Multimodal AI领域的自动化工作流，包含 22 个节点。主要使用 If, Code, Merge, Slack, Zendesk 等节点。 从Gmail和Slack创建Zendesk工单，并使用Google Sheets进行跟踪
前置要求
- •Slack Bot Token 或 Webhook URL
- •Google 账号和 Gmail API 凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "z8tZLnpHvPBBFius",
"meta": {
"instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
"templateCredsSetupCompleted": true
},
"name": "从 Gmail 和 Slack 自动创建 Zendesk 工单并进行跟踪",
"tags": [],
"nodes": [
{
"id": "91c501b2-e134-406d-9e38-679bc5581337",
"name": "Slack 触发器",
"type": "n8n-nodes-base.slackTrigger",
"position": [
-944,
240
],
"webhookId": "slack-support-webhook",
"parameters": {},
"typeVersion": 1
},
{
"id": "a7f78052-276b-41ee-baa2-0cc21f2a13ec",
"name": "标准化 Gmail 数据",
"type": "n8n-nodes-base.code",
"position": [
-752,
32
],
"parameters": {},
"typeVersion": 2
},
{
"id": "842db600-6d49-4afb-adc3-b72f9b3acc76",
"name": "标准化 Slack 数据",
"type": "n8n-nodes-base.code",
"position": [
-736,
240
],
"parameters": {},
"typeVersion": 2
},
{
"id": "ae0220a2-b337-4b0a-81dd-fd7f54a739dc",
"name": "合并渠道",
"type": "n8n-nodes-base.merge",
"position": [
-512,
160
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "feb43b04-c0df-4d59-9c5c-fc7301f1bb04",
"name": "创建 Zendesk 工单",
"type": "n8n-nodes-base.zendesk",
"position": [
-304,
160
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3dd320b0-6361-44e7-a26f-4a7683aa2749",
"name": "格式化表格数据",
"type": "n8n-nodes-base.code",
"position": [
-112,
160
],
"parameters": {},
"typeVersion": 2
},
{
"id": "f5cdbfd3-cbbf-44ba-921a-2a548cd40ff6",
"name": "检查错误",
"type": "n8n-nodes-base.if",
"position": [
304,
160
],
"parameters": {},
"typeVersion": 2
},
{
"id": "318484c7-855b-47e0-a1e2-53747341ad21",
"name": "发送错误通知",
"type": "n8n-nodes-base.slack",
"position": [
512,
48
],
"webhookId": "c4425922-6871-44f2-8c69-fac2b00eef31",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "e25ad08b-3f0c-4223-a56f-a46f412d2d0c",
"name": "发送成功通知",
"type": "n8n-nodes-base.slack",
"position": [
512,
256
],
"webhookId": "81b6a37d-3095-4f20-9c14-9d140157f48b",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "e8cca88f-ed70-4516-856f-ab4fdce16c57",
"name": "Gmail 触发器",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
-944,
32
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5ba8c867-8a8c-4369-98f2-6ae1eb9c6596",
"name": "记录到Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
112,
160
],
"parameters": {},
"typeVersion": 4
},
{
"id": "b16b8403-30f4-4025-b923-a8a6f3013165",
"name": "便签 - Gmail 触发器",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1200,
-224
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "486cf6fe-1d02-406a-a888-78d322f85f11",
"name": "便签 - Slack 触发器",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1232,
288
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "cc9dabe4-d29b-4d1b-ad53-365439a3c617",
"name": "便签 - Gmail 标准化",
"type": "n8n-nodes-base.stickyNote",
"position": [
-784,
-304
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "fe405bc0-d531-43ca-b8eb-c95f888b6f2e",
"name": "便签 - Slack 标准化",
"type": "n8n-nodes-base.stickyNote",
"position": [
-752,
368
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ec0da8ad-fcae-4d36-9210-6d7bc79f863d",
"name": "便签 - 合并",
"type": "n8n-nodes-base.stickyNote",
"position": [
-480,
-224
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "696e38f7-ca0d-4ff2-8bd4-a4bd99cd18cb",
"name": "便签 - Zendesk",
"type": "n8n-nodes-base.stickyNote",
"position": [
-304,
304
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7a239694-a538-451a-a873-64dbdbd9b095",
"name": "便签 - 格式化",
"type": "n8n-nodes-base.stickyNote",
"position": [
-112,
-192
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "f21ddbd7-dc00-47a2-960c-c831566241c8",
"name": "便签 - Sheets",
"type": "n8n-nodes-base.stickyNote",
"position": [
112,
320
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "45f1c868-c6eb-40a7-a0a2-37e5323caa1b",
"name": "便签 - 错误检查",
"type": "n8n-nodes-base.stickyNote",
"position": [
240,
-208
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b40978bd-3de8-430c-9322-2a419d482685",
"name": "便签 - 错误通知",
"type": "n8n-nodes-base.stickyNote",
"position": [
592,
-272
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "cbff4d0d-ab6e-42e5-8fb8-d960337ce93e",
"name": "便签 - 成功通知",
"type": "n8n-nodes-base.stickyNote",
"position": [
640,
384
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "80d03231-2fae-49ce-8c40-499fd5961bd6",
"connections": {
"Gmail Trigger": {
"main": [
[
{
"node": "Normalize Gmail Data",
"type": "main",
"index": 0
}
]
]
},
"Slack Trigger": {
"main": [
[
{
"node": "Normalize Slack Data",
"type": "main",
"index": 0
}
]
]
},
"Merge Channels": {
"main": [
[
{
"node": "Create Zendesk Ticket",
"type": "main",
"index": 0
}
]
]
},
"Check for Errors": {
"main": [
[
{
"node": "Send Error Notification",
"type": "main",
"index": 0
}
],
[
{
"node": "Send Success Notification",
"type": "main",
"index": 0
}
]
]
},
"Format Sheet Data": {
"main": [
[
{
"node": "Log to Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Log to Google Sheets": {
"main": [
[
{
"node": "Check for Errors",
"type": "main",
"index": 0
}
]
]
},
"Normalize Gmail Data": {
"main": [
[
{
"node": "Merge Channels",
"type": "main",
"index": 0
}
]
]
},
"Normalize Slack Data": {
"main": [
[
{
"node": "Merge Channels",
"type": "main",
"index": 1
}
]
]
},
"Create Zendesk Ticket": {
"main": [
[
{
"node": "Format Sheet Data",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 内容创作, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
统一支持团队绩效仪表板（Zendesk & Freshdesk → Google Sheets + Slack + Gmail）
使用Sheets、Slack和Gmail跨Zendesk和Freshdesk跟踪支持绩效指标
If
Code
Cron
+7
24 节点Rahul Joshi
内容创作
监控Zendesk流失风险信号并在Slack中通知CS团队
监控Zendesk流失风险信号，记录到表格，并在Slack中通知团队
If
Code
Slack
+4
12 节点Rahul Joshi
内容创作
GoHighLevel管道速度跟踪器和自动化停滞交易提醒
使用GoHighLevel、Gmail和Slack分析管道速度并提醒停滞交易
If
Code
Gmail
+5
25 节点Rahul Joshi
内容创作
面试质量审计
使用GPT-4o-mini和Google表格通过Slack审核面试反馈并生成报告
If
Code
Slack
+5
23 节点Rahul Joshi
内容创作
## 仅限自托管N8N用户：
使用GPT-4o-mini、Google Sheets和Gmail自动化Zendesk支持回复
Code
Gmail
Merge
+6
24 节点Rahul Joshi
内容创作
带附件的自动化 Slack 到 Jira 问题创建
带附件的自动化Slack到Jira问题创建
If
Code
Jira
+5
19 节点Rahul Joshi
内容创作
工作流信息
难度等级
高级
节点数量22
分类2
节点类型9
作者
Rahul Joshi
@rahul08Rahul Joshi is a seasoned technology leader specializing in the n8n automation tool and AI-driven workflow automation. With deep expertise in building open-source workflow automation and self-hosted automation platforms, he helps organizations eliminate manual processes through intelligent n8n ai agent automation solutions.
外部链接
在 n8n.io 查看 →
分享此工作流