Receive and follow up on appointment requests via Twilio and AI
Workflow Description
Automate SMS appointment inquiries by using OpenAI to extract appointment details, store data in Airtable, send instant confirmations via Twilio, and schedule follow-up messages based on appointment timing.
How it works
- 1.Receive incoming SMS messages through Twilio webhook trigger
- 2.Process message content using OpenAI language model to extract appointment details
- 3.Store appointment and customer information in Airtable
- 4.Send automatic confirmation message via Twilio
- 5.Schedule follow-up reminders before the scheduled appointment
Use cases
- Medical clinic or healthcare provider appointment management with automated reminders
- Consulting, tutoring, or service-based business appointment bookings via text
Requirements
- Active Twilio account with configured SMS phone number
- OpenAI API key with sufficient permissions
- Airtable base with tables for customers and appointments
- Publicly accessible webhook URL for receiving Twilio callbacks
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (36)
Twilio Trigger
Set
OpenAI Chat Model1
OpenAI
Find Follow-Up Candidates
Airtable
Send Follow Up Message
Set
Sticky Note
Sticky Note
Update Follow-Up Count and Date
Airtable
Create/Update Session
Airtable
Get Existing Chat Session
Airtable
Every 24hrs
Schedule Trigger
Send Reply
Set
Send Confirmation
Set
User Request STOP
Airtable
Check For Command Words
Switch
Structured Output Parser
Output Parser Structured
Auto-fixing Output Parser
Output Parser Autofixing
OpenAI Chat Model2
OpenAI
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note
Sticky Note6
Sticky Note
Sticky Note7
Sticky Note
Sticky Note8
Sticky Note
Sticky Note1
Sticky Note
Generate Follow Up Message
LLM Chain
Sticky Note2
Sticky Note
Sticky Note9
Sticky Note
OpenAI Chat Model3
OpenAI
Get Availability
HTTP Request
Get Existing Booking
HTTP Request
Find Existing Booking
HTTP Request
Reschedule Booking
HTTP Request
Cancel Booking
HTTP Request
Create a Booking
HTTP Request
Sticky Note10
Sticky Note
Sticky Note12
Sticky Note
Appointment Scheduling Agent1
Agent