完全な出張電話管理システム - コールトラッキング、宿泊予約、マーケティング
上級
これはCRM分野の自動化ワークフローで、16個のノードを含みます。主にSet, Webhook, Postgres, HttpRequest, GoogleSheetsなどのノードを使用。 旅行业務のオペレーションを Postgres、Google Sheets、音声 API で自動化
前提条件
- •HTTP Webhookエンドポイント（n8nが自動生成）
- •PostgreSQLデータベース接続情報
- •ターゲットAPIの認証情報が必要な場合あり
- •Google Sheets API認証情報
カテゴリー
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "s8WPaQ8NrHpG3Q4Z",
"meta": {
"instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
"templateCredsSetupCompleted": true
},
"name": "Complete Travel Call Management System - Call Tracking, Book Trips & Marketing",
"tags": [],
"nodes": [
{
"id": "af4dca79-fc8e-41d5-bbc6-be6a0af0ad3a",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-460,
-240
],
"parameters": {
"color": 3,
"width": 1260,
"height": 280,
"content": "Automates handling of incoming calls and provides trip organizer details."
},
"typeVersion": 1
},
{
"id": "8aa86c3e-d59d-44b2-a8cb-50db724fe6d3",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-460,
60
],
"parameters": {
"color": 4,
"width": 1260,
"height": 240,
"content": "Processes incoming call data and facilitates trip booking creation."
},
"typeVersion": 1
},
{
"id": "488083fa-1c35-4a97-afc5-a34f41de7db2",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-460,
320
],
"parameters": {
"width": 1260,
"height": 240,
"content": "Manages outbound marketing calls to promote trip organizer services."
},
"typeVersion": 1
},
{
"id": "399c3e41-f02b-43a8-868e-e7e6e34cfb4d",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-460,
580
],
"parameters": {
"color": 6,
"width": 1260,
"height": 240,
"content": "Captures incoming call data and stores it in an organized spreadsheet."
},
"typeVersion": 1
},
{
"id": "a5761758-38de-45c0-b370-54c89ebc9a19",
"name": "着信検出",
"type": "n8n-nodes-base.webhook",
"position": [
-100,
-120
],
"webhookId": "1b47597a-8d5a-4d56-b437-c72e376d4a39",
"parameters": {
"path": "get-call",
"options": {},
"httpMethod": "POST",
"responseMode": "responseNode"
},
"typeVersion": 2
},
{
"id": "fbc65023-df99-4a59-9812-52c9248c4091",
"name": "旅行詳細の検証",
"type": "n8n-nodes-base.postgres",
"position": [
120,
-120
],
"parameters": {
"limit": 150,
"table": {
"__rl": true,
"mode": "name",
"value": "table_id"
},
"schema": {
"__rl": true,
"mode": "list",
"value": "public"
},
"options": {},
"operation": "select"
},
"credentials": {
"postgres": {
"id": "4Y4qEFGqF2krfRHZ",
"name": "Postgres-test"
}
},
"typeVersion": 2.6
},
{
"id": "63210889-5513-4de4-99b1-6bd8c9fe646f",
"name": "主催者情報の提供",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
340,
-120
],
"parameters": {
"options": {},
"respondWith": "json",
"responseBody": "={\n \"results\": [\n {\n \"toolCallId\": \"{{ $('Detect Incoming Call').item.json.body.message.toolCalls[0].id }}\",\n \"result\": \"{{ $json.available }}\"\n }\n ]\n}"
},
"typeVersion": 1.2
},
{
"id": "d8a23c3d-ea59-4c70-a22a-17f3296880c8",
"name": "音声入力のキャプチャ",
"type": "n8n-nodes-base.webhook",
"position": [
-100,
140
],
"webhookId": "967e0eb1-219d-4354-96a1-21ef3b083cce",
"parameters": {
"path": "input-data",
"options": {},
"httpMethod": "POST",
"responseMode": "responseNode"
},
"typeVersion": 2
},
{
"id": "72fdf7e7-e6be-42a9-92e3-81916a87d502",
"name": "予約記録の更新",
"type": "n8n-nodes-base.postgres",
"position": [
120,
140
],
"parameters": {
"table": {
"__rl": true,
"mode": "name",
"value": "table_id"
},
"schema": {
"__rl": true,
"mode": "list",
"value": "public"
},
"columns": {
"value": {},
"schema": [],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "upsert"
},
"credentials": {
"postgres": {
"id": "4Y4qEFGqF2krfRHZ",
"name": "Postgres-test"
}
},
"typeVersion": 2.6
},
{
"id": "43775581-f2b5-41d3-8779-9554b308cc37",
"name": "予約確認の送信",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
340,
140
],
"parameters": {
"options": {},
"respondWith": "json",
"responseBody": "={\n \"results\": [\n {\n \"toolCallId\": \"{{ $('Capture Voice Input').item.json.body.message.toolCalls[0].id }}\",\n \"result\": \"{{ $json.status }}\"\n }\n ]\n}"
},
"typeVersion": 1.2
},
{
"id": "596e1ef1-6029-4c84-8dab-dc89675410bd",
"name": "新規リードの検出",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-100,
400
],
"parameters": {
"event": "rowAdded",
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "id",
"value": "0oijhgfr456yujhnbvcdew23erfg"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "9iuhgft567ujm"
}
},
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"id": "BoDTTv5L67GVL3Fi",
"name": "Google Sheets - test"
}
},
"typeVersion": 1
},
{
"id": "3bb67923-991a-4a6d-8caa-ae683d97e014",
"name": "リード情報のフォーマット",
"type": "n8n-nodes-base.set",
"position": [
120,
400
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "a10873fa-0c01-46ed-a364-d31200e44e76",
"name": "Phone_number",
"type": "string",
"value": "=+{{ $json.Phone }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "df04836b-262e-418d-9ed0-83424793be10",
"name": "マーケティングアウトリーチの開始",
"type": "n8n-nodes-base.httpRequest",
"position": [
340,
400
],
"parameters": {
"url": "https://api.vapi.ai/call",
"method": "POST",
"options": {},
"jsonBody": "={\n \"assistantId\": \"add_id_here\",\n \"phoneNumberId\": \"add_id_here\",\n \"customers\": [\n {\n \"number\":\"{{ $json.Phone }}\"\n }\n ]\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "httpBearerAuth"
},
"credentials": {
"httpBearerAuth": {
"id": "JzfcNGi2NYJB6wll",
"name": "Bearer Auth account"
}
},
"typeVersion": 4.2
},
{
"id": "960ff7a4-e8ba-42c0-88ad-f35f4a197a0d",
"name": "コール応答の受信",
"type": "n8n-nodes-base.webhook",
"position": [
-100,
660
],
"webhookId": "a34ac7ac-7ea4-4942-8dbf-f9ce3f0986e4",
"parameters": {
"path": "call",
"options": {},
"httpMethod": "POST",
"responseMode": "responseNode"
},
"typeVersion": 2
},
{
"id": "67340244-b65a-4a72-a91d-1655660ea30e",
"name": "ユーザー入力の記録",
"type": "n8n-nodes-base.googleSheets",
"position": [
120,
660
],
"parameters": {
"columns": {
"value": {
"call_notes": "={{ $json.body.message.toolCalls[0].function.arguments.call_notes }}",
"website_url": "={{ $json.body.message.toolCalls[0].function.arguments.website_url }}",
"call_outcome": "={{ $json.body.message.toolCalls[0].function.arguments.call_outcome }}",
"company_name": "={{ $json.body.message.toolCalls[0].function.arguments.company_name }}",
"phone_number": "={{ $json.body.message.toolCalls[0].function.arguments.phone_number }}",
"email_address": "={{ $json.body.message.toolCalls[0].function.arguments.email_address }}",
"prospect_name": "={{ $json.body.message.toolCalls[0].function.arguments.prospect_name }}",
"follow_up_date": "={{ $json.body.message.toolCalls[0].function.arguments.follow_up_date }}",
"interest_level": "={{ $json.body.message.toolCalls[0].function.arguments.interest_level }}",
"biggest_challenge": "={{ $json.body.message.toolCalls[0].function.arguments.biggest_challenge }}",
"appointment_datetime": "={{ $json.body.message.toolCalls[0].function.arguments.appointment_datetime }}"
},
"schema": [
{
"id": "prospect_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "prospect_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "prospect_role",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "prospect_role",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "website_url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "website_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "website_strength",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "website_strength",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "phone_number",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "phone_number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email_address",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "email_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "current_marketing_methods",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "current_marketing_methods",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "biggest_challenge",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "biggest_challenge",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "previous_digital_marketing",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "previous_digital_marketing",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "objections_raised",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "objections_raised",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "interest_level",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "interest_level",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "next_step",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "next_step",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "appointment_datetime",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "appointment_datetime",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "call_outcome",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "call_outcome",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "call_notes",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "call_notes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "follow_up_date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "follow_up_date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "opt_out_requested",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "opt_out_requested",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"phone_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1mkHJIhSFXdh1n65GKPwzEzFw0QasunyYm9BDglnXeiI/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "0oijht5tfcs3edfvgb"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "ScSS2KxGQULuPtdy",
"name": "Google Sheets- test"
}
},
"typeVersion": 4.5
},
{
"id": "88197c5d-710f-43e7-871b-b152a64f5eab",
"name": "システムへの応答の転送",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
340,
660
],
"parameters": {
"options": {}
},
"typeVersion": 1.2
}
],
"active": false,
"pinData": {},
"settings": {
"timezone": "Asia/Kolkata",
"callerPolicy": "workflowsFromSameOwner",
"executionOrder": "v1"
},
"versionId": "a40c9c99-5c96-4096-bd86-fe5b8ce33ed8",
"connections": {
"67340244-b65a-4a72-a91d-1655660ea30e": {
"main": [
[
{
"node": "88197c5d-710f-43e7-871b-b152a64f5eab",
"type": "main",
"index": 0
}
]
]
},
"596e1ef1-6029-4c84-8dab-dc89675410bd": {
"main": [
[
{
"node": "3bb67923-991a-4a6d-8caa-ae683d97e014",
"type": "main",
"index": 0
}
]
]
},
"d8a23c3d-ea59-4c70-a22a-17f3296880c8": {
"main": [
[
{
"node": "72fdf7e7-e6be-42a9-92e3-81916a87d502",
"type": "main",
"index": 0
}
]
]
},
"a5761758-38de-45c0-b370-54c89ebc9a19": {
"main": [
[
{
"node": "fbc65023-df99-4a59-9812-52c9248c4091",
"type": "main",
"index": 0
}
]
]
},
"960ff7a4-e8ba-42c0-88ad-f35f4a197a0d": {
"main": [
[
{
"node": "67340244-b65a-4a72-a91d-1655660ea30e",
"type": "main",
"index": 0
}
]
]
},
"72fdf7e7-e6be-42a9-92e3-81916a87d502": {
"main": [
[
{
"node": "43775581-f2b5-41d3-8779-9554b308cc37",
"type": "main",
"index": 0
}
]
]
},
"fbc65023-df99-4a59-9812-52c9248c4091": {
"main": [
[
{
"node": "63210889-5513-4de4-99b1-6bd8c9fe646f",
"type": "main",
"index": 0
}
]
]
},
"3bb67923-991a-4a6d-8caa-ae683d97e014": {
"main": [
[
{
"node": "df04836b-262e-418d-9ed0-83424793be10",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - 顧客管理
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
ExcelとVAPI音声アシスタントを活用したレストランの宣伝と予約の自動化
レストランの販促と予約をExcel、VAPIのボイスアシスタント、カレンダーで自動化
Set
Code
Webhook
+
Set
Code
Webhook
11 ノードOneclick AI Squad
リードナーチャリング
複数プラットフォームからホテル料金をクロールしメールレポートで自動比較
ホテル価格比較を複数プラットフォームでのスクレイピングとメールレポートで自動化
If
Set
Code
+
If
Set
Code
19 ノードOneclick AI Squad
市場調査
Instagram インフルエンサーの成果物および契約準拠性の自動化
Claude AI と Slack アラートを使って Instagram インフルエンサー契約の合従性を自動化
If
Set
Code
+
If
Set
Code
26 ノードOneclick AI Squad
ソーシャルメディア
AIを活用したリード生成による不動産権益メールと電話販売
Llama AI、VAPIコール、Gmailマーケティングで不動産マーケティングを自動化する
Code
Wait
Gmail
+
Code
Wait
Gmail
23 ノードOneclick AI Squad
リードナーチャリング
音声通話 (VAPI) および Google Sheets を使用したB2Bリーダーズの自動スクリーニング
B2B リーダー鋳造の自動洗選
Webhook
Http Request
Google Sheets
+
Webhook
Http Request
Google Sheets
10 ノードOneclick AI Squad
リード獲得
詐欺性予約検出器：AIを使用して可疑な旅行取引を識別
詐欺のな予約検出器：Google Geminiを使った可疑な旅行取引の識別
If
Set
Code
+
If
Set
Code
20 ノードOneclick AI Squad
セキュリティ運用
ワークフロー情報
難易度
上級
ノード数16
カテゴリー1
ノードタイプ8
作成者
Oneclick AI Squad
@oneclick-aiThe AI Squad Initiative is a pioneering effort to build, automate and scale AI-powered workflows using n8n.io. Our mission is to help individuals and businesses integrate AI agents seamlessly into their daily operations from automating tasks and enhancing productivity to creating innovative, intelligent solutions. We design modular, reusable AI workflow templates that empower creators, developers and teams to supercharge their automation with minimal effort and maximum impact.
外部リンク
n8n.ioで表示 →
このワークフローを共有