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 Service Request",
"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 Chat Model",
"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": "## Form\n\nStarts workflow when a new IT Service Request is submitted on Jotform.\n\nCaptures: Full Name, Department, Email, Building Number, Problem Category, and Comments.\n\nConnects to “Set Fields” node for structured data mapping."
},
"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": "## Summarizaion & Classifer\n\n- Uses AI to summarize problem details for reports and alerts.\n- Works with Google Gemini model for summarization and classification.\n- Produces a short “Summary” used in Sheets, emails, and Telegram messages.\n- Analyzes request details (problem + comments).\n\n### Classifies into:\nP0 (High) – Immediate action\nP1 (Medium) – Affects single user\nP2 (Low) – Non-critical maintenance\n\nRoutes to correct Google Sheet tab and notification channel."
},
"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": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-448,
-64
],
"parameters": {
"width": 880,
"height": 336,
"content": "## Automate IT Service Request intake → classification → storage → notification → acknowledgment.\n\n- Faster IT response time\n- Centralized data in Google Sheets\n- AI-driven ticket summarization\n- Automatic priority routing and communication"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "e8cfc82c-1f89-4da8-b1d5-f232d2098929",
"connections": {
"4ac3dcf5-1571-4ef6-a713-9cd1b769da4d": {
"main": [
[
{
"node": "d045f16c-626b-403b-92a8-95b3624f69c5",
"type": "main",
"index": 0
}
]
]
},
"eddf1e46-927f-4bf9-acbb-53dd776424da": {
"main": [
[
{
"node": "09d4ff17-05da-4c4b-8de8-ae7cfe00a98c",
"type": "main",
"index": 0
}
]
]
},
"09d4ff17-05da-4c4b-8de8-ae7cfe00a98c": {
"main": [
[
{
"node": "0b99a659-e245-4f9c-b1c0-5e25832fc18a",
"type": "main",
"index": 0
}
]
]
},
"d045f16c-626b-403b-92a8-95b3624f69c5": {
"main": [
[
{
"node": "fbf96746-b4cf-4a79-97a9-32c47e00c237",
"type": "main",
"index": 0
}
]
]
},
"58061549-f68d-490c-b190-4f39ab67ffb5": {
"main": [
[
{
"node": "fbf96746-b4cf-4a79-97a9-32c47e00c237",
"type": "main",
"index": 0
}
]
]
},
"a8481a8c-d041-4f34-ae94-58d0a4752107": {
"main": [
[
{
"node": "fbf96746-b4cf-4a79-97a9-32c47e00c237",
"type": "main",
"index": 0
}
]
]
},
"f092a3cf-0561-4c0b-b807-2a1ebc92ef4e": {
"main": [
[
{
"node": "a8481a8c-d041-4f34-ae94-58d0a4752107",
"type": "main",
"index": 0
}
],
[
{
"node": "58061549-f68d-490c-b190-4f39ab67ffb5",
"type": "main",
"index": 0
}
],
[
{
"node": "4ac3dcf5-1571-4ef6-a713-9cd1b769da4d",
"type": "main",
"index": 0
}
]
]
},
"0b99a659-e245-4f9c-b1c0-5e25832fc18a": {
"main": [
[
{
"node": "f092a3cf-0561-4c0b-b807-2a1ebc92ef4e",
"type": "main",
"index": 0
}
]
]
},
"f5108a8e-39db-425d-967c-c12ceeace077": {
"ai_languageModel": [
[
{
"node": "f092a3cf-0561-4c0b-b807-2a1ebc92ef4e",
"type": "ai_languageModel",
"index": 0
},
{
"node": "0b99a659-e245-4f9c-b1c0-5e25832fc18a",
"type": "ai_languageModel",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級 - チケット管理, AI要約
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
バグ問題
GeminiベースのAI駆動バグ追跡、GitHub IssuesとTelegram通知を統合
If
Set
Gmail
+
If
Set
Gmail
16 ノードRully Saputra
プロジェクト管理
ビジネス日次指標の監視
Googleスプシからテーブルで販売インサイトを自動生成し、チームにリアルタイムで通知する
Code
Gmail
Trello
+
Code
Gmail
Trello
15 ノードRully Saputra
顧客管理
Jotform
自動回答客先フィードバックトリアージ（Gemini、Jotform、Google Sheets、Gmailを使用）
Gmail
Switch
Telegram
+
Gmail
Switch
Telegram
18 ノードRully Saputra
Jotform、Gemini AI、Google Sheets を使用した内部クレーム処理の自動化
Jotform、Gemini AI、Google Sheetsを使って、内部でのクレーム処理を自動化
If
Gmail
Google Sheets
+
If
Gmail
Google Sheets
22 ノードiamvaar
チケット管理
サポートチケットの優先度設定自動化
JotForm、Gemini AI、ClickUpタスクを使用したサポートチケット優先度の自動化
If
Gmail
Slack
+
If
Gmail
Slack
15 ノードZain Khan
チケット管理
Azure OpenAI と Google テーブルを使ってメールを分類して Telegram へ通知を取得する
Azure OpenAIとGoogleスプレッドシートでメールを分類し、Telegramへアラート
If
Set
Telegram
+
If
Set
Telegram
27 ノードMeelioo
チケット管理
ワークフロー情報
難易度
中級
ノード数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で表示 →
このワークフローを共有