Système de gestion des appels téléphoniques de voyage complet - suivi des appels, réservation d'itinéraire et marketing
Avancé
Ceci est unCRMworkflow d'automatisation du domainecontenant 16 nœuds.Utilise principalement des nœuds comme Set, Webhook, Postgres, HttpRequest, GoogleSheets. Automatiser les opérations d'agence de voyages avec Postgres, Google Sheets et une API vocale
Prérequis
- •Point de terminaison HTTP Webhook (généré automatiquement par n8n)
- •Informations de connexion à la base de données PostgreSQL
- •Peut nécessiter les informations d'identification d'authentification de l'API cible
- •Informations d'identification Google Sheets API
Nœuds utilisés (16)
Catégorie
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
"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": "Note adhésive",
"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": "Note adhésive1",
"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": "Note adhésive2",
"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": "Note adhésive3",
"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": "Détecter l'appel entrant",
"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": "Valider les détails du voyage",
"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": "Transmettre les infos organisateur",
"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": "Capturer la saisie vocale",
"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": "Mettre à jour l'enregistrement de réservation",
"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": "Envoyer la confirmation de réservation",
"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": "Détecter un nouveau prospect",
"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": "Formater les infos du prospect",
"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": "Lancer la prospection marketing",
"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": "Recevoir la réponse d'appel",
"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": "Enregistrer la saisie utilisateur",
"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": "Relayer la réponse au système",
"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
}
]
]
}
}
}Foire aux questions
Comment utiliser ce workflow ?
Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.
Dans quelles scénarios ce workflow est-il adapté ?
Avancé - CRM
Est-ce payant ?
Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.
Workflows recommandés
Automatisation du marketing et des réservations de restaurant avec Excel et l'assistant vocal VAPI
Automatisation du marketing et des réservations pour les restaurants avec Excel, l'assistant vocal VAPI et le calendrier
Set
Code
Webhook
+
Set
Code
Webhook
11 NœudsOneclick AI Squad
Nurturing de leads
Comparaison automatique des prix des hôtels par grattage multiplateforme et rapports par e-mail
Automatiser la comparaison des prix des hôtels avec un web scraping multiplateforme et des rapports par e-mail
If
Set
Code
+
If
Set
Code
19 NœudsOneclick AI Squad
Étude de marché
Automatisation de la conformité des livrables et des contrats pour les influenceurs Instagram
Automatiser la conformité des contrats d'influenceurs Instagram avec Claude AI et des rappels Slack
If
Set
Code
+
If
Set
Code
26 NœudsOneclick AI Squad
Réseaux sociaux
Marketing par e-mail et téléphone immobilier intelligent avec génération automatisée de prospects par IA
Automatisation du marketing immobilier avec l'IA Llama, les appels VAPI et les campagnes Gmail
Code
Wait
Gmail
+
Code
Wait
Gmail
23 NœudsOneclick AI Squad
Nurturing de leads
Automatisation de la qualification des prospects B2B via des appels vocaux (VAPI) et Google Sheets
Qualification des prospects B2B
Webhook
Http Request
Google Sheets
+
Webhook
Http Request
Google Sheets
10 NœudsOneclick AI Squad
Génération de leads
Détecteur de réservations frauduleuses : identification de transactions de voyage suspects avec l'IA
Détecteur de réservations frauduleuses : identification des transactions de voyage suspectes avec Google Gemini
If
Set
Code
+
If
Set
Code
20 NœudsOneclick AI Squad
Opérations de sécurité
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds16
Catégorie1
Types de nœuds8
Description de la difficulté
Auteur
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.
Liens externes
Voir sur n8n.io →
Partager ce workflow