๐ฌ Restaurant reservation management with OpenAI GPT and Google Sheets
โก 3,279 views ยท ๐ฌ Support Chatbots
Description
image.png
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.
๐ Nodes Used
AI Agent, OpenAI Chat Model, Simple Memory, Calculator, Chat Trigger
๐ฅ Import
Download workflow.json and import into n8n:
Workflow menu โ Import from File