1
Check Availability
The workflow receives the requested date, checks Google Calendar, and either confirms the requested time or formats available alternatives for Vapi.
AI Automation Case Study
AI Receptionist and Appointment Scheduler
A voice driven scheduling system that checks real time availability, books appointments, manages changes, records call results, and keeps Google Calendar and Airtable synchronized through n8n.
Project Overview
Vapi handles the caller conversation while n8n performs the scheduling work. Structured webhook requests connect the voice assistant to calendar availability, booking, rescheduling, cancellation, and call record workflows.
Business Challenge
- Missed calls can become missed booking opportunities.
- Availability checks create scheduling back and forth.
- Manual appointment changes can cause inconsistent records.
- Call details require separate follow up documentation.
Automated Solution
- Checks open calendar times during the call.
- Creates appointments and client records after validation.
- Updates or cancels the original event and Airtable record.
- Stores call results for operational follow up.
Immediate Assistance
Callers can handle scheduling during the conversation
Real Time Availability
Calendar slots are checked before booking
Complete Lifecycle
Book, update, cancel, and record results
Project Walkthrough
Watch the AI receptionist check real time availability, book an appointment, update or cancel a schedule, and save the final call result through one connected workflow.
How the Process Works
Five workflow tools support the appointment lifecycle. Every request validates the input and returns a structured response to the voice assistant.
2
Book Appointment
Required caller information is validated, the time is converted to the configured time zone, a Google Calendar event is created, and confirmed bookings are stored in Airtable.
3
Update Appointment
The workflow locates the original Airtable appointment, updates the connected calendar event and record, then returns the result and call identifier to Vapi.
4
Cancel Appointment
The original record is located, the calendar event is deleted, Airtable is marked as cancelled, and Vapi receives a success or friendly error response.
5
Record Call Results
At the end of the interaction, structured call arguments are captured and a call record is created or updated in Airtable for follow up and reporting.
Project Visuals
The overview explains the complete appointment lifecycle while the workflow image shows all five n8n tools.
Solution Overview
Full n8n Workflow
Important Automation Logic
Required Information Validation
Booking, update, and cancellation requests are checked before
calendar actions run.
Availability Protection
The requested time is checked before an event is created.
Time Zone Handling
Appointment values are converted to the configured America
Chicago time zone.
Structured Webhook Responses
Success, alternatives, and friendly errors return in a format
Vapi can use.
Calendar and Record Sync
Google Calendar events and Airtable appointment records stay
aligned.
Call Tracking
Call identifiers and results are stored for follow up and
reporting.
Technology and Integrations
| Tool | Role in the Solution |
|---|---|
| Vapi | Runs the voice conversation and calls the scheduling tools. |
| n8n | Validates inputs, runs scheduling logic, and returns webhook responses. |
| Google Calendar | Provides availability and stores appointment events. |
| Airtable | Stores appointment, client, status, and call result records. |
| Webhooks | Connect Vapi tool calls with each n8n scheduling workflow. |
Production Considerations
Before production use, the assistant should be tested for scheduling accuracy, privacy, reliability, and platform requirements.
Credentials and OAuth
Protect Vapi, Google Calendar, Airtable, and n8n credentials.
Protect Vapi, Google Calendar, Airtable, and n8n credentials.
Time Zone Testing
Validate daylight saving changes and caller date interpretation.
Validate daylight saving changes and caller date interpretation.
Double Booking Prevention
Recheck availability immediately before creating an event.
Recheck availability immediately before creating an event.
Idempotency
Prevent repeated webhook calls from creating duplicate records.
Prevent repeated webhook calls from creating duplicate records.
Privacy and Retention
Limit stored caller information and define record retention rules.
Limit stored caller information and define record retention rules.
Error Monitoring
Track failed tool calls, calendar errors, and incomplete Airtable updates.
Track failed tool calls, calendar errors, and incomplete Airtable updates.
Explore the Project
View the project visuals or return to the AI Automation portfolio.