P
AI for Case Manager

Automation: Appointment Reminder Workflow with Zapier

Tools:Zapier, Google Calendar, Gmail
Time to build:1-2 hours
Difficulty:Intermediate-Advanced
Prerequisites:Comfortable with Google Calendar and Gmail; basic understanding of spreadsheets. No coding required.
Zapier

What This Builds

You'll create an automated workflow that sends appointment reminder emails to clients 48 hours and 24 hours before their scheduled appointment, without you composing and sending each reminder manually. When you add an appointment to Google Calendar (or a shared spreadsheet), Zapier sends the reminders automatically. This reduces no-show rates and eliminates 20–30 minutes of daily reminder-sending from your workload.

Prerequisites

  • Free Zapier account at zapier.com (free plan supports this workflow)
  • Google account with Google Calendar and Gmail
  • Clients' email addresses accessible in a spreadsheet or contact list
  • Understand that automated emails cannot contain PHI. Reminders must be generic enough to be safe to send via unencrypted email.

The Concept

Zapier watches your calendar like a very attentive assistant. When it sees an appointment scheduled for 2 days from now, it automatically sends a reminder email to the client's address. You set up the rule once, and it runs in the background forever. It's the digital equivalent of having someone on your team who does nothing but send reminder emails, reliably, every time, without being asked.

Build It Step by Step

Part 1: Set up your Google Calendar appointment system

For this automation to work, you need a consistent way to include client email addresses in calendar events. Here's the simplest approach:

Option A: Use the calendar event description field: When creating an appointment, add the client's email address in the event description. Example:

  • Title: "Client Appointment"
  • Description: "client@email.com | Housing intake appointment | Bring: photo ID, proof of income"

Option B: Use a Google Sheet as the appointment tracker: Create a spreadsheet with columns: Client_Email, Appointment_Date, Appointment_Time, Appointment_Type, Location, What_to_Bring

Option B gives more flexibility and is described in the steps below.

Part 2: Create your Google Sheet appointment tracker

  1. Open Google Sheets and create a new spreadsheet called "Appointment Tracker"

  2. Create these column headers:

    • A: Client_Email
    • B: Appointment_Date (format: MM/DD/YYYY)
    • C: Appointment_Time
    • D: Appointment_Type (e.g., "Housing Intake")
    • E: Location
    • F: What_to_Bring
    • G: Reminder_Sent_48hr
    • H: Reminder_Sent_24hr

  3. Add a test row with your own email and a future date (2 days from today)

Important: No client last names, case numbers, or sensitive information in this spreadsheet. Client email and appointment logistics only.

Part 3: Create a Zapier account

  1. Go to zapier.com and create a free account
  2. Click Create Zap to open the visual workflow builder

Part 4: Set up the 48-hour reminder Zap

Trigger:

  1. Click the Trigger step
  2. Select Schedule by Zapier
  3. Choose Every Day and set it to run at 8:00 AM daily
  4. This creates a daily check: Zapier runs at 8am and looks for appointments 48 hours out

Add a Google Sheets step:

  1. Click + to add an action
  2. Select Google Sheets → Lookup Spreadsheet Row
  3. Connect your Google account
  4. Select your "Appointment Tracker" spreadsheet
  5. Set the lookup to find rows where Appointment_Date equals today's date + 2 days

Note on date math in Zapier: Use Zapier's built-in date formatter. In the lookup value field, click the + icon and use: {{zap_meta_human_now}} then add a Formatter step to add 2 days to today's date.

Add the email action:

  1. Add a Gmail → Send Email action
  2. To: {Client_Email} (from spreadsheet)
  3. Subject: Appointment Reminder: Coming Up in 2 Days
  4. Body:
Copy and paste this
Hi there,

This is a friendly reminder that you have an upcoming appointment:

Date: {Appointment_Date}
Time: {Appointment_Time}
Type: {Appointment_Type}
Location: {Location}
What to bring: {What_to_Bring}

If you need to reschedule, please call us at [YOUR PHONE NUMBER] or reply to this email.

We look forward to seeing you!

[Your Name]
[Agency Name]
[Phone Number]
  1. Add a final Google Sheets → Update Spreadsheet Row action to mark Reminder_Sent_48hr = "Yes"

Part 5: Create a second Zap for 24-hour reminders

Duplicate the first Zap (right-click in Zapier → Duplicate). Change:

  • The date lookup to today + 1 day instead of today + 2 days
  • The email subject to "Appointment Reminder: Tomorrow!"
  • Update the Reminder_Sent_24hr column instead

Part 6: Test and turn on

  1. Add a test row in the spreadsheet with your own email and tomorrow's date
  2. Turn on both Zaps
  3. The next morning, you should receive the test reminder email

What you should see: Reminder emails arriving in your own inbox, matching the appointment details in your spreadsheet.

Real Example

Before automation: Case manager with 40 active clients spends 20–30 minutes every morning sending reminder emails and texts for the day's and next day's appointments, working from memory and calendar.

After automation:

  • Case manager adds appointment to the tracker spreadsheet when scheduling (30 seconds)
  • Zapier runs at 8am daily, finds all appointments 48 and 24 hours out
  • Clients receive professional reminders automatically
  • No-show rate decreases because reminders are consistent and timely
  • Case manager reclaims 20–30 minutes every morning for direct client work

Time saved: 20–30 minutes/day × 5 days = 1.5–2.5 hours per week recovered.

What to Do When It Breaks

  • Zapier doesn't find the appointment row → Check that your date format in the spreadsheet matches what Zapier expects. Use MM/DD/YYYY consistently and avoid merged cells.
  • Emails not sending → Check that your Gmail account is still connected in Zapier (Settings → Connected Accounts). Reconnect if the authorization has expired.
  • Clients not receiving emails → Some email providers flag automated emails as spam; advise clients to add your email address to their contacts when providing it
  • Zapier free plan limit hit → The free Zapier plan allows 100 tasks/month; if you run more reminders than that, upgrade to the Starter plan or reduce frequency

Variations

  • Simpler version: Use Google Calendar's built-in email reminders (when creating an event, add the client's email as a Guest and they receive automatic reminders). Less customizable but zero setup.
  • Extended version: Add a text message (SMS) reminder step using Twilio or a similar SMS Zapier integration for clients who don't check email regularly

What to Do Next

  • This week: Build and test the 48-hour Zap with your own email; verify it works before using for real clients
  • This month: Run both Zaps for 30 days and measure your no-show rate compared to the previous month
  • Advanced: Add a pre-appointment intake form link to the reminder email so clients can complete paperwork before arriving

Advanced guide for Case Manager professionals. These techniques use more sophisticated AI features that may require paid subscriptions.