n8n

How to Automate Twilio SMS Appointment Scheduling?

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.

What are the key features?

  • 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 do you set it up?

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. In n8n, create an Airtable Personal Access Token credential and select your base and table in the Airtable nodes for search and update.
  7. 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.
  8. 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.
  9. Open the Check For Command Words node and confirm STOP routes to the Airtable update and then to the Send Confirmation SMS node.
  10. Review the Schedule Trigger set to every 24 hours. Adjust the timing to match your timezone and preferred follow up window.
  11. 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.
  12. 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.
  13. 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.
  14. 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.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Airtable

Sign up

Free (1,000 API calls / mo)

Cal.com

Sign up

Starter (Platform): Free; includes Platform APIs; up to 25 bookings / mo; $0.99 per overage

OpenAI

Sign up

Pay-as-you-go: GPT-5 at $1.25 per 1M input tokens and $10 per 1M output tokens

Twilio

Sign up

Pay-as-you-go: starts at $0.0083 per SMS segment (US); US phone numbers from $1.15 / mo (+ carrier fees).

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.