AI Restaurant Booking Agent (n8n + Gemini)

Overview

This project is an AI-powered restaurant table booking assistant built with n8n.

Customers can chat with the bot to book a table, and the system automatically:

• extracts booking details
• checks for time conflicts
• saves bookings to Google Sheets
• confirms the reservation

Tech Stack

• n8n workflow automation
• Google Gemini LLM
• Google Sheets
• AI Agent node
• Memory buffer

Features

• Natural language booking requests
• Automatic extraction of:
  • customer name
  • date
  • time
  • number of guests
• Prevents double bookings
• Chat-based interface

Workflow Architecture

Chat Trigger
↓
AI Agent (Gemini)
↓
Memory Buffer
↓
Read Bookings Tool (Google Sheets)
↓
Conflict Detection
↓
Add Booking Tool (Google Sheets)

Example Interaction

User:

Hi I'd like to book a table tomorrow at 7pm for 3 people under Sarah

Bot:

Your table for 3 on May 12 at 7pm has been successfully booked.

Import into n8n

1. Download workflow.json
2. Open n8n
3. Import workflow
4. Connect your own:
   • Gemini API
   • Google Sheets credentials

Notes

Credentials and IDs have been removed for security.