Restaurant reservation management with OpenAI GPT and Google Sheets


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.