JOTFORM IT服务请求
中级
这是一个Ticket Management, AI Summarization领域的自动化工作流，包含 13 个节点。主要使用 Set, Gmail, Telegram, GoogleSheets, JotFormTrigger 等节点。 使用Jotform、Gemini AI和Google Workspace分类和处理IT请求
前置要求
- •Google 账号和 Gmail API 凭证
- •Telegram Bot Token
- •Google Sheets API 凭证
- •Google Gemini API Key
使用的节点 (13)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "ks75ajOn93UedaeQ",
"meta": {
"instanceId": "629b84172205f7f7d120e17f3c123374afb437270b96347406aace34d2037da2"
},
"name": "JOTFORM IT 服务请求",
"tags": [],
"nodes": [
{
"id": "eddf1e46-927f-4bf9-acbb-53dd776424da",
"name": "JotForm 触发器",
"type": "n8n-nodes-base.jotFormTrigger",
"position": [
-64,
640
],
"webhookId": "49d4fe05-0919-407c-899d-7510fe156614",
"parameters": {
"form": "="
},
"credentials": {
"jotFormApi": {
"id": "zuUGTUKv9eQd5cJT",
"name": "JotForm account"
}
},
"typeVersion": 1
},
{
"id": "f5108a8e-39db-425d-967c-c12ceeace077",
"name": "Google Gemini聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
768,
976
],
"parameters": {
"options": {}
},
"credentials": {
"googlePalmApi": {
"id": "OISgoYWoOCFhLV0m",
"name": "Google Gemini(PaLM) Api account"
}
},
"typeVersion": 1
},
{
"id": "0b99a659-e245-4f9c-b1c0-5e25832fc18a",
"name": "摘要生成链",
"type": "@n8n/n8n-nodes-langchain.chainSummarization",
"position": [
528,
640
],
"parameters": {
"options": {}
},
"typeVersion": 2.1
},
{
"id": "fbf96746-b4cf-4a79-97a9-32c47e00c237",
"name": "回复用户",
"type": "n8n-nodes-base.gmail",
"position": [
1824,
576
],
"webhookId": "1909f2ab-e8a5-4caa-b678-fca26df4b4e0",
"parameters": {
"sendTo": "={{ $json.Email }}",
"message": "=Dear {{ $json.Name }},\n\nThank you for submitting your IT service request. We’ve received your request and our team is currently reviewing the details. You will be notified once the issue has been assigned and work begins.\n\nIf you have any additional information to share, please reply to this email.\n\nSummary:\n{{ $json.Summary }}\n\nRequest:\n{{ $json.Problem }}\n\nBest regards,\nIT Support Team",
"options": {},
"subject": "=IT Service Request: {{ $json.Name }} - {{ $json.Department }} - {{ $json.Category }}- {{ $json.Date }}",
"emailType": "text"
},
"credentials": {
"gmailOAuth2": {
"id": "DAEc0IIArKM8pyjk",
"name": "Gmail account"
}
},
"typeVersion": 2.1
},
{
"id": "f092a3cf-0561-4c0b-b807-2a1ebc92ef4e",
"name": "优先级分类器",
"type": "@n8n/n8n-nodes-langchain.textClassifier",
"position": [
880,
624
],
"parameters": {
"options": {},
"inputText": "=Description:\n{{ $('JotForm Trigger').item.json['Please Specify'] }}\n\nComments:\n{{ $('JotForm Trigger').item.json['Comment and Questions'] }}",
"categories": {
"categories": [
{
"category": "Low",
"description": "Requests that are non-critical and do not impact daily operations. These tasks can be completed within several days without affecting productivity. Usually involve routine maintenance, minor updates, or general inquiries."
},
{
"category": "Medium",
"description": "Requests that affect an individual’s ability to work but do not impact multiple users or critical systems. These tasks should be addressed within 24–48 hours to minimize disruption."
},
{
"category": "High",
"description": "Requests that have a major impact on business operations or affect multiple users. These require immediate attention to restore functionality or prevent downtime."
}
]
}
},
"typeVersion": 1.1
},
{
"id": "a8481a8c-d041-4f34-ae94-58d0a4752107",
"name": "存储到 Sheets P2",
"type": "n8n-nodes-base.googleSheets",
"position": [
1296,
400
],
"parameters": {
"columns": {
"value": {
"Date": "={{ new Date().format('MMMM D, h:mm:ss a') }}",
"Name": "={{ $('Downstream Fields').item.json['Full Name'].first }} {{ $('Downstream Fields').item.json['Full Name'].last }}",
"Email": "={{ $('Downstream Fields').item.json['E-mail'] }}",
"Status": "TODO",
"Problem": "={{ $('Downstream Fields').item.json['Please Specify'] }}\n\nComments: {{ $('Downstream Fields').item.json['Comment and Questions'] }}",
"Summary": "={{ $('Summarization Chain').item.json.output.text }}",
"Category": "={{ $('Downstream Fields').item.json['Problem Category'][0] }}",
"Priority": "P2",
"Department": "={{ $('Downstream Fields').item.json.Department }}",
"Building Number": "={{ $('Downstream Fields').item.json['Building Number'] }}"
},
"schema": [
{
"id": "Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Priority",
"type": "string",
"display": true,
"required": false,
"displayName": "Priority",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Category",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Category",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Department",
"type": "string",
"display": true,
"required": false,
"displayName": "Department",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Building Number",
"type": "string",
"display": true,
"required": false,
"displayName": "Building Number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Problem",
"type": "string",
"display": true,
"required": false,
"displayName": "Problem",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Summary",
"type": "string",
"display": true,
"required": false,
"displayName": "Summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "id",
"value": "="
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "="
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "tG6sJQ2UoifovxJZ",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "d045f16c-626b-403b-92a8-95b3624f69c5",
"name": "存储到 Sheets P0",
"type": "n8n-nodes-base.googleSheets",
"position": [
1552,
768
],
"parameters": {
"columns": {
"value": {
"Date": "={{ new Date().format('MMMM D, h:mm:ss a') }}",
"Name": "={{ $('Downstream Fields').item.json['Full Name'].first }} {{ $('Downstream Fields').item.json['Full Name'].last }}",
"Email": "={{ $('Downstream Fields').item.json['E-mail'] }}",
"Status": "TODO",
"Problem": "={{ $('Downstream Fields').item.json['Please Specify'] }}\n\n{{ $('Downstream Fields').item.json['Comment and Questions'] }}",
"Summary": "={{ $('Summarization Chain').item.json.output.text }}",
"Category": "={{ $('Downstream Fields').item.json['Problem Category'][0] }}",
"Priority": "=P0",
"Department": "={{ $('Downstream Fields').item.json.Department }}",
"Building Number": "={{ $('Downstream Fields').item.json['Building Number'] }}"
},
"schema": [
{
"id": "Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Priority",
"type": "string",
"display": true,
"required": false,
"displayName": "Priority",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Category",
"type": "string",
"display": true,
"required": false,
"displayName": "Category",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Department",
"type": "string",
"display": true,
"required": false,
"displayName": "Department",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Building Number",
"type": "string",
"display": true,
"required": false,
"displayName": "Building Number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Problem",
"type": "string",
"display": true,
"required": false,
"displayName": "Problem",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Summary",
"type": "string",
"display": true,
"required": false,
"displayName": "Summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "id",
"value": "="
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "="
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "tG6sJQ2UoifovxJZ",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "58061549-f68d-490c-b190-4f39ab67ffb5",
"name": "存储到 Sheets P1",
"type": "n8n-nodes-base.googleSheets",
"position": [
1296,
576
],
"parameters": {
"columns": {
"value": {
"Date": "={{ new Date().format('MMMM D, h:mm:ss a') }}",
"Name": "={{ $('Downstream Fields').item.json['Full Name'].first }} {{ $('Downstream Fields').item.json['Full Name'].last }}",
"Email": "={{ $('Downstream Fields').item.json['E-mail'] }}",
"Status": "TODO",
"Problem": "={{ $('Downstream Fields').item.json['Please Specify'] }}\n\nComments: {{ $('Downstream Fields').item.json['Comment and Questions'] }}",
"Summary": "={{ $('Summarization Chain').item.json.output.text }}",
"Category": "={{ $('Downstream Fields').item.json['Problem Category'][0] }}",
"Priority": "P1",
"Department": "={{ $('Downstream Fields').item.json.Department }}",
"Building Number": "={{ $('Downstream Fields').item.json['Building Number'] }}"
},
"schema": [
{
"id": "Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Priority",
"type": "string",
"display": true,
"required": false,
"displayName": "Priority",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Category",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Category",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Department",
"type": "string",
"display": true,
"required": false,
"displayName": "Department",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Building Number",
"type": "string",
"display": true,
"required": false,
"displayName": "Building Number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Problem",
"type": "string",
"display": true,
"required": false,
"displayName": "Problem",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Summary",
"type": "string",
"display": true,
"required": false,
"displayName": "Summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "id",
"value": "="
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "="
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "tG6sJQ2UoifovxJZ",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "4ac3dcf5-1571-4ef6-a713-9cd1b769da4d",
"name": "发送到群组",
"type": "n8n-nodes-base.telegram",
"position": [
1296,
768
],
"webhookId": "b21285aa-a097-41db-a5a0-f5d233a5bd28",
"parameters": {
"text": "=⚠️ALERT⚠️\n\nPlease do it immediately\nP0 Request\n\nSummary\n{{ $json.output.text }}\nRequest\n{{ $('Downstream Fields').item.json['Please Specify'] }}\n\nComments\n{{ $('Downstream Fields').item.json['Comment and Questions'] }}\n\nName: {{ $('Downstream Fields').item.json['Full Name'].first }} {{ $('Downstream Fields').item.json['Full Name'].last }}\n\nDepartment: {{ $('Downstream Fields').item.json.Department }}\n\nCategory: {{ $('Downstream Fields').item.json['Problem Category'][0] }}\n\nBuilding Number: {{ $('Downstream Fields').item.json['Building Number'] }}",
"additionalFields": {}
},
"credentials": {
"telegramApi": {
"id": "79cg2SffWnQrdXjQ",
"name": "Telegram account"
}
},
"typeVersion": 1.2
},
{
"id": "993442ca-2aef-4177-8ea6-1d0795268895",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-128,
336
],
"parameters": {
"color": 7,
"width": 336,
"height": 528,
"content": "## 表单"
},
"typeVersion": 1
},
{
"id": "a944c896-72d2-4313-92fc-80715f0ed8bf",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
512,
128
],
"parameters": {
"color": 7,
"width": 624,
"height": 864,
"content": "## 摘要与分类器"
},
"typeVersion": 1
},
{
"id": "09d4ff17-05da-4c4b-8de8-ae7cfe00a98c",
"name": "下游字段",
"type": "n8n-nodes-base.set",
"position": [
272,
640
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "7ead3c02-52b8-424d-9c3f-3c295ef25e89",
"name": "Full Name",
"type": "object",
"value": "={{ $json['Full Name'] }}"
},
{
"id": "546c1672-e08a-4a15-ac06-8328643e5452",
"name": "Department",
"type": "string",
"value": "={{ $json.Department }}"
},
{
"id": "3d4efe56-a77b-4957-8891-998f2b9242c6",
"name": "E-mail",
"type": "string",
"value": "={{ $json['E-mail'] }}"
},
{
"id": "f7f0d2ab-0f37-4311-9bc2-06484973a2c8",
"name": "Building Number",
"type": "string",
"value": "={{ $json['Building Number'] }}"
},
{
"id": "37038773-4789-4be4-bfcb-e66622def048",
"name": "['Problem Category'][0]",
"type": "string",
"value": "={{ $json['Problem Category'][0] }}"
},
{
"id": "484d4c07-32d9-4e31-a13a-97534871863f",
"name": "Please Specify",
"type": "string",
"value": "={{ $json['Please Specify'] }}"
},
{
"id": "86f0e37d-7cbd-4492-bf18-e47b532cf572",
"name": "Comment and Questions",
"type": "string",
"value": "={{ $json['Comment and Questions'] }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "cf8f4c50-bdb6-46c2-9eb8-ecde6e6bb08e",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-448,
-64
],
"parameters": {
"width": 880,
"height": 336,
"content": "## 自动化 IT 服务请求接收 → 分类 → 存储 → 通知 → 确认。"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "e8cfc82c-1f89-4da8-b1d5-f232d2098929",
"connections": {
"Send to Group": {
"main": [
[
{
"node": "Store to Sheets P0",
"type": "main",
"index": 0
}
]
]
},
"JotForm Trigger": {
"main": [
[
{
"node": "Downstream Fields",
"type": "main",
"index": 0
}
]
]
},
"Downstream Fields": {
"main": [
[
{
"node": "Summarization Chain",
"type": "main",
"index": 0
}
]
]
},
"Store to Sheets P0": {
"main": [
[
{
"node": "Reply User",
"type": "main",
"index": 0
}
]
]
},
"Store to Sheets P1": {
"main": [
[
{
"node": "Reply User",
"type": "main",
"index": 0
}
]
]
},
"Store to Sheets P2": {
"main": [
[
{
"node": "Reply User",
"type": "main",
"index": 0
}
]
]
},
"Priority Classifier": {
"main": [
[
{
"node": "Store to Sheets P2",
"type": "main",
"index": 0
}
],
[
{
"node": "Store to Sheets P1",
"type": "main",
"index": 0
}
],
[
{
"node": "Send to Group",
"type": "main",
"index": 0
}
]
]
},
"Summarization Chain": {
"main": [
[
{
"node": "Priority Classifier",
"type": "main",
"index": 0
}
]
]
},
"Google Gemini Chat Model": {
"ai_languageModel": [
[
{
"node": "Priority Classifier",
"type": "ai_languageModel",
"index": 0
},
{
"node": "Summarization Chain",
"type": "ai_languageModel",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 工单管理, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
Bug 问题
基于Gemini的AI驱动Bug追踪，集成GitHub Issues和Telegram提醒
If
Set
Gmail
+7
16 节点Rully Saputra
项目管理
监控业务日常指标
使用Gemini从表格自动生成销售洞察并即时通知团队
Code
Gmail
Trello
+9
15 节点Rully Saputra
客户关系管理
Jotform
使用Gemini、Jotform、Google Sheets和Gmail回复的自动化客户反馈分诊
Gmail
Switch
Telegram
+8
18 节点Rully Saputra
Lighthouse报告
使用Lighthouse、Gemini AI、Telegram警报和Google Sheets监控核心网页指标
If
Code
Telegram
+6
13 节点Rully Saputra
开发运维
使用 Jotform、Gemini AI 和 Google Sheets 自动化内部投诉处理
通过 Jotform、Gemini AI 和 Google Sheets 实现内部投诉处理的自动化
If
Gmail
Google Sheets
+7
22 节点iamvaar
工单管理
支持工单优先级自动化
使用JotForm、Gemini AI和ClickUp任务自动化支持工单优先级
If
Gmail
Slack
+6
15 节点Zain Khan
工单管理
工作流信息
难度等级
中级
节点数量13
分类2
节点类型9
作者
Rully Saputra
@rullysaputra15Specializing in software engineering with over 5 years of hands-on experience. In addition to my expertise in web development, I also have experience in creating Hybrid mobile apps.
外部链接
在 n8n.io 查看 →
分享此工作流