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.