🤖📞 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.
Setup 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).
-
Deployment :
- 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 .