Sprachassistent - Restaurantreservierung, Bestellung und Informationssystem

Name: Sprachassistent - Restaurantreservierung, Bestellung und Informationssystem
Rating: 4.5 (10 reviews)
Author: Oneclick AI Squad

Fortgeschritten

Dies ist ein Support Chatbot, AI Chatbot-Bereich Automatisierungsworkflow mit 10 Nodes. Hauptsächlich werden Wait, Webhook, Postgres, RespondToWebhook und andere Nodes verwendet. Restaurant-Sprachassistent mit VAPI und PostgreSQL zur Unterstützung von Reservierungen und Bestellungen bauen

Voraussetzungen

•HTTP Webhook-Endpunkt (wird von n8n automatisch generiert)
•PostgreSQL-Datenbankverbindungsdaten

Verwendete Nodes (10)

Kategorie

Support-Chatbot

KI-Chatbot

Workflow-Vorschau

Visualisierung der Node-Verbindungen, mit Zoom und Pan

Trigger: Sprachanfrage (VAPI)

Daten aktualisieren (Tischreservierung / Bestellungen)

Antwort: Reservierungs-/Bestellbestätigung (VAPI)

Auf Antwort warten

Auf Antwort warten1

Trigger: Informationsanfrage (VAPI)

Restaurantinformationen abrufen (Postgres)

Antwort: Restaurandetails (VAPI)

React Flow

Workflow exportieren

Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n

{
  "id": "FBguDlbJmbBGngKf",
  "meta": {
    "instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
    "templateCredsSetupCompleted": true
  },
  "name": "Voice Assistant – Restaurant Booking, Orders & Info System",
  "tags": [],
  "nodes": [
    {
      "id": "ca6c5397-c47e-4fde-b08a-c996fc5b242b",
      "name": "Trigger: Sprachanfrage (VAPI)",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -20,
        -380
      ],
      "webhookId": "9f6b9125-0b75-41c2-87a9-1b6746c89e2e",
      "parameters": {
        "path": "9f6b9125-0b75-41c2-87a9-1b6746c89e2e",
        "options": {},
        "httpMethod": "POST",
        "responseMode": "responseNode"
      },
      "typeVersion": 2
    },
    {
      "id": "bbb963c4-1fc3-4dbc-84c5-ed818197fc8a",
      "name": "Daten aktualisieren (Tischreservierung / Bestellungen)",
      "type": "n8n-nodes-base.postgres",
      "position": [
        420,
        -380
      ],
      "parameters": {
        "table": {
          "__rl": true,
          "mode": "name",
          "value": "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": "97376776-cc21-434b-89b3-e373d4fcc0fe",
      "name": "Antwort: Reservierungs-/Bestellbestätigung (VAPI)",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        640,
        -380
      ],
      "parameters": {
        "options": {},
        "respondWith": "json",
        "responseBody": "={\n    \"results\": [\n        {\n            \"toolCallId\": \"{{ $('Trigger: Voice Request (VAPI)').item.json.body.message.toolCalls[0].id }}\",\n            \"result\": \"{{ $json.status }}\"\n        }\n    ]\n}"
      },
      "typeVersion": 1.2
    },
    {
      "id": "7cdb8cb3-94fd-4784-9b79-c9ae26fd7ae6",
      "name": "Auf Antwort warten",
      "type": "n8n-nodes-base.wait",
      "position": [
        200,
        -380
      ],
      "webhookId": "70ef62ba-b15e-48d6-b6ea-031f1ad02176",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "f715f043-661b-4118-9763-642128d936ce",
      "name": "Auf Antwort warten1",
      "type": "n8n-nodes-base.wait",
      "position": [
        420,
        -120
      ],
      "webhookId": "5282819f-e54d-415e-a2a2-384df4b9f71d",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "4a2f8aee-6e5a-44d5-873c-8b8c28aeff3b",
      "name": "Trigger: Informationsanfrage (VAPI)",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -20,
        -120
      ],
      "webhookId": "efe2c13f-1ba5-46e1-9996-57bdc6041973",
      "parameters": {
        "path": "efe2c13f-1ba5-46e1-9996-57bdc6041973",
        "options": {},
        "httpMethod": "POST",
        "responseMode": "responseNode"
      },
      "typeVersion": 2
    },
    {
      "id": "33a7e434-5228-4475-9b21-a5afb7c8656b",
      "name": "Restaurantinformationen abrufen (Postgres)",
      "type": "n8n-nodes-base.postgres",
      "position": [
        200,
        -120
      ],
      "parameters": {
        "table": {
          "__rl": true,
          "mode": "name",
          "value": "id"
        },
        "schema": {
          "__rl": true,
          "mode": "list",
          "value": "public"
        },
        "options": {},
        "operation": "select"
      },
      "credentials": {
        "postgres": {
          "id": "4Y4qEFGqF2krfRHZ",
          "name": "Postgres-test"
        }
      },
      "typeVersion": 2.6
    },
    {
      "id": "09058c8d-e3f4-4caa-898a-123ef4ec3eba",
      "name": "Antwort: Restaurandetails (VAPI)",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        640,
        -120
      ],
      "parameters": {
        "options": {},
        "respondWith": "json",
        "responseBody": "={\n    \"results\": [\n        {\n            \"toolCallId\": \"{{ $('Trigger: Info Request (VAPI)').item.json.body.message.toolCalls[0].id }}\",\n            \"result\":  \"{{ $json.available }}\"\n        }\n    ]\n}"
      },
      "typeVersion": 1.2
    },
    {
      "id": "e5c43fa2-68c9-4303-bd74-6662cf95a05f",
      "name": "Notiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -480,
        -620
      ],
      "parameters": {
        "color": 4,
        "width": 440,
        "height": 340,
        "content": "## Table Booking & Order Handling\n\n- Use this workflow to let the voice assistant take table reservations and food orders from customers.\n\n- It saves booking and order details into the database and confirms them back to the customer instantly.\n\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "4ec14fb4-e367-4b3f-bba4-50cc70c008d2",
      "name": "Notiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -500,
        -220
      ],
      "parameters": {
        "width": 480,
        "height": 340,
        "content": "## Restaurant Info Provider\n\n- Use this workflow to let the voice assistant take table reservations and food orders from customers.\n\n- It saves booking and order details into the database and confirms them back to the customer instantly.\n\n\n"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "timezone": "Asia/Kolkata",
    "callerPolicy": "workflowsFromSameOwner",
    "executionOrder": "v1"
  },
  "versionId": "01e81376-112a-42ae-bb2f-5037a2d5da94",
  "connections": {
    "7cdb8cb3-94fd-4784-9b79-c9ae26fd7ae6": {
      "main": [
        [
          {
            "node": "bbb963c4-1fc3-4dbc-84c5-ed818197fc8a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f715f043-661b-4118-9763-642128d936ce": {
      "main": [
        [
          {
            "node": "09058c8d-e3f4-4caa-898a-123ef4ec3eba",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4a2f8aee-6e5a-44d5-873c-8b8c28aeff3b": {
      "main": [
        [
          {
            "node": "33a7e434-5228-4475-9b21-a5afb7c8656b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ca6c5397-c47e-4fde-b08a-c996fc5b242b": {
      "main": [
        [
          {
            "node": "7cdb8cb3-94fd-4784-9b79-c9ae26fd7ae6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "33a7e434-5228-4475-9b21-a5afb7c8656b": {
      "main": [
        [
          {
            "node": "f715f043-661b-4118-9763-642128d936ce",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "bbb963c4-1fc3-4dbc-84c5-ed818197fc8a": {
      "main": [
        [
          {
            "node": "97376776-cc21-434b-89b3-e373d4fcc0fe",
            "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?

Fortgeschritten - Support-Chatbot, KI-Chatbot

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.