AI-Powered Reservation Reminder Calls for Restaurant with Twilio & Grok-4

Description

🤖📞 This workflow automates the process of calling customers to remind them of their booking reservations using AI-generated messages and a Twilio phone number. It can easily be adapted for other venues.

Key Benefits

Time-Saving Automation**: Eliminates the need for manual calls by staff, saving hours per week.
Human-like AI Messages**: Uses a custom language model to generate polite, natural phone messages tailored to each customer.
Multi-Channel Integration**:

Google Sheets for reservation tracking.
Twilio for automated calling.
OpenRouter (or other LLMs) for generating speech content.
Error Reduction**: Ensures all customers receive reminders exactly on the reservation day, minimizing no-shows.
Scalable**: Easily adapts to growing reservation lists and more complex message logic.
Suitable** for restaurants, hairdressers, offices and any other business

How It Works
Trigger:
The workflow can be triggered manually (via "When clicking ‘Execute workflow’) or automatically at 11 AM daily (via Schedule Trigger).
Data Fetch:
Retrieves today’s reservations from a Google Sheet, filtering rows where DATE = today and CALLED is empty.
AI-Generated Call Script:
For each reservation, the Secretary Agent (powered by OpenRouter’s Grok-4) generates a phone script using the guest’s name, time, and party size.
Twilio Call:
The script is sent to Twilio, which calls the guest’s phone number (from the sheet) and reads the message aloud using text-to-speech.
Update & Loop:
Marks the reservation as called (CALLED = "x") in the sheet and waits 2 minutes between calls to avoid rate limits.

Set Up Steps
Twilio Configuration:
Sign up for Twilio, buy a phone number, and:
Enable text-to-speech (set language to Italian).
Configure geo permissions for the target country.
Add credentials to the Twilio node (sender number in From field).
Google Sheets Setup:
Clone the Google Sheet template and ensure:
Phone numbers include the international prefix (without "+").
Columns: DATE, TIME, NAME, N. PEOPLE, PHONE, CALLED.
OpenRouter API:
Connect the OpenRouter Chat Model node to your account (using Grok-4 or another model).
Deploy:
Activate the workflow and test with manual execution.

Note: The workflow is currently inactive (active: false). Enable it after setup.

Need help customizing?
Contact me for consulting and support or add me on Linkedin.