Zapier Automation: Automate Borrower Document Collection

For Commercial Loan Officers

Tools: Zapier, Gmail/Outlook, Google Sheets | Time to build: 2 hours | Difficulty: Intermediate-Advanced Prerequisites: Comfortable using ChatGPT or Claude for email drafting (see Level 3 guides)

What This Builds

Instead of manually sending document request emails, follow-up reminders, and "thank you, we received it" confirmations, you'll build an automated workflow that: (1) sends a customized document checklist email when a new application is added to your tracking spreadsheet, (2) follows up automatically after 5 days if no response, and (3) sends a confirmation when documents are marked received. You go from chasing documents to managing exceptions.

Prerequisites

• Zapier account (free tier supports this workflow; Zapier Starter ~$20/month for automation at scale)
• Gmail or Outlook (your work email that Zapier can connect to)
• Google Sheets (to track your loan pipeline, or adapt for Excel/Airtable)
• Comfortable drafting borrower emails with AI (to write your email templates first)

The Concept

A Zapier automation is like a bank teller who handles one specific repetitive task perfectly, every time, without forgetting. You define the trigger ("new row added to my pipeline spreadsheet") and the action ("send this document request email to the borrower"). Once configured, it runs automatically whenever the trigger fires. You never have to remember to send the email again. This handles the mechanical parts of document collection; you still handle conversations and questions.

Build It Step by Step

Part 1: Set Up Your Pipeline Tracking Spreadsheet

Create a Google Sheet with these columns (or add to your existing pipeline tracker):

Part 2: Write Your Email Templates First

Before building the automation, write your document request email templates for each loan type using ChatGPT (Level 1 prompt in this guide set). Save them in a document. You'll paste these into Zapier.

You'll need:

• Template 1: C&I loan document request
• Template 2: CRE loan document request
• Template 3: SBA 7(a) document request
• Template 4: 5-day follow-up (friendly but firm)
• Template 5: Documents received confirmation

Part 3: Connect Gmail/Outlook to Zapier

1. Go to zapier.com and create an account
2. Click Create Zap (a Zap is one automation)
3. In the Trigger section, search for "Google Sheets"
4. Select your Google account and authorize Zapier
5. Choose trigger event: New or Updated Row in Spreadsheet
6. Select your pipeline spreadsheet and sheet tab
7. Set the trigger column: "Doc Request Sent" to trigger when this changes to "No" (or when it remains blank as a new row is added)

Part 4: Build the Document Request Automation (Zap 1)

Trigger: New row added to your pipeline sheet Filter: Only proceed if "Doc Request Sent" column = blank AND "Loan Type" is filled in Action 1 (Formatter): Use Zapier's built-in Formatter to look up the right email template based on Loan Type (C&I → Template 1, CRE → Template 2, etc.) Action 2 (Email): Send email via Gmail/Outlook

• To: [Contact Email column]
• Subject: "Document Request: [Borrower Name] Loan Application"
• Body: [Your template, with [Borrower Name] and [Loan Type] inserted automatically] Action 3 (Sheets update): Mark "Doc Request Sent" = Yes and record the date

Test: Add a test row to your sheet. Verify the email sends to the correct address with the right template and your name in the signature.

Part 5: Build the Follow-Up Automation (Zap 2)

Trigger: Schedule, runs every morning at 8am Filter: Look through your pipeline sheet for rows where:

• Doc Request Sent = Yes
• Documents Received = No or blank
• Application Date = more than 5 days ago Action: Send a follow-up email using Template 4 (friendly reminder) Action 2: Mark "Follow-Up Sent" = Yes

Important: Set a maximum of 2 automated follow-ups. The third follow-up should be a phone call. Flag these with a color coding change in the sheet.

Part 6: Build the Confirmation Automation (Zap 3)

Trigger: Your pipeline sheet row, when "Documents Received" changes to "Yes" Action: Send confirmation email to borrower using Template 5 ("Thank you, we received your documents. Here's what happens next...") Action 2: Log the received date in the sheet

Real Example: The Full Workflow

Setup: You've built all three Zaps. It's Monday morning.

What you do: You open your pipeline sheet and add a new row for Miller Hardware, a $350K equipment loan. You fill in the borrower name, email, loan type (C&I Equipment), loan amount, and today's date.

What happens automatically:

• Within 10 minutes, Zapier fires Zap 1. Miller Hardware receives a professional document request email with the correct checklist for a C&I equipment loan. "Doc Request Sent" updates to Yes.
• Day 6: Miller Hardware hasn't responded. Zap 2 fires at 8am and they receive a friendly follow-up reminder. "Follow-Up Sent" updates to Yes.
• Day 8: Miller Hardware emails back with their financials attached. You open the sheet and mark "Documents Received" = Yes. Zap 3 fires and they receive a confirmation email explaining the next steps in the underwriting process.

Time saved: 3 emails that previously required 20–30 minutes each, now handled automatically. You spent zero time on mechanical document chasing and focused entirely on evaluating the documents when they arrived.

What to Do When It Breaks

• Email sent to wrong template → Check the Formatter step and verify the Loan Type spelling in your sheet matches exactly what the Formatter expects (case-sensitive).
• Zap fires multiple times for same row → Add a filter checking "Doc Request Sent" = blank before sending. This prevents repeat sends when you update other columns.
• Follow-up sent to already-closed deals → Add a "Status" column to your pipeline sheet and filter out rows where Status = Closed or Declined.
• Zapier throttles free account → Free tier allows limited Zaps per month. Prioritize the document request Zap (most valuable) and do follow-ups manually if needed until you upgrade.

Variations

• Simpler version: Use only Zap 1 (document request only). Skip the follow-up and confirmation automations. Still saves significant time.
• Extended version: Add a Slack/Teams notification to yourself when documents are received, so you see it immediately rather than checking the sheet. Add a CRM update step that logs the email activity in Salesforce or your bank's CRM automatically.

What to Do Next

• This week: Build and test Zap 1 only. Get the document request working perfectly before adding follow-ups.
• This month: Add the follow-up and confirmation Zaps; refine your email templates based on borrower responses.
• Advanced: Integrate with your LOS. If your LOS has an API or Zapier connector (nCino has Salesforce integration), you can trigger automations from LOS status changes rather than a Google Sheet.

Advanced guide for commercial loan officer professionals. These automations connect to your email. Verify with your IT/compliance team that external automation tools are permitted under your bank's technology policy.