Introduction
No-shows cost businesses 10-30% of revenue. A salon with 20 appointments/day and a 20% no-show rate loses 4 appointments/day — that’s 20 hours of wasted time per week.
Automated appointment reminders reduce no-shows by 40-60%. This post shows you how to set them up.
The reminder sequence
| When | Channel | Message | Purpose |
|---|---|---|---|
| At booking | Email/SMS | “Your appointment is confirmed for [date/time]” | Confirmation |
| 24 hours before | SMS/WhatsApp | “Reminder: Your appointment is tomorrow at [time]. Reply C to confirm or R to reschedule.” | Reminder + confirmation |
| 2 hours before | SMS/WhatsApp | “Your appointment is in 2 hours at [location]. See you soon!” | Final reminder |
| 1 hour after (if no-show) | SMS/WhatsApp | “We missed you today. Would you like to reschedule?” | Re-engagement |
Step 1: Set up with Google Calendar + Zapier (no-code)
Setup
- Create appointments in Google Calendar (with customer phone in the description)
- Connect Zapier: Google Calendar → New Event → Twilio → Send SMS
Zapier workflow
Trigger: New event in Google Calendar
↓
Delay: 24 hours before event
↓
Action: Send SMS via Twilio
Message: "Hi [name], reminder: your appointment is tomorrow at [time] at [location]. Reply C to confirm."
To: [phone from event description]
Cost: Zapier free tier (100 tasks/month) + Twilio ($0.0075/SMS)
Step 2: Set up with Python (full control)
import os
from datetime import datetime, timedelta
import requests
# Twilio for SMS
from twilio.rest import Client
twilio_client = Client(os.environ["TWILIO_SID"], os.environ["TWILIO_TOKEN"])
# WATI for WhatsApp
WATI_API_KEY = os.environ["WATI_API_KEY"]
def send_sms(phone, message):
twilio_client.messages.create(body=message, from_="+1234567890", to=phone)
def send_whatsapp(phone, message):
url = "https://live-server-XXXX.wati.io/api/v1/sendSessionMessage"
requests.post(url, json={"whatsappNumber": phone, "messageText": message},
headers={"Authorization": f"Bearer {WATI_API_KEY}"})
def send_reminders():
appointments = get_upcoming_appointments() # from your DB/Google Calendar
for appt in appointments:
appt_time = datetime.fromisoformat(appt["datetime"])
now = datetime.now()
hours_until = (appt_time - now).total_seconds() / 3600
customer = appt["customer"]
# 24-hour reminder
if 23 <= hours_until <= 25:
msg = f"Hi {customer['name']}, reminder: your appointment is tomorrow at {appt_time.strftime('%I:%M %p')} at {appt['location']}. Reply C to confirm or R to reschedule."
send_whatsapp(customer["phone"], msg)
print(f"24h reminder sent to {customer['name']}")
# 2-hour reminder
elif 1.5 <= hours_until <= 2.5:
msg = f"Hi {customer['name']}, your appointment is in 2 hours at {appt['location']}. See you soon!"
send_whatsapp(customer["phone"], msg)
print(f"2h reminder sent to {customer['name']}")
# Run every 30 minutes via cron
send_reminders()
Step 3: Handle confirmations
def handle_reply(phone, message):
"""Process customer reply to reminder."""
msg = message.strip().upper()
if msg == "C":
# Confirmed
update_appointment_status(phone, "confirmed")
send_whatsapp(phone, "Great! Your appointment is confirmed. See you soon!")
elif msg == "R":
# Reschedule
send_whatsapp(phone, "No problem! Please let us know your preferred date/time and we'll reschedule.")
update_appointment_status(phone, "reschedule_requested")
elif msg == "CANCEL":
# Cancel
update_appointment_status(phone, "cancelled")
send_whatsapp(phone, "Your appointment has been cancelled. We hope to see you soon!")
else:
send_whatsapp(phone, "Reply C to confirm, R to reschedule, or CANCEL to cancel.")
Step 4: Google Calendar integration
from googleapiclient.discovery import build
from google.oauth2 import service_account
creds = service_account.Credentials.from_service_account_file("service_account.json")
service = build("calendar", "v3", credentials=creds)
def get_upcoming_appointments():
"""Fetch appointments from Google Calendar."""
now = datetime.utcnow().isoformat() + "Z"
events = service.events().list(
calendarId="primary",
timeMin=now,
maxResults=50,
singleEvents=True,
orderBy="startTime",
).execute()
appointments = []
for event in events.get("items", []):
# Extract customer info from event description
# Format: "Customer: John Doe | Phone: +91 98765 43210 | Service: Haircut"
desc = event.get("description", "")
appointments.append({
"id": event["id"],
"title": event["summary"],
"datetime": event["start"]["dateTime"],
"location": event.get("location", ""),
"customer": parse_customer(desc),
})
return appointments
Step 5: No-show follow-up
def handle_no_shows():
"""Follow up with customers who didn't show up."""
appointments = get_past_appointments(hours_ago=2)
for appt in appointments:
if appt["status"] != "attended":
customer = appt["customer"]
send_whatsapp(customer["phone"],
f"Hi {customer['name']}, we missed you today. "
f"Would you like to reschedule? Reply with your preferred date/time.")
update_appointment_status(appt["id"], "no_show")
Best practices
Timing
- 24-hour reminder: Most effective. Gives customers time to reschedule.
- 2-hour reminder: Catches last-minute forgetfulness.
- Don’t over-remind: 2 reminders max. More = annoying.
Channel
- WhatsApp: Highest open rate (98%), best for India
- SMS: Good for non-WhatsApp users, higher cost
- Email: Lowest open rate (20%), but free
- Phone call: For high-value appointments only
Content
- Include: date, time, location, service
- Include: confirmation/reschedule/cancel options
- Keep it short: under 160 characters for SMS
- Personalize: use customer’s name
Common mistakes
- No confirmation option — “Reply C to confirm” increases show-up rate by 20%
- Too many reminders — 3+ reminders annoy customers
- Wrong timing — 24-hour reminder at 3 AM is useless. Send during business hours.
- No reschedule option — if they can’t make it, let them reschedule easily
- Not tracking no-shows — if someone no-shows 3 times, stop booking them
Key Concepts
- Appointment reminder = automated message before an appointment
- No-show rate = % of appointments where customer doesn’t show up
- Confirmation = customer acknowledges they’ll attend
- Reschedule = moving appointment to a new time
- Cron job = scheduled task that runs automatically
What to Try Next
- Automate customer follow-ups after a service
- Set up an auto-booking system for self-service
- Set up WhatsApp Business for messaging
- Build an appointment dashboard in Streamlit
FAQ
How much do appointment reminders reduce no-shows?
Studies show 40-60% reduction in no-shows with automated reminders. SMS/WhatsApp reminders are most effective (98% open rate vs 20% for email).
Should I use SMS or WhatsApp?
WhatsApp for India (98% open rate, free for service conversations). SMS for countries where WhatsApp isn’t dominant. Email as a backup. See Set Up WhatsApp Business.
What if a customer replies with something other than C/R/CANCEL?
Handle it gracefully: “I didn’t understand that. Reply C to confirm, R to reschedule, or CANCEL to cancel.” Or use an AI to parse the response (see Automate Google Review Replies).
Can I automate appointment booking too?
Yes — see Auto-Booking System for Service Business. Combine booking + reminders for a fully automated system. See Automate Customer Follow-Ups.