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

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 the table if available, and sends confirmation. It also provides restaurant details to users, mimicking a human receptionist.

Key Insights

1. VAPI must be configured to accurately capture user input for bookings and inquiries. 2. PostgreSQL database requires a table to manage restaurant bookings and availability.

Workflow Process

- Initiate the workflow with a VAPI call to collect user details (name, time, number of people). - Use n8n to query the PostgreSQL database for table availability. - If a table is available, book it using n8n and update the PostgreSQL database. - Send a booking confirmation and hotel service details back to VAPI via n8n. - Store and update restaurant table data in the PostgreSQL database using n8n.

Usage Guide

1. Import the workflow into n8n and configure VAPI and PostgreSQL credentials. 2. Test with a sample VAPI call to ensure proper data collection and booking confirmation.

Prerequisites