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

This n8n workflow automates the process of sending AI-powered reservation reminder calls to restaurant customers. It reads reservation data from a Google Sheet, processes each reservation, and uses an AI agent to generate and make personalized reminder calls via Twilio.

What it does

1. Triggers Manually or on Schedule: The workflow can be initiated manually or set to run on a recurring schedule (e.g., daily) to check for upcoming reservations.
2. Reads Reservations from Google Sheets: It fetches a list of reservations from a specified Google Sheet.
3. Loops Through Reservations: Each reservation entry from the Google Sheet is processed individually.
4. Generates AI-Powered Call Script: For each reservation, an AI Agent (powered by an OpenRouter Chat Model like Grok-4) is used to generate a personalized and engaging call script for the reminder.
5. Makes Reminder Calls via Twilio: The generated script is then used to make an automated voice call to the customer's phone number using Twilio, delivering the reservation reminder.
6. Waits Between Calls: A short delay is introduced between each call to avoid overwhelming the Twilio service or the recipients.

Prerequisites/Requirements

• n8n Instance: A running instance of n8n.
• Google Sheets Account: With a spreadsheet containing your restaurant reservation data (e.g., customer name, phone number, reservation date/time).
• Twilio Account: With a Twilio phone number capable of making outbound calls.
• OpenRouter Account: An OpenRouter API key configured with access to a suitable chat model (e.g., Grok-4 or another capable LLM) for the AI Agent.

Setup/Usage

1. Import the Workflow:
   • Copy the provided JSON code.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the "Import from JSON" button and paste the copied JSON.
2. Configure Credentials:
   • Google Sheets: Set up a Google Sheets credential. You will need to authenticate with your Google account and grant n8n access to your spreadsheets.
   • Twilio: Set up a Twilio credential, providing your Account SID and Auth Token.
   • OpenRouter Chat Model: Configure an OpenRouter credential with your API key.
3. Customize Nodes:
   • Google Sheets Node:
     • Specify the "Spreadsheet ID" and "Sheet Name" where your reservation data is stored.
     • Ensure the column headers in your sheet match the data expected by the AI Agent (e.g., customerName, phoneNumber, reservationTime, restaurantName).
   • AI Agent Node:
     • Review and adjust the prompt for the AI Agent to ensure it generates appropriate and helpful reservation reminder scripts.
     • Ensure the "OpenRouter Chat Model" node is correctly linked and configured with the desired model (e.g., Grok-4).
   • Twilio Node:
     • Set the "From" phone number to your Twilio phone number.
     • Map the "To" phone number to the relevant field from your Google Sheet data (e.g., {{ $json.phoneNumber }}).
     • Map the "Message" field to the output of the AI Agent (the generated call script).
   • Wait Node: Adjust the "Delay" value as needed to control the interval between calls.
   • Schedule Trigger (Optional): If you want the workflow to run automatically, configure the "Schedule Trigger" node with your desired frequency (e.g., daily at a specific time).
4. Activate the Workflow: Once configured, activate the workflow. You can test it by clicking "Execute Workflow" on the "Manual Trigger" node.