Restaurant reservation management with OpenAI GPT and Google Sheets

Name: Restaurant reservation management with OpenAI GPT and Google Sheets
Availability: InStock
Author: Fakhar Khan

Restaurant reservation management with OpenAI GPT and Google Sheets preview

Open on n8n.io

$20/month : Unlimited workflows

2500 executions/month

Try free

THE #1 IN WEB SCRAPING

Scrape any website without limits

Try free

HOSTINGER

Early Deal
DISCOUNT 20%

Self-hosted n8n

Unlimited workflows - from $4.99/mo

Try free

#1 hub for scraping, AI & automation

6000+ actors - $5 credits/mo

Try free

Important notice

This workflow is provided as-is. Please review and test before using in production.

Overview

How it works

Receives chat messages from customers requesting table reservations.
Uses an AI Agent with OpenAI Chat Model to understand and process requests.
Checks table information, availability, and existing reservations from Google Sheets.
Calculates guest counts and reservation timing using the Calculator node.
Updates table availability and reservation records in real-time.
Handles reservation changes, including updates and cancellations.

Set up steps

Add credentials for OpenAI (Chat Model) and Google Sheets.
In the AI Agent node, link:
- Chat Model → OpenAI Chat Model node.
- Memory → Simple Memory node.
- Tools → Calculator and Google Sheets nodes for reservation data handling.
Configure Google Sheets nodes:
- Get Table Information (read sheet)
- Get Table Availability (read sheet)
- Get Table Reservations (read sheet)
- Update Table Availability (update sheet)
- Update Reservations (append sheet)
- Cancel Reservations (delete sheet)
Ensure your sheets have consistent column names for table IDs, dates, times, and guest counts.
Test by sending a reservation request through the chat trigger and verify updates in the Google Sheets.

Fakhar Khan

3 workflows

Nodes

@n8n/n8n-nodes-langchain.chattrigger n8n-nodes-base.googlesheetstool @n8n/n8n-nodes-langchain.memorybufferwindow @n8n/n8n-nodes-langchain.lmchatopenai @n8n/n8n-nodes-langchain.agent n8n-nodes-base.stickynote @n8n/n8n-nodes-langchain.toolcalculator

Complexity

advanced

Published 13 Aug 2025

Likes 0

View on n8n.io Download Workflow

Install path: /data/workflows/7323/7323.json

Share Your Workflow

Have a useful automation to share? Publish it and help the community.

Submit Your Template How to Submit

Related Workflows

Convert Supabase support FAQs to audio with Google Cloud TTS and Webflow

Enhance your support documentation with an audio-first experience. This workflow converts Supabase FAQ entries into high-quality audio using Google Cloud TTS, hosts them via a CDN, and embeds them into your Webflow support pages. --- ## 🎯 What This Workflow Does This template transforms static FAQ content into a professional audio library through a multi-stage process. --- ### 🔔 Step 1 — Webhook Intake & Intelligent Fetch - **Webhook Trigger:** Processes specific FAQ IDs or categories on demand - **Supabase Query:** Fetches unprocessed or requested FAQ records --- ### 📋 Step 2 — Data Enrichment & SSML Preparation - **Deduplication:** Ensures each FAQ is processed only once - **SSML Formatting:** Adds pauses and emphasis for natural speech delivery --- ### 🗣️ Step 3 — Google Cloud TTS & Hosting - **Audio Generation:** Converts text to MP3 using Google Cloud TTS (WaveNet) - **CDN Hosting:** Uploads audio via UploadToURL to generate a public URL --- ### 🌐 Step 4 — CMS Update & Database Write-Back - **Webflow Update:** Inserts audio URL into FAQ pages for playback - **Supabase Update:** Marks records as published with timestamps --- ### 💼 Step 5 — Reporting & Confirmations - **Microsoft Teams Alert:** Sends summary with audio links - **Webhook Response:** Returns JSON confirmation to trigger source --- ## ✨ Key Features - **Accessibility First:** Enables audio-based support consumption - **SSML Intelligence:** Improves clarity with structured speech formatting - **Rate-Limit Safe:** Processes items sequentially to avoid API limits - **Reliable Hosting:** UploadToURL ensures stable public audio URLs --- ## 🔧 Setup Requirements ### Required Integrations - **Supabase:** FAQ table - **Google Cloud TTS:** API enabled - **Webflow:** CMS API access - **UploadToURL:** CDN hosting - **Microsoft Teams:** Webhook URL --- Upgrade your support experience. Import this template to turn your FAQ library into a voice-enabled support center.

View

Plan voice-based travel and calendar bookings with Claude AI

A hands-free travel planning assistant that accepts voice messages via WhatsApp and Telegram, understands natural language travel requests, searches across multiple providers, and automatically books to your calendar with smart recommendations. ### How it works 1. **Voice Message Reception** - WhatsApp/Telegram webhooks capture incoming voice notes and calls 2. **Audio Transcription** - Converts voice to text using OpenAI Whisper or Google Speech-to-Text 3. **Intent Classification** - Claude AI analyzes the request to determine travel intent and parameters 4. **Context Enrichment** - Pulls user preferences, past trips, and budget profiles from database 5. **Multi-Source Travel Search** - Queries flights (Skyscanner), hotels (Booking.com), activities in parallel 6. **Smart Filtering & Ranking** - AI applies user preferences, budget constraints, and optimal timing 7. **Natural Response Generation** - Claude crafts conversational voice-friendly responses 8. **Calendar Auto-Add** - Creates Google Calendar events with travel details and reminders 9. **Voice Response Delivery** - Sends text + voice message back via original messaging platform 10. **Confirmation & Booking Links** - Provides quick-action buttons for booking or modifying search 11. **Proactive Follow-ups** - Sends price drop alerts and departure reminders 12. **Multi-Turn Conversation** - Maintains context for refinement requests ### Setup Steps 1. Import workflow into n8n 2. Configure credentials: - **Anthropic API** - Claude AI for NLP and response generation - **OpenAI API** - Whisper for voice transcription - **WhatsApp Business API** - Voice message reception and sending - **Telegram Bot API** - Alternative messaging platform - **Google Calendar API** - Automatic event creation - **Flight Search API** - Skyscanner, Amadeus, or Kiwi.com - **Hotel API** - Booking.com or Hotels.com partner API - **Google Sheets** - User preferences and conversation history - **MongoDB or PostgreSQL** - Conversation state management 3. Set up WhatsApp Business account and webhook 4. Create Telegram bot via @BotFather 5. Configure Google Calendar shared calendar for travel 6. Populate user preferences sheet with defaults 7. Set API keys for travel search providers 8. Activate workflow and test with sample voice message ### Sample Voice Requests **Simple Flight Search:** "Hey, find me cheap flights to Paris next month" **Complex Multi-City:** "I need to go to Tokyo in March for a week, then Bangkok for 3 days, budget is $2000 total" **Hotel Only:** "Book a hotel in Barcelona for May 15th to 20th, somewhere near the beach under $150 per night" **Full Package:** "Plan a romantic weekend in Santorini for our anniversary in June, nice hotel with sunset view, under $3000 for two people" **Activity Search:** "What are the best things to do in Amsterdam for 3 days, we like museums and food tours" **Calendar Query:** "When am I flying to London next month? And can you add a reminder 2 days before?" ### Voice Message Webhook Payload ```json { "platform": "whatsapp", "messageId": "wamid.ABC123XYZ", "from": "+15551234567", "timestamp": 1735804800, "type": "audio", "audio": { "id": "audio_id_12345", "mimeType": "audio/ogg", "sha256": "abc123...", "duration": 15, "url": "https://media.whatsapp.com/audio/abc123" }, "context": { "conversationId": "conv-user-001", "previousMessageId": null } } ``` ### Enterprise Features **Voice Intelligence:** - Multi-language transcription (30+ languages) - Accent-adaptive recognition - Background noise filtering - Speaker emotion detection for urgency **Smart Travel Search:** - Multi-provider aggregation (flights, hotels, activities) - Real-time price comparison - Flexible date search (±3 days optimization) - Budget-aware filtering - Loyalty program integration **AI-Powered Personalization:** - Learns from past bookings and preferences - Remembers dietary restrictions, seating preferences - Adapts to budget patterns - Suggests destinations based on season and interests **Proactive Assistance:** - Price drop alerts for saved searches - Flight delay notifications - Weather warnings before departure - Packing list generation - Travel insurance reminders **Calendar Intelligence:** - Conflict detection with existing events - Travel time buffer insertion - Timezone-aware scheduling - Shared calendar support for group trips - Automatic itinerary attachment **Security & Privacy:** - End-to-end encryption for voice messages - PII redaction in logs - Secure credential storage - GDPR-compliant data handling - User data deletion on request **Multi-Platform Support:** - WhatsApp Business - Telegram - Facebook Messenger - SMS fallback - Web widget integration

View

Book and manage appointments with Google Calendar and Gmail

## Overview This workflow automates the complete appointment booking process, from request validation to scheduling, notifications, and reminders. It checks calendar availability in real time, prevents double bookings, suggests alternative slots when unavailable, and automatically sends confirmations and reminders—ensuring a smooth and reliable booking experience. Perfect for service-based businesses, consultants, and teams managing appointments at scale. --- ## How It Works 1. **Webhook Trigger** - Receives booking requests (name, email, date, time, notes). 2. **Workflow Configuration** - Defines: - Google Calendar ID - Appointment duration - Business hours - Sender email 3. **Data Validation** - Parses and validates input fields - Ensures required data is present and correctly formatted 4. **Calendar Availability Check** - Fetches existing events from Google Calendar - Compares requested time with existing bookings 5. **Conflict Detection** - Detects overlapping events - Determines whether the slot is available 6. **Decision Logic** - If available → proceed with booking - If not available → trigger alternative flow --- ### Booking Flow (Available Slot) 7. **Create Calendar Event** - Schedules appointment in Google Calendar - Adds attendee and event details 8. **Confirmation Email** - Sends booking confirmation with event details - Includes calendar event link 9. **Webhook Response** - Returns success response to client/system 10. **Reminder System** - Schedules automated reminders: - 24-hour reminder before appointment - 1-hour reminder before appointment - Uses wait nodes to trigger emails at exact times - Includes appointment details to reduce no-shows --- ### Alternative Flow (Unavailable Slot) 11. **Generate Alternative Slots** - Finds next available time slots within business hours - Ensures slots are within a defined time window 12. **Alternative Email Notification** - Sends suggested time slots to the user 13. **Webhook Response** - Returns unavailable status with alternatives --- ## Setup Instructions 1. **Webhook Setup** - Configure endpoint (`booking`) - Connect to your frontend or booking form 2. **Google Calendar** - Add Google Calendar credentials - Set calendar ID 3. **Gmail Integration** - Add Gmail credentials for: - Confirmation emails - Reminder emails - Alternative slot notifications 4. **Configure Parameters** - Set: - Appointment duration (e.g., 60 minutes) - Business hours (e.g., 9–17) - Sender email 5. **Customize Messages** - Edit email templates for: - Confirmation - Alternatives - Reminders --- ## Use Cases - Appointment booking systems for businesses - Coaching and consulting session scheduling - Service-based business automation (salons, clinics, etc.) - Internal team scheduling tools - Calendly-style booking workflows --- ## Requirements - Google Calendar account - Gmail account - n8n instance (cloud or self-hosted) --- ## Key Features - Real-time availability checking - Automatic conflict detection - Calendar event creation - Alternative slot suggestions - Email notifications and confirmations - Automated reminder system (24h + 1h) - Fully customizable booking logic --- ## Summary A complete appointment scheduling system that automates booking validation, calendar management, notifications, and reminders. It reduces manual coordination, prevents scheduling conflicts, and improves attendance with automated follow-ups.

View

Need Custom Automation?

Get help designing a custom n8n workflow that connects your stack and fits your process.

Restaurant reservation management with OpenAI GPT and Google Sheets

Workflow preview

Important notice

Overview

How it works

Set up steps