How to Automate Twilio SMS Appointment Scheduling?
Description
Turn incoming SMS leads into booked appointments and smart follow ups. Ideal for service teams that schedule repairs, demos, or consultations by text and want a simple way to capture chats, book time slots, and re engage quiet leads. The goal is faster responses, fewer missed leads, and clear opt out handling.
When a text arrives, the system checks for command words like STOP. If STOP is found, it updates the record in Airtable and sends a confirmation, which prevents future follow ups. If not, it pulls the chat session from Airtable and passes the history to an AI scheduling agent. The agent can check availability, book, reschedule, or cancel through Cal.com. The reply goes back to the customer by SMS and Airtable is updated with the booking status. A daily schedule looks for people who did not book, have not opted out, and have not been messaged in 3 days. An LLM writes a polite follow up, sends it by SMS, and increases the follow up count.
Setup needs Twilio, Airtable, OpenAI, and Cal.com credentials. Expect faster replies, fewer manual tasks, and better tracking. Great for repair shops, clinics, and agencies that rely on SMS to close appointments and want to run follow ups without spam.
Tools Required
What this workflow does?
- Twilio inbound SMS trigger receives messages and sends replies using your service number.
- Command word check routes STOP requests to an Airtable update and sends a confirmation SMS.
- Airtable session search and update keeps chat history, booking status, follow up count, and last follow up date.
- AI scheduling agent uses OpenAI and Cal.com tools to check availability, create bookings, reschedule, and cancel.
- Structured output parser and auto fixing ensure the agent returns reliable, machine readable results.
- Daily scheduler finds follow up candidates with an Airtable formula that respects opt outs and timing rules.
- LLM generates a friendly follow up message using the stored conversation context.
- Follow up counter and timestamp updates stop spam by limiting to three messages and spacing by three days.
What are the benefits?
- Reduce manual follow up work from 60 minutes a day to 5 minutes by automating outreach and reminders.
- Automate up to 80% of appointment replies with an AI agent that can book, reschedule, or cancel.
- Improve data quality by 90% by storing each step in Airtable with clear session IDs and timestamps.
- Handle up to 5 times more SMS inquiries without adding staff by eliminating back and forth.
- Connect Twilio, Airtable, OpenAI and Cal.com in one flow so all messages and bookings stay in sync.
- Cut opt out risk with clear STOP handling and daily follow ups capped at three messages.
How to set this up?
- Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
- You'll need accounts with Twilio, Airtable, OpenAI and Cal.com. See the Tools Required section above for links to create accounts with these services.
- In the n8n credentials manager, create Twilio credentials using your Account SID and Auth Token. Assign them to the Twilio Trigger and all Twilio Send nodes.
- In your Twilio console, set the Messaging webhook for your phone number to the Twilio Trigger endpoint shown in n8n. Use the production URL when ready and send a test SMS to confirm it reaches n8n.
- Prepare an Airtable base and a table for leads. Include fields like session_id, status, followup_count, last_followup_at, appointment_id, scheduled_at, twilio_service_number, and chat_history. Adjust field names in the Airtable nodes if yours differ.
- In n8n, create an Airtable Personal Access Token credential and select your base and table in the Airtable nodes for search and update.
- Create an OpenAI API key in your OpenAI account. In n8n, add the OpenAI credential and select it in all OpenAI Chat Model and LLM nodes. Choose your preferred model.
- Create a Cal.com API key. In n8n, add the Cal.com or HTTP Header Auth credentials used by the Cal.com nodes. Confirm event type IDs and endpoints for availability, create, reschedule, and cancel actions.
- Open the Check For Command Words node and confirm STOP routes to the Airtable update and then to the Send Confirmation SMS node.
- Review the Schedule Trigger set to every 24 hours. Adjust the timing to match your timezone and preferred follow up window.
- Run a live test: send an SMS to your Twilio number. Verify a session record is created in Airtable, an AI reply is sent, and any booking details are stored.
- Test STOP by replying with STOP. Confirm the status updates in Airtable and that a confirmation SMS is delivered. Check that the lead no longer appears in follow up searches.
- Seed a test lead in Airtable that meets the follow up filter. Manually execute the scheduled path to verify the follow up message is generated and the followup_count and last_followup_at fields update.
- Troubleshoot: if SMS fails, verify Twilio webhook URL and From number. If bookings fail, check Cal.com API key and event type IDs. If follow ups do not send, review Airtable filterByFormula and field names.
Need help or want to customize this?
Ask in the Futurise Pro Community.
Similar Templates
These templates were sourced from publicly available materials across the web, including n8n’s official website, YouTube and public GitHub repositories. We have consolidated and categorized them for easy search and filtering, and supplemented them with links to integrations, step-by-step setup instructions, and personalized support in the Futurise community. Content in this library is provided for education, evaluation and internal use. Users are responsible for checking and complying with the license terms with the author of the templates before commercial use or redistribution.Where an original author was identified, attribution has been provided. Some templates did not include author information. If you know who created this template, please let us know so we can add the appropriate credit and reference link. If you are the author and would like this template removed from the library, email us at info@futurise.com and we will remove it promptly.
