← All templates

Operations

Appointment Reminder & No-Show Recovery

Every missed appointment is a paid hour lost twice — once for the empty slot and once for the rebooking admin. This workflow reminds the client at 24 hours and at 2 hours, and when someone still does not appear, it sends a friendly rebooking link rather than leaving the slot to die quietly.

7 stepsRequires Zapier Starter or higher15 minEasy
Google CalendarGmailTwilioGoogle SheetsDelay by Zapier

What you get

No-show rate drops with two well-timed reminders.
Missed appointments get an automatic rebooking offer.
You can see your no-show rate instead of guessing at it.

Workflow blueprint

GC
When this happens
Google CalendarNew Event Matching Search
1DE
Delay by ZapierDelay Until
2GM
GmailSend Email
3DE
Delay by ZapierDelay Until
4TW
TwilioSend SMS
5GS
Google SheetsCreate Spreadsheet Row
6GM
GmailSend Email

The full blueprint — every field mapping, example value and the written copy for each message — is included with purchase.

Getting it into Zapier

Build this one from the recipe. The blueprint gives you the exact trigger, action events and field mapping for all 7 steps, so it is a copy-and-paste job rather than a design job.

You need your own Zapier account. Zapier’s Free plan runs single-step Zaps only; multi-step Zaps need a paid plan, and Paths and Webhooks need Professional. How this works →

Not on Zapier?

n8n — import and go

An n8n workflow JSON ships with this template. Import it and all 7 steps arrive on the canvas wired in order, and 7 of the 7 nodes arrive with their fields already filled in — the subject lines, the message copy, the delays, the column names. Every step maps to a native n8n node.

What an import cannot carry is your credentials, and the IDs that only exist inside your own account — which spreadsheet, which channel, which board. Those stay in a sticky note under the node, listing what is already done so you do not retype it, and what is left so you can see it.

Make — build guide

A Make-specific guide ships with this template: every module in order, every field value, and the concept translations that catch people out — filters live on the links between modules, and the schedule lives on the scenario rather than in a trigger module.

Self-hosted n8n has no per-task fee, which is worth knowing if this workflow runs at volume. Platform coverage →

Setup steps

1
Detect the booked appointment

Configure this step using the field mapping in the blueprint.

2
Remind 24 hours before

Configure this step using the field mapping in the blueprint.

3
Remind 2 hours before by SMS

Configure this step using the field mapping in the blueprint.

4
Log the appointment outcome

Configure this step using the field mapping in the blueprint.

5
Send the rebooking offer on a no-show

Configure this step using the field mapping in the blueprint.

Implementation notes

  • Two reminders outperform one by a wide margin, and three annoy people. Stop at two.
  • The no-show email should carry zero blame. Its only job is to make rebooking effortless.
  • Mark the Outcome column after each appointment; the no-show step reads from it.