How to Automatically Send Appointment Reminders to Clients

The No-Show Problem Is Costing You More Than You Think

A physio clinic with 20 appointments per week. Average no-show rate: 12%. That's 2.4 appointments per week gone. At $120 per session, that's $288 per week, $14,976 per year, just from people who forgot.

The math is the same for trades businesses. A plumber with 8 jobs scheduled on a Tuesday loses 3 hours of billable time when two customers don't answer the door. A dental practice loses $200 per empty chair. A personal trainer loses $80 per ghost.

None of these businesses have a demand problem. They have a communication problem. Clients book weeks in advance, life gets in the way, and without a reminder, they simply forget.

The average no-show rate for service businesses without automated reminders is 15-20%. With automated reminders, it drops to 3-5%.

The solution is not hiring a receptionist to call every client manually. It's building an automated system that fires reminders at the right time without you touching it.

Why Most Reminder Software Is Overkill

The default advice is "just use Acuity" or "just use Calendly Pro" or "get a practice management system." Those tools cost $40-150/month, come with features you'll never use, and often lock your appointment data inside a proprietary system.

If you already use these tools, great — turn on the reminder feature and you're done. But most small businesses use something simpler: a shared Google Calendar, a paper diary, a basic booking form, or a spreadsheet handed to a receptionist each morning.

For those businesses, the options are:

• Pay $50-150/month for a reminder platform
• Have a staff member manually call or text clients each day
• Build a lightweight automation using tools you already have

Option three costs less than $10/month and takes about 3 days to set up properly. Here's how it works.

The Architecture: What a Good Reminder System Looks Like

Before building anything, understand what you're actually trying to do. A complete appointment reminder system has three components:

1. The Data Source

Where do your appointments live? This is the foundation. Common sources include:

• Google Calendar — most common for small businesses, has a free API
• Notion database — increasingly popular for operations-forward businesses
• Airtable or Google Sheets — used by trades businesses with a basic CRM
• Booking forms (Typeform, Tally, JotForm) — feeds into a spreadsheet or CRM

The system needs to read upcoming appointments, extract the client's name, phone number, email, appointment time, and appointment type. If your current system doesn't store client contact details alongside appointments, fix that first.

2. The Trigger Logic

When should reminders go out? Research consistently shows that two reminders outperform one:

• 48 hours before — gives clients enough time to reschedule if needed
• 2 hours before — the "this is today" reminder that captures last-minute forgetting

Some businesses add a third: a confirmation request 1 week out, where clients confirm or cancel. This is most useful for high-value appointments (specialist medical, major trades jobs) where a cancellation needs enough lead time to fill the slot.

3. The Delivery Channel

SMS gets opened. Email gets ignored. If you have phone numbers, use SMS as your primary channel. Use email as a backup or for longer confirmations with calendar attachments.

SMS open rates are above 90% within 3 minutes of delivery. Email open rates for transactional messages hover around 40-60%. For appointment reminders, that gap matters.

Building It: Three Approaches Ranked by Complexity

Approach 1 — Zapier or Make (No Code, Quick Start)

If your appointments are in Google Calendar, Calendly, or a booking form that connects to Zapier, you can build a basic reminder workflow in an afternoon.

The flow looks like this:

1. New appointment added to Google Calendar
2. Zapier creates a delayed trigger: 48 hours before the event start time
3. Zapier sends an SMS via Twilio or MessageBird with the appointment details
4. A second trigger fires 2 hours before for the day-of reminder

Cost: Zapier Starter ($20/month) plus Twilio SMS (~$0.07 per message in Australia). For 100 reminders per month that's roughly $27/month total.

Limitation: Zapier's delay steps on the Starter plan have a maximum delay of 15 minutes. For 48-hour delays you need the Professional plan ($49/month) or you schedule via a different method. Make (formerly Integromat) handles delays better and costs less.

Approach 2 — Google Apps Script (Free, More Control)

If your appointments are in Google Calendar and you want zero ongoing cost, Google Apps Script runs directly against your Google Workspace data for free.

The script runs on a time-based trigger (every hour, for example), queries Calendar for appointments happening in 48 hours and 2 hours, checks a log to avoid duplicate sends, and fires SMS via Twilio's API.

This approach requires basic JavaScript knowledge. The script is about 80 lines. The Twilio SMS cost remains the same ($0.07/message) but there's no monthly platform fee.

Here's the core logic in plain terms:

• Every 60 minutes, fetch all calendar events in the next 49 hours
• Filter for events starting between 47 and 49 hours from now
• Check a Google Sheet "sent log" to see if a 48hr reminder was already sent
• If not sent, extract the client phone from the event description or a linked Sheet row, send SMS, log it
• Repeat the same logic for the 2-hour window

This is reliable, free to run, and fully auditable. The downside: if you change how you store phone numbers or appointment data, you need to update the script.

Approach 3 — Custom AI Automation (Most Flexible)

For businesses with mixed appointment sources (some in a CRM, some in a calendar, some coming in via email), a custom automation handles the complexity that off-the-shelf tools can't.

A custom system can:

• Ingest appointments from multiple sources and normalise them into one format
• Parse unstructured appointment confirmations (emails, WhatsApp messages) using AI to extract date, time, and client details
• Personalise reminder messages based on appointment type ("don't forget to fast for 4 hours before your blood draw" vs "bring your plumbing access certificate")
• Handle two-way confirmation: client replies "YES" to confirm or "CANCEL" to cancel, and your calendar updates automatically
• Escalate to a staff member if a cancellation comes in with less than 2 hours notice

This is what ThreeDayAI builds for clients: a system scoped to your exact appointment workflow, deployed in 3 days, for $4,999 affiliate pricing.

SMS vs Email: What to Send and When

Template matters. A reminder that feels robotic gets ignored. A reminder that feels personal gets a response.

48-Hour SMS (Keep It Short)

"Hi [Name], just a reminder you have a [type] appointment with [business] on [Day] at [Time] at [Address]. Reply CONFIRM to confirm or CANCEL to cancel. Questions? Call [phone]."

Under 160 characters if possible. One action. Clear next step.

2-Hour SMS (Even Shorter)

"Reminder: your [type] appointment is today at [Time] at [Address]. See you soon."

No call to action needed. Just a nudge. If they need to cancel at this point, they'll call.

Email Confirmation (48 Hours Out)

Send alongside the SMS. Include:

• Appointment date, time, location with a Google Maps link
• What to bring or prepare (personalised by appointment type)
• Cancellation/reschedule instructions and a deadline ("please give us 24 hours notice")
• Your contact number

Add a calendar attachment (.ics file) so clients can add it directly to their phone calendar. This is a one-line addition in most automation tools and meaningfully reduces no-shows on its own.

Handling Confirmations and Cancellations

If you're sending SMS reminders, you should handle replies. Clients will respond. Without a handler, those replies go nowhere and you miss the signal.

A two-way SMS system works like this:

1. Client replies "YES" or "CONFIRM" — automation updates calendar event to "Confirmed", logs in CRM
2. Client replies "CANCEL" — automation marks event as cancelled, sends a rescheduling link, notifies staff if within 24 hours
3. Client replies anything else — automation routes to a staff member's phone or email for manual handling

Twilio handles inbound SMS routing out of the box. You set a webhook URL and your automation responds to incoming messages. Most businesses set this up once and never touch it again.

What to Measure

Once the system is running, track these numbers weekly:

• No-show rate — appointments attended vs total scheduled. Target under 5%.
• Confirmation rate — what percentage of clients confirm via SMS reply. Higher is better; it tells you the reminder arrived and was read.
• Cancellation notice time — how many hours before the appointment do cancellations come in. The goal is to push the average later so you have time to fill the slot.
• Revenue recovered — multiply your average appointment value by the reduction in no-shows. This is the number to report to yourself monthly.

A physio clinic that drops from 12% no-shows to 4% is recovering roughly 8 appointments per 100 scheduled. At $120 per appointment, that's $960 recovered per 100 appointments. For a busy practice doing 400 appointments per month, that's $3,840/month in recovered revenue from one automated workflow.

Build vs Buy: The Honest Comparison

Here's the breakdown for a service business running 50-200 appointments per month:

Off-the-shelf reminder software

• Cost: $40-150/month ongoing
• Setup: hours to days depending on how well it fits your workflow
• Flexibility: limited to what the platform supports
• Data: locked into their system

Zapier + Twilio

• Cost: $20-50/month ongoing
• Setup: half a day to a full day for someone comfortable with no-code tools
• Flexibility: moderate — works well if your data is already in a Zapier-connected tool
• Data: stays in your existing systems

Google Apps Script + Twilio

• Cost: ~$7-15/month for SMS (Twilio only, no platform fee)
• Setup: 1-2 days if you're comfortable with JavaScript
• Flexibility: high — you own the logic, you can change anything
• Data: stays in Google Workspace

Custom automation (ThreeDayAI)

• Cost: $4,999 one-time, then ~$10-15/month for SMS infrastructure
• Setup: 3 business days, scoped to your exact workflow
• Flexibility: built for your systems, not the other way around
• Data: stays in your systems, you own the code

For most businesses, the breakeven on custom automation vs $50/month software is around 3-4 years. But the calculation changes when you factor in staff time. If a receptionist spends 2 hours per week calling clients to confirm, that's roughly $5,200/year in labour cost at $50/hour. Automating it pays for itself in under 6 months.

The Steps to Get Started Today

If you want to build this yourself:

1. Audit your appointment data — where are appointments stored? Do client phone numbers and emails live alongside each appointment?
2. Sign up for Twilio — get a local Australian phone number ($1/month) and load $20 credit. That covers ~280 SMS messages.
3. Pick your automation layer — Zapier if you want no code, Google Apps Script if you want free and flexible.
4. Build the 48-hour trigger first — get that working and sending real test messages before building the 2-hour trigger.
5. Add the sent log — a simple Google Sheet or database table that prevents duplicate sends. This is the step most people skip and then regret.
6. Test with your own number — schedule a test appointment and verify you receive both reminders at the right time.
7. Monitor for one week — check the sent log daily to confirm everything fired correctly.

If you'd rather have it built properly and done in 3 days:

That's what ThreeDayAI does. We scope the automation for your specific setup, handle the Twilio configuration, build the send logic, test it against real appointment data, and hand you a system that runs itself. Flat fee, no monthly platform cost beyond SMS infrastructure.