See llms.txt for all machine-readable content.

Back to Templates

Send clinic appointment reminders from Google Calendar with WhatsApp and Gmail

Quick overview

This workflow checks Google Calendar appointments and sends WhatsApp template reminders to patients the day before and again 2 hours before, then emails your clinic team a summary of sent and failed reminders via Gmail.

How it works

  1. Runs on two schedules: daily at 10:00 to process tomorrow’s appointments and hourly from 07:00–19:00 to process appointments starting 2–3 hours ahead.
  2. Calculates the time window for the current run and fetches matching events from Google Calendar.
  3. Extracts the patient name and mobile number from each event description, skips cancelled/all-day events and opted-out patients, and formats the phone number for WhatsApp.
  4. Sends the appropriate WhatsApp template message (day-before or 2-hour) to each valid patient and records whether the message was sent or failed.
  5. Compiles a run summary (always for day-before runs, and only on failures for 2-hour runs) and emails it to the clinic team using Gmail.

Setup

  1. Connect your Google Calendar, WhatsApp and Gmail credentials. Choose your calendar in Get appointments and your phone number in both WhatsApp nodes. Using a permanent System User token? Give it access to both your WhatsApp account and your Messaging account.
  2. In WhatsApp Manager, create and get approval for the Utility templates appointment_reminder_day_before and appointment_reminder_2h (en_GB) with a “Reschedule” button.
  3. Ensure each appointment description includes lines for the patient, such as Name: … and Mobile: … (and optionally WhatsApp: no to opt out).
  4. In Settings, enter your clinic name, country code (44 for the UK, 353 for Ireland), time zone and the team email that should get the summaries. Set the workflow time zone to match, then publish.

Requirements

  • Google Calendar with the patient's name and mobile in each appointment's description
  • WhatsApp Business Platform (Cloud API) number with two approved Utility templates
  • Gmail account to send the team summaries

Customization

  • Change the reminder times in the two trigger nodes
  • Add WhatsApp: no to an appointment's description to skip that patient
  • Swap Gmail for Slack or Microsoft Teams