Automation: Client Check-In Reminder System with Zapier

For Peer Support Specialists

Tools: Zapier + Google Sheets | Time to build: 1-2 hours | Difficulty: Intermediate-Advanced Prerequisites: Comfortable using Google Sheets for basic tracking. See Level 2 guide: "Build a Community Resource Guide"

What This Builds

This automation creates a systematic client contact reminder system: you maintain a simple Google Sheet with your caseload and each client's target check-in frequency, and Zapier automatically sends you a daily email listing which clients are due for contact today. Instead of relying on memory (and inevitably missing someone), you get a daily briefing every morning. No client falls through the cracks.

Prerequisites

• Google account (free)
• Zapier account (free tier works) at zapier.com
• Basic comfort with Google Sheets
• Agency supervisor awareness of this system

The Concept

Zapier is an automation platform that connects apps and triggers actions. In this case: every morning, Zapier looks at your Google Sheet caseload list, checks who is due for contact today based on their check-in frequency, and emails you a list. You never have to remember. The system tells you.

This works WITHOUT any client PHI if you use your own internal client codes (initials + case number) rather than full names in the spreadsheet.

Build It Step by Step

Part 1: Set Up Your Caseload Google Sheet

1. Create a new Google Sheet named "Caseload Tracker [Year]"
2. Create these column headers in Row 1:

   • A: Client Code (use initials + case number, e.g., "JD-0042")
   • B: Check-in Frequency (Days): how many days between contacts
   • C: Last Contact Date
   • D: Next Due Date (formula: =C2+B2)
   • E: Priority (High/Medium/Low)
   • F: Notes (brief reminders about their situation)
3. Fill in your active caseload. Use client codes, not full names
4. Column D will automatically calculate when each client is next due

Example row:

Part 2: Create a Filtered View of "Due Today"

In your Google Sheet, add a formula in a separate area to identify clients due today:

In cell H1 type: Due Today as a header.

In cell H2 type this formula (shows clients due today or overdue): =FILTER(A2:F100, D2:D100 <= TODAY())

This creates a dynamic list of clients due for contact today.

Part 3: Set Up Your Zapier Account

1. Go to zapier.com → create a free account
2. Click Create Zap
3. For the Trigger, search for "Schedule by Zapier"
4. Choose Every Day trigger
5. Set the time: 7:00 AM (or whatever time you start your day)
6. Click Continue

What you should see: A scheduled trigger that will fire every morning at your chosen time.

Part 4: Connect Google Sheets as the Data Source

1. Add an Action step → search for "Google Sheets"
2. Choose action: Get Many Spreadsheet Rows (or "Lookup Spreadsheet Row")
3. Connect your Google account
4. Select your Caseload Tracker spreadsheet and the main caseload sheet
5. Filter rows: set the filter to only return rows where Column D (Next Due Date) is less than or equal to today

Troubleshooting: If Zapier can't filter by date, use a simpler approach: select all rows and let the email include everyone; then use the date in Column D to visually filter.

Part 5: Create the Email Summary

1. Add another Action → search "Gmail" (or your email provider)
2. Choose: Send Email
3. Configure:

   • To: Your work email
   • Subject: Daily Caseload: [Count] Clients Due for Contact Today — [date]
   • Body: Map the rows from your Google Sheet into a formatted list

For the email body, build a message like:

Good morning! Here are your clients due for contact today:

[Map each row as:]
• [Client Code] — Due: [Date] — Priority: [Level] — Notes: [Notes]

Total due: [count]
Overdue (past due): [list separately if possible]

Have a productive day!

Part 6: Test and Turn On

Click Test Zap to see a test email. Check:

• Does it list the right clients?
• Is the format readable?
• Are any clients missing or incorrectly included?

When satisfied, turn the Zap ON.

Real Example: Full Workflow

Setup: Zap is active; you maintain a 32-client caseload tracker

Input: It's Monday morning, 7am

Output (in your inbox by 7:05am):

Time saved: No more mental caseload management or post-it note systems. Every morning you have a clear, prioritized list of exactly who needs contact today.

What to Do When It Breaks

• Missing clients from the email → Check that their Next Due Date in Column D is calculating correctly and is on or before today
• Zapier can't access your spreadsheet → Reconnect your Google account in Zapier Settings → Connected Accounts
• Too many clients in one email → Add a priority filter to show only High-priority contacts, or split into two separate Zaps (one for High priority, one for Medium/Low)
• Dates not triggering correctly → Ensure dates in your spreadsheet are formatted as dates (YYYY-MM-DD), not text

Variations

• Simpler version: Skip Zapier entirely. Just open your Google Sheet each morning and sort by Column D (Next Due Date). You get the same information without automation.
• Extended version: Add a "Last Contact Notes" column (brief description of last contact) to the sheet; this shows up in your morning email as context before you make the call

What to Do Next

• This week: Set up the Google Sheet tracker (Part 1). Even without automation, this immediately improves caseload visibility
• This month: Add the Zapier automation; use it for 2 weeks and see if it changes how many clients you miss
• Advanced: Add a Zapier step that creates a Google Calendar event for each high-priority contact scheduled for that day

Advanced guide for Peer Support Specialist professionals. The core caseload tracking Google Sheet (Part 1) is the most valuable part. Complete that first even if you don't build the automation.