Build a restaurant voice assistant with VAPI and PostgreSQL for bookings & orders
Ready for 3.0What this workflow does
This workflow has 8 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Postgres.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).
- Wait: pauses before continuing
- Get Restaurant Info (Postgres) (Postgres): select
- Update Data (Table Booking / Orders) (Postgres): create or update
- Wait: pauses before continuing
- Respond: Booking/Order Confirmation (VAPI) (Respond to Webhook): sends the response back to the webhook caller
- Respond: Restaurant Details (VAPI) (Respond to Webhook): sends the response back to the webhook caller
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (4)
- Webhook
n8n-nodes-base.webhook - Postgres
n8n-nodes-base.postgres - Respond to Webhook
n8n-nodes-base.respondToWebhook - Wait
n8n-nodes-base.wait
From the author
This n8n template demonstrates how to create a comprehensive voice-powered restaurant assistant that handles table reservations, food orders, and restaurant information requests through natural language processing. The system uses VAPI for voice interaction…