AutomationMart
Home/Browse/Build a restaurant voice assistant with VAPI and PostgreSQL for bookings & orders
n8n

Build a restaurant voice assistant with VAPI and PostgreSQL for bookings & orders

n8nn8n8 modulesv1.0
postgresrespondToWebhookwaitwebhook

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 and PostgreSQL for data management, making it perfect for restaurants looking to automate customer service with voice AI technology. Good to know Voice processing requires active VAPI subscription with per-minute billing Database ope

At a glance

Build a restaurant voice assistant with VAPI and PostgreSQL for bookings & orders is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects postgres, respondToWebhook, wait, webhook. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
postgres, respondToWebhook, wait, webhook
Modules
8
Price
Free
Version
v1.0
Build a restaurant voice assistant with VAPI and PostgreSQL for bookings & orders workflow diagram

About this workflow

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 and PostgreSQL for data management, making it perfect for restaurants looking to automate customer service with voice AI technology. Good to know Voice processing requires active VAPI subscription with per-minute billing Database operations are handled in real-time with immediate confirmations The system can handle multiple simultaneous voice requests All customer data is stored securely in PostgreSQL with proper indexing How it works Table Booking & Order Handling Workflow Voice requests are captured through VAPI triggers when customers make booking or ordering requests The system processes natural language commands and extracts relevant details (party size, time, food items) Customer data is immediately saved to the bookings and orders tables in PostgreSQL Voice confirmations are sent back through VAPI with booking details and estimated wait times All transactions are logged with timestamps for restaurant management tracking Restaurant Info Provider Workflow Info requests trigger when customers ask about hours, menu, location, or services Restaurant details are retrieved from the restaurantinfo table containing current information Wait nodes ensure proper data loading before voice response generation Structured restaurant information is delivered via VAPI in natural, conversational format Database Schema Bookings Table bookingid (PRIMARY KEY) - Unique identifier for each reservation customername - Customer's full name phonenumber - Contact number for confirmation partysize - Number of guests bookingdate - Requested reservation date bookingtime - Requested time slot specialrequests - Dietary restrictions or special occasions status - Booking status (confirmed, pending, cancelled) createdat - Timestamp of booking creation Orders Table orderid (PRIMARY KEY) - Unique order identifier customername - Customer's name phonenumber - Contact for order updates orderitems - JSON array of food items and quantities totalamount - Calculated order total ordertype - Delivery, pickup, or dine-in specialinstructions - Cooking preferences or allergies status - Order status (received, preparing, ready, delivered) createdat - Order timestamp RestaurantInfo Table infoid (PRIMARY KEY) - Information entry identifier category - Type of info (hours, menu, location, contact) title - Information title description - Detailed information content isactive - Whether info is currently valid updatedat - Last modification timestamp How to use The manual trigger can be replaced with webhook triggers for integration with existing restaurant systems Import the workflow into your n8n instance and configure VAPI credentials Set up PostgreSQL database with the required tables using the schema provided above Configure restaurant information in the restaurantinfo table Test voice commands such as "Book a table for 4 people at 7 PM" or "What are your opening hours?" Customize voice responses in VAPI nodes to match your restaurant's tone and branding The system can handle multiple concurrent voice requests and scales with your restaurant's needs Requirements VAPI account for voice processing and natural language understanding PostgreSQL database for storing booking, order, and restaurant information n8n instance with database and VAPI integrations enabled Customising this workflow Voice AI automation can be adapted for various restaurant types - from quick service to fine dining establishments Try popular use-cases such as multi-location booking management, dietary restriction handling, or integration with existing POS systems The workflow can be extended to include payment processing, SMS notifications, and third-party delivery platform integration

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Track Forex Factory news releases with MyFxBook, Telegram & Google Sheets

Get Forex Factory News Release to Telegram, Google Sheets. Record News Data and Live Price from MyFxBook for Affected Currency Pairs. This n8n template demonstrates how to capture Actual Data Releases as quickly as possible for trading decisions. Use cases: 1. Get notified if the actual data release is positive or negative for the relevant currency. 2. Use the Telegram chat message about the news release as a trigger to open a trading position in MetaTrader 4. 3. Record news data and live price

Free

Generate AI videos with Google Veo3, save to Google Drive and upload to YouTube

This workflow allows users to generate AI videos using Google Veo3, save them to Google Drive, generate optimized YouTube titles with GPT-4o, and automatically upload them to YouTube with Upload-Post. The entire process is triggered from a Google Sheet that acts as the central interface for input and output. IT automates video creation, uploading, and tracking, ensuring seamless integrat

Free

AI-powered HR screening automation via Jotform

Who's it for - HR professionals and recruitment teams handling high application volumes - Startup founders and hiring managers seeking to scale hiring efficiently - Companies wanting consistent, objective candidate evaluation - Teams spending 20+ hours per week on manual resume screening What it does - Receives job applications automatically via Jotform webhook - Downloads and parses resume PDFs using LlamaParse AI extraction - Analyzes candidate qualifications with OpenAI GPT-4 (compatibility s

Free

Auto generate & post LinkedIn content for Amazon sellers with GPT-4o & Apify

How it works This powerful automation turns LinkedIn influencer activity into high performing Amazon seller content, fully hands-off. It runs in two phases: 1. AI Content Generator Retrieves influencer usernames from Airtable Scrapes their most recent LinkedIn post via Apify Uses OpenAI (GPT-4o) to generate original Amazon focused post content Generates a branded LinkedIn image using AI (WeSpark visual identity) Saves content & image link to Google Drive Creates a record in Airtable with S

Free

Scrape high-engagement LinkedIn posts and auto-post with Gemini images

Who's it for This workflow is ideal for: - Content creators who want to replicate successful LinkedIn strategies - Social media managers monitoring competitor content performance - Marketing teams analyzing trending topics in their industry - Personal brands looking to create data-driven content - Agencies managing multiple LinkedIn accounts What it does This comprehensive workflow automates the entire LinkedIn content lifecycle: it scrapes viral posts from target accounts, analyzes engagement p

Free

Generate invoices, save to Drive and send email to customer with JS + G Sheets

This workflow automates invoice generation from form submissions, ensuring unique order IDs, creating PDF invoices, storing files, emailing customers, and logging invoice data — all seamlessly integrated. --- 🔹 Workflow Overview 1. Trigger (Webhook) Starts when an order form is submitted, capturing customer and order details. 2. Generate Random Order ID A Function node creates a unique alphanumeric invoice ID (e.g., INV-X92B7D). 3. Check for Duplicate Order ID Goog

Free

Generate and email PDF payslips from Google Sheets with Gmail

This workflow automates the entire payslip process by pulling payroll data directly from Google Sheets, generating a professional and secure PDF for each employee, and emailing it to them instantly. Save hours of manual HR administration, eliminate human error, and ensure timely, confidential delivery of payslips every month. Why Use This Workflow? Time Savings: Reduces the entire payslip generation and distribution process from hours

Free

Automated B2B lead generation: Google Places, Scrape.do & AI enrichment

Automated B2B Lead Generation: Google Places, Scrape.do & AI Enrichment This workflow is a powerful, fully automated B2B lead generation engine. It starts by finding businesses on Google Maps based on your criteria (e.g., "dentists" in "Istanbul"), assigns a quality score to each, and then uses Scrape.do to reliably access their websites. Finally, it leverages an AI agent to extract valuable contact information like emails and social media profiles. Th

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free