Tech With Galvan
Back to Articles
AutomationApr 1, 2029 • 5 min read

How to Automate Appointment Reminders

Automate appointment reminders via SMS, WhatsApp, and email — reduce no-shows by 40%+. With Python code and no-code tools.

Galvan
Galvan

Founder & Creator

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

  1. Create appointments in Google Calendar (with customer phone in the description)
  2. 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

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.