## 仅限自托管N8N用户：
高级
这是一个Content Creation, Multimodal AI领域的自动化工作流，包含 24 个节点。主要使用 Code, Gmail, Merge, Zendesk, GoogleSheets 等节点。 使用GPT-4o-mini、Google Sheets和Gmail自动化Zendesk支持回复
前置要求
- •Google 账号和 Gmail API 凭证
- •Google Sheets API 凭证
- •OpenAI API Key
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "BRgkmSQneVUhy8wp",
"meta": {
"instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
"templateCredsSetupCompleted": true
},
"name": "## 仅限自托管N8N用户：",
"tags": [],
"nodes": [
{
"id": "71026cd4-3934-4d46-8973-6957efcd7b3b",
"name": "Azure OpenAI聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
"position": [
240,
496
],
"parameters": {},
"typeVersion": 1
},
{
"id": "74860740-46f4-4b61-ab6c-d62e731eb2db",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
640,
-192
],
"parameters": {
"content": "常见问题自动回复"
},
"typeVersion": 1
},
{
"id": "942716da-a80f-4325-a82f-a9e957eec70e",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-896,
-224
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ce13f7f0-559d-4e2d-85b1-5116c65f4f6b",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-608,
-224
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "43c13706-805a-42d1-9ac1-c8cffddb4fbd",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-224,
-176
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "17e84305-5cb6-445e-87e1-c1deb7745b05",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-400,
448
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "78451223-0353-405e-a292-45f64cd2ff68",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
208,
656
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b93bd350-9144-4bb0-a4a5-6caac01ab6ad",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-96,
432
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d1ffa1ff-388f-4a72-a4e5-267a8caefb1d",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-816,
528
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "466683f5-27e2-43ed-ba2e-06a62bbe835d",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1232,
-80
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9a25381f-eb0c-430d-bd40-0acb86bba767",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
928,
-352
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "741a240b-d9ff-4a3c-900b-bb7285e2a001",
"name": "便签10",
"type": "n8n-nodes-base.stickyNote",
"position": [
1136,
256
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ff5eb39c-1723-4848-a5f2-a282fe4eca61",
"name": "测试开始",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1152,
208
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f46c4e96-a867-4cf4-b6ad-1d1614bd751a",
"name": "获取Zendesk工单",
"type": "n8n-nodes-base.zendesk",
"position": [
-800,
80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d8c77905-afb5-4e4b-8a26-8ac86c916b47",
"name": "选择最新工单",
"type": "n8n-nodes-base.code",
"position": [
-592,
80
],
"parameters": {},
"typeVersion": 2
},
{
"id": "c6968872-def1-4fe7-8ae9-e12021ee0856",
"name": "加载FAQ列表",
"type": "n8n-nodes-base.googleSheets",
"position": [
-752,
368
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "f614b225-1bf6-4083-9616-31c1c79ebde7",
"name": "合并工单和FAQ",
"type": "n8n-nodes-base.merge",
"position": [
-320,
288
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "8cf61891-1a33-4c6d-a7de-cc17f439ac12",
"name": "为AI准备数据",
"type": "n8n-nodes-base.code",
"position": [
-32,
288
],
"parameters": {},
"typeVersion": 2
},
{
"id": "cb088ef8-a35a-4f4a-aedb-194c6a8fac2f",
"name": "便签11",
"type": "n8n-nodes-base.stickyNote",
"position": [
496,
416
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e0d53a95-4a97-4212-8b18-0f8ee53549f0",
"name": "生成支持回复",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
304,
288
],
"parameters": {},
"typeVersion": 1.7
},
{
"id": "3b061fd5-694b-4036-b02f-7a8fb2887120",
"name": "获取请求者邮箱",
"type": "n8n-nodes-base.zendesk",
"position": [
-160,
80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1c0a0c80-4012-40f1-9d21-4b9281470555",
"name": "合并回复和用户信息",
"type": "n8n-nodes-base.merge",
"position": [
752,
96
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "a9c2d8a1-7bec-4c1b-b1f5-68019cb9e605",
"name": "为Gmail格式化邮件",
"type": "n8n-nodes-base.code",
"position": [
976,
96
],
"parameters": {},
"typeVersion": 2
},
{
"id": "652fe821-13e6-4246-a4c1-5c3132a84371",
"name": "发送自动回复",
"type": "n8n-nodes-base.gmail",
"position": [
1184,
96
],
"webhookId": "0c82c299-6938-42ed-bda6-5007d79af34f",
"parameters": {},
"typeVersion": 2.1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "67032823-3003-4298-afd4-60ca6d3f205b",
"connections": {
"Test Start": {
"main": [
[
{
"node": "Fetch Zendesk Tickets",
"type": "main",
"index": 0
},
{
"node": "Load FAQ List",
"type": "main",
"index": 0
}
]
]
},
"Load FAQ List": {
"main": [
[
{
"node": "Merge Ticket & FAQs",
"type": "main",
"index": 1
}
]
]
},
"Merge Ticket & FAQs": {
"main": [
[
{
"node": "Prepare Data for AI",
"type": "main",
"index": 0
}
]
]
},
"Prepare Data for AI": {
"main": [
[
{
"node": "Generate Support Reply",
"type": "main",
"index": 0
}
]
]
},
"Select Latest Ticket": {
"main": [
[
{
"node": "Merge Ticket & FAQs",
"type": "main",
"index": 0
},
{
"node": "Fetch Requester Email",
"type": "main",
"index": 0
}
]
]
},
"Fetch Requester Email": {
"main": [
[
{
"node": "Merge Reply & User Info",
"type": "main",
"index": 0
}
]
]
},
"Fetch Zendesk Tickets": {
"main": [
[
{
"node": "Select Latest Ticket",
"type": "main",
"index": 0
}
]
]
},
"Format Email for Gmail": {
"main": [
[
{
"node": "Send Auto-Reply",
"type": "main",
"index": 0
}
]
]
},
"Generate Support Reply": {
"main": [
[
{
"node": "Merge Reply & User Info",
"type": "main",
"index": 1
}
]
]
},
"Azure OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Generate Support Reply",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Merge Reply & User Info": {
"main": [
[
{
"node": "Format Email for Gmail",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 内容创作, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
雇佣后留存跟踪
使用GPT-4o和Gmail摘要生成员工留存分析报告
If
Code
Gmail
+6
19 节点Rahul Joshi
内容创作
技能差距 → 培训推荐
为 HR 团队使用 GPT-4o、Google Sheets 和 Gmail 个性化候选人反馈
If
Code
Gmail
+7
27 节点Rahul Joshi
内容创作
面试质量审计
使用GPT-4o-mini和Google表格通过Slack审核面试反馈并生成报告
If
Code
Slack
+5
23 节点Rahul Joshi
内容创作
影响者每日建议
使用GPT-4o-mini和Gmail投递为影响者生成LinkedIn内容创意
Code
Gmail
Manual Trigger
+3
10 节点Rahul Joshi
内容创作
从Google Drive生成n8n模板描述
使用Azure GPT-4从Google Drive生成模板描述
Code
Gmail
Google Drive
+9
27 节点Rahul Joshi
内容创作
LinkedIn Sales Navigator消息发布监控
监控LinkedIn Sales Navigator消息并通过Gmail和Google Sheets发送警报
Code
Gmail
Merge
+3
20 节点Rahul Joshi
内容创作
工作流信息
难度等级
高级
节点数量24
分类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 查看 →
分享此工作流