Automation: Zero-Touch Document Follow-Up Pipeline

What This Builds

Instead of manually checking your pipeline each day and sending individual document follow-up texts or emails, this automation watches your CRM for borrowers with outstanding documents and automatically sends escalating, personalized reminders on a schedule — without you touching it. For a 20-file pipeline, this reclaims 30–60 minutes of daily busywork and ensures no borrower slips through the cracks.

Prerequisites

• Zapier account (free tier works for basic setup; Starter plan at $20/month for more steps)
• A CRM that Zapier can connect to (Salesforce, HubSpot, Total Expert via webhook, or a simpler tool)
• OpenAI API key (from platform.openai.com — pay-per-use, typically $5–20/month for this volume)
• SMS service that Zapier supports: Twilio ($15/month + message costs) or a CRM with built-in texting

The Concept

Think of this like a factory assembly line with a quality-check trigger: every time a file sits at "documents pending" for more than 48 hours, the line automatically sends a nudge to the borrower. If they still haven't responded by day 4, the nudge escalates. By day 6, you get a personal alert to call them. The assembly line runs 24/7 without you thinking about it.

Build It Step by Step

Part 1: Set Up Your CRM Trigger

You need a way for Zapier to know when a borrower has outstanding documents. The cleanest approach:

Option A — CRM Status Tag (easiest):

1. In your CRM, create a tag or status field called "Docs Pending"
2. Set a "Last Contact Date" or "Date Tag Applied" field that updates automatically when you add the tag
3. Zapier will watch for this tag + check the elapsed time

Option B — Spreadsheet Tracking (simplest if CRM doesn't integrate):

1. Create a Google Sheet with columns: Borrower Name | Email | Phone | Docs Needed | Date Requested | Follow-Up Count
2. When you request documents, add the borrower to this sheet
3. Zapier watches this sheet for rows where "Date Requested" was 2+ days ago

For this guide, we'll use Option B (Google Sheet) as it works regardless of your CRM.

Part 2: Build the Zapier Automation

Step 1: Create a new Zap

1. Go to zapier.com → Create Zap
2. Name it: "LO Document Follow-Up Automation"

Step 2: Set the Trigger

1. Trigger app: Google Sheets
2. Trigger event: New or Updated Row in Spreadsheet
3. Select your Document Tracking spreadsheet
4. Add a Filter step: only continue if Follow-Up Count is less than 3 AND Date Requested was 2+ days ago

Step 3: Add AI Message Generation

1. Add action: OpenAI
2. Action event: Send Prompt (using GPT-4o-mini for cost efficiency)
3. In the prompt field, paste:

Write a document follow-up {{Follow-Up Count + 1}} of 3 for a mortgage borrower.
Borrower first name: {{First Name}}
Documents needed: {{Docs Needed}}
Days since requested: {{Days Since Request}}

Message 1 (days 2-3): Friendly reminder, assume they forgot
Message 2 (days 4-5): More urgent, explain timeline impact
Message 3 (day 6): Final urgent notice, say I will call today

Output: Text message only, under 160 characters, professional but warm.

Step 4: Send the Message

1. Add action: Gmail (or Twilio for SMS)
2. For Gmail: Set To = {{Email}}, Subject = "Quick reminder about your loan documents", Body = {{OpenAI output}}
3. For Twilio SMS: Set To = {{Phone}}, Body = {{OpenAI output}}

Step 5: Update the Tracker

1. Add action: Google Sheets - Update Row
2. Update Follow-Up Count to increment by 1
3. Update Last Follow-Up Date to today

Step 6: Add a Personal Alert (Day 6)

1. Add a Filter: only continue if Follow-Up Count = 3
2. Add action: Gmail — Send Email to Yourself
3. Subject: "ACTION NEEDED: Call {{First Name}} — documents 6 days overdue"
4. Body: "{{First Name}} hasn't submitted {{Docs Needed}}. Phone: {{Phone}}. File at risk."

Part 3: Test and Refine

1. Add yourself as a test row in the Google Sheet with Date Requested = 2 days ago
2. Run your Zap manually from the Zapier editor
3. Verify you receive the correct message
4. Check that the Follow-Up Count increments correctly
5. Test the Day 6 alert by setting Follow-Up Count to 3

What "good" looks like:

• Day 2 text arrives: friendly, personalized, mentions specific documents
• Day 4 text: slightly more urgent, still professional
• Day 6: you get an alert to call; borrower has received maximum automated nudges

Real Example: A Full Workflow

Setup: You add a row for "Sarah Chen" who needs: 2 months bank statements, most recent pay stub. Date Requested: Monday March 17.

Wednesday March 19 (Day 2): Zapier automatically sends:

Friday March 21 (Day 4): Zapier sends:

Sunday March 23 (Day 6): You receive:

Time saved: Instead of checking 20+ files daily and writing individual texts — this ran automatically while you focused on new applications.

Time saved: Approximately 30–45 minutes per day for a 20-file pipeline

What to Do When It Breaks

• Zap runs but doesn't send message: Check your Gmail/Twilio connection is still authenticated — re-connect in Zapier settings
• AI message comes back blank: Check your OpenAI API key is active and has credit; add fallback text in the Zapier step
• Borrower complains they got too many messages: Add a "Do Not Contact" column to your sheet; add a filter that skips rows with this flag set
• Days-since-request calculation is off: Zapier's date math can be tricky; use a Google Sheets formula to calculate the days column: =TODAY()-[Date Requested cell]

Variations

• Simpler version: Skip OpenAI API entirely — write your 3 messages as static templates and just use Zapier to send them on a schedule. Less personalized but zero per-message API cost.
• Extended version: Add a 4th message type — a video text (BombBomb) for high-value files. Zapier can trigger BombBomb sends for dramatic follow-up escalation.

What to Do Next

• This week: Build and test the basic version with Google Sheets
• This month: Track whether document collection time improves; adjust message timing
• Advanced: Connect directly to your CRM (Salesforce, Total Expert) instead of Google Sheets for full automation without manual data entry

Advanced guide for loan officer professionals. Requires Zapier account, OpenAI API key, and a texting or email tool. Estimated monthly cost: $30–50 for a 20-file pipeline (Zapier Starter + OpenAI usage + Twilio messages).