Templates / Automated restaurant call handling & table booking system with VAPI and PostgreSQL

Automated restaurant call handling & table booking system with VAPI and PostgreSQL

Ready for 3.0

by Oneclick AI Squad ✓ · 8,705 views · created 2025-06-30 · Support Chatbot, AI Chatbot

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 6 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).

  1. Upsert Booking in Postgres (Postgres): create or update
  2. Query Table Availability (Postgres) (Postgres): select
  3. Respond: Booking Confirmation (VAPI) (Respond to Webhook): sends the response back to the webhook caller
  4. Respond: Availability Status (VAPI) (Respond to Webhook): sends the response back to the webhook caller

Services it uses

Postgres

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 (3)

From the author

Acts as a virtual receptionist for the restaurant, handling incoming calls via VAPI without human intervention. It collects user details (name, booking time, number of people) for table bookings, checks availability in a PostgreSQL database using n8n, books…

Excerpt from Oneclick AI Squad's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.