8
n8n Deutschamn8n.com

Vollständiges reisebasiertes Telefonmanagementsystem - Anruf-Tracking, Reisebuchungen und Marketing

Experte

Dies ist ein CRM-Bereich Automatisierungsworkflow mit 16 Nodes. Hauptsächlich werden Set, Webhook, Postgres, HttpRequest, GoogleSheets und andere Nodes verwendet. Automatisierung der Reisebüro-Betriebsabläufe mit Postgres, Google Sheets und Sprach-API

Voraussetzungen
  • •HTTP Webhook-Endpunkt (wird von n8n automatisch generiert)
  • •PostgreSQL-Datenbankverbindungsdaten
  • •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
  • •Google Sheets API-Anmeldedaten

Verwendete Nodes (16)

Set
Webhook
Postgres
StickyNote
HttpRequest
GoogleSheets
RespondToWebhook
GoogleSheetsTrigger

Kategorie

Kundenbeziehungsmanagement
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
React Flow
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in 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": "Notizzettel",
      "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": "Notizzettel1",
      "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": "Notizzettel2",
      "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": "Notizzettel3",
      "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": "Eingehenden Anruf erkennen",
      "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": "Reisedetails validieren",
      "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": "Organisatorinformationen bereitstellen",
      "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": "Spracheingabe erfassen",
      "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": "Buchungsdatensatz aktualisieren",
      "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": "Buchungsbestätigung senden",
      "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": "Neuen Lead erkennen",
      "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": "Lead-Informationen formatieren",
      "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": "Marketing-Kampagne initiieren",
      "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": "Anrufantwort empfangen",
      "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": "Benutzereingabe protokollieren",
      "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": "Antwort an System weiterleiten",
      "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
          }
        ]
      ]
    }
  }
}
Häufig gestellte Fragen

Wie verwende ich diesen Workflow?

Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.

Für welche Szenarien ist dieser Workflow geeignet?

Experte - Kundenbeziehungsmanagement

Ist es kostenpflichtig?

Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.

Verwandte Workflows

Automatisierung von Restaurantmarketing und -reservierungen mit Excel und dem VAPI-Sprachassistenten
Automatisierung des Restaurantmarketings und der Reservierungen mit Excel, VAPI-Sprachassistent und Kalender
Set
Code
Webhook
+
Set
Code
Webhook
11 NodesOneclick AI Squad
Lead-Pflege
Automatischer Preisvergleich von Hotels durch Multi-Platform-Crawling und E-Mail-Berichte
Automatisierung des Hotelpreisvergleichs durch Multi-Platform-Scraping und E-Mail-Berichte
If
Set
Code
+
If
Set
Code
19 NodesOneclick AI Squad
Marktforschung
Automatisierung von Instagram-Influencer-Lieferungen und Vertragskonformität
Automatisierte Erinnerungen zur Einhaltung von Instagram-Influencer-Verträgen mit Claude AI und Slack
If
Set
Code
+
If
Set
Code
26 NodesOneclick AI Squad
Soziale Medien
Intelligente Immobilien-E-Mail- und Telefonmarketing-Kampagne mit KI-generierten Leads
Automatisierung der Immobilienmarketing mit Llama AI, VAPI-Anrufen und Gmail-Kampagnen
Code
Wait
Gmail
+
Code
Wait
Gmail
23 NodesOneclick AI Squad
Lead-Pflege
Automatisierte B2B-Lead-Qualifizierung mit Sprachanrufen (VAPI) und Google Sheets
B2B-Lead-Qualifizierung
Webhook
Http Request
Google Sheets
+
Webhook
Http Request
Google Sheets
10 NodesOneclick AI Squad
Lead-Generierung
Betrugsbuchungsdetektor: Nutzung von KI zur Identifizierung verdächtiger Reisebuchungen
Betrugsbuchungserkennung: Erkennung verdächtiger Reisebuchungen mit Google Gemini
If
Set
Code
+
If
Set
Code
20 NodesOneclick AI Squad
Sicherheitsbetrieb
Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes16
Kategorie1
Node-Typen8
Schwierigkeitsbeschreibung

Für fortgeschrittene Benutzer, komplexe Workflows mit 16+ Nodes

Autor
Oneclick AI Squad

Oneclick AI Squad

@oneclick-ai

The 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.

Externe Links
Auf n8n.io ansehen →

Diesen Workflow teilen

Kategorien

Multimodales KI
1540
Künstliche Intelligenz
1108
Content-Erstellung
695
KI-Zusammenfassung
516
Marketing
419
KI-Chatbot
251
Engineering
241
Marktforschung
203
Verschiedenes
193
Sonstiges
176
Vertrieb
162
IT-Betrieb
156
Dokumentenextraktion
147
KI RAG
146
Bausteine
144
Soziale Medien
137
Lead-Generierung
125
Persönliche Produktivität
117
DevOps
111
Personalwesen
101
Support
97
Lead-Pflege
87
Kundenbeziehungsmanagement
82
Finanzen
81
Produkt
77
Support-Chatbot
76
Design
70
Ticketverwaltung
67
Sicherheitsbetrieb
57
Rechnungsverarbeitung
53
Krypto-Handel
49
Dateiverwaltung
39
Projektmanagement
35
Internes Wiki
32

Kategorien: 34