Zapier Automation: Automatic Client Document Follow-Up Reminders

What This Builds

Instead of manually checking which clients still owe you documents and writing follow-up emails by hand, you'll have an automation that monitors a spreadsheet and automatically sends a reminder email when a client's documents are still marked "pending" after a set number of days. It runs in the background — no checking, no chasing, no manual emails.

Prerequisites

• Zapier account (free plan works for basic setup)
• Google Sheets or Excel (Google Sheets recommended — easier with Zapier)
• Gmail or Outlook email account (connected to Zapier)
• Basic comfort with filling in web forms
• Time needed: 1.5 hours to build; zero ongoing time to run
• Cost: Zapier free plan (limited automations) / $20/mo Starter for higher volume

The Concept

Think of Zapier as a digital assistant who checks your client tracking spreadsheet every day and sends reminder emails for you. You tell it the rule: "If a row says 'Pending' and the due date was 5+ days ago, send the client a reminder." It does the checking and sending automatically — you just update the spreadsheet when documents arrive.

A Zap is made of two parts:

1. Trigger: Something that causes the automation to run (checking the spreadsheet daily)
2. Action: What happens when the trigger fires (send an email)

Build It Step by Step

Part 1: Set Up Your Client Tracking Spreadsheet

Create a Google Sheet named "Tax Season 2026 — Document Tracker" with these columns:

• A: Client Name (or Client ID to stay anonymous)
• B: Contact Email
• C: Documents Needed (brief description)
• D: Request Sent Date (date you first asked)
• E: Due Date (when you need them)
• F: Status (drop-down: "Pending" / "Received" / "Follow-Up Sent" / "Complete")
• G: Last Follow-Up (date you last sent a reminder)

Fill in a few rows with real client data (or test data to start).

Part 2: Create a Zapier Account

Go to zapier.com and sign up with your Google account or email. The free plan allows 5 Zaps (automations) with 100 tasks/month — enough for testing and light use. Click "Create Zap" to start.

Part 3: Set the Trigger — Check Spreadsheet Daily

Step 1: In the Zap editor, click the Trigger box. Search for and select "Google Sheets".

Step 2: Choose trigger event: "New or Updated Spreadsheet Row" (this fires whenever a row changes, which isn't quite what we want — see Step 4 for the better approach using Schedule).

Better approach for daily checking:

Change the trigger to "Schedule by Zapier" → "Every Day" → Set the time (e.g., 8:00 AM).

This runs the automation every morning instead of waiting for a spreadsheet change.

Part 4: Set the Filter — Only Pending Rows Past Due Date

After the Schedule trigger, add a "Filter" step:

• Connect to Google Sheets: look up rows in your tracker spreadsheet
• Filter condition: Status = "Pending" AND Today's Date > Due Date + 5 days

(Note: Zapier's Google Sheets lookup and filter steps require a bit of configuration — use the "Lookup Spreadsheet Row" action to pull data, then a Filter step to check conditions.)

Part 5: Set the Action — Send Reminder Email

After the Filter step, add an action:

• App: Gmail (or Outlook)
• Action: Send Email
• To: Map to the Contact Email column from your spreadsheet
• Subject: "Reminder: Documents needed for your tax return — [Client Name]"
• Body: Use this template, mapping spreadsheet fields with the {{}} syntax:

Hi [Client Name],

I wanted to follow up on our earlier request for your tax documents.

We're still waiting for: [Documents Needed]

To keep your return on schedule, please send these by [Due Date].

If you have questions or need help gathering these items, don't hesitate to reach out.

Best regards,
[Your Name]
[Firm Name] | [Phone]

Part 6: Update Status After Sending

Add a final action: Google Sheets → Update Spreadsheet Row → Set Status to "Follow-Up Sent" and Last Follow-Up to today's date.

This prevents double-sending and keeps your tracker accurate.

Part 7: Turn on the Zap and Test

Click "Turn On Zap." To test: manually set a row in your spreadsheet to "Pending" with a past due date, then manually trigger the Zap from the Zapier editor. Verify the email arrives and the status updates.

Real Example: Busy Season in Action

Setup: 90 minutes on a Saturday before tax season starts. Load 40 client rows into the tracker.

Every morning at 8 AM during busy season:

• Zapier checks all 40 rows
• 6 clients are "Pending" past their due date
• 6 reminder emails go out automatically — personalized with each client's name and specific documents needed
• Status updates to "Follow-Up Sent"

What you do: Update the Status to "Received" when clients send documents. That's it.

Time saved: Approximately 60–90 minutes/week of manual email chasing during a 10-week busy season = 10–15 hours recovered.

What to Do When It Breaks

• Emails aren't sending → Check the Gmail/Outlook connection in Zapier settings. Reconnect if needed (tokens expire).
• Wrong rows being triggered → Double-check your Filter conditions. Add a test row with known data and trace through each step manually.
• Status not updating → The Update Spreadsheet Row action needs the row's unique ID. Make sure you're referencing the correct row identifier from the Lookup step.
• Sending too many emails → Add a condition: "Only send if Last Follow-Up is blank OR more than 7 days ago" to avoid daily harassment.

Variations

• Simpler version: Use Zapier's free "Delay" action to send one follow-up 7 days after the initial request date — no filter logic needed
• Extended version: Add a second email action that sends a more urgent message if still Pending 14 days past due; or CC your supervisor automatically for accounts over 21 days

What to Do Next

• This week: Build the spreadsheet and test the Zap with 3–5 fake client rows
• This month (before busy season): Load all clients and turn it on; monitor for a week to make sure emails look right
• Advanced: Connect to TaxDome or your practice management system instead of a spreadsheet if they have Zapier integrations — eliminates the manual spreadsheet entirely

Advanced guide for staff accountant professionals. Zapier automations send real emails — always test with your own email address first before running on actual clients. Review firm policy on automated client communications.