Table Booking Bot.json

This Table Booking Bot is an AI-driven conversational agent designed to manage restaurant reservations for "Daily Bean" through a chat interface.

1. Customer Interaction

• Trigger: The workflow starts when a customer sends a message through the n8n Chat Trigger.
• Welcome Message: The bot introduces itself and asks the customer for their name, date, time, and the number of people joining.
• Session Management: A Set Node captures the unique chatId to maintain a consistent conversation session.

2. AI Intelligence & Memory

• Core Engine: An AI Agent powered by the Google Gemini Chat Model processes the customer's natural language input.
• Memory: The bot uses a Simple Memory (Buffer Window) node to remember previous parts of the conversation, allowing it to collect missing information over multiple messages.

3. Booking Management (Google Sheets)

The AI agent has access to two specialized tools to manage a Google Sheet titled "Table Booking Bot":

• Availability Check: Using the Read Bookings Tool, the AI scans the current spreadsheet to check for existing reservations and prevent double bookings.
• Reservation Logging: Once availability is confirmed and all details are collected, the agent uses the Append row tool to save the Name, Date, Time, and number of people to the sheet.