Zapier Automation: Auto-Route and Acknowledge COI Requests

What This Builds

You'll create a Zapier automation that monitors your agency email inbox for certificate of insurance (COI) requests, sends an automatic acknowledgment to the requestor, and creates a tracking entry in a Google Sheet or sends you a task reminder. Instead of COI requests getting buried in your inbox, every one gets an immediate response and lands in a trackable queue — automatically.

This is especially valuable if your agency handles more than 5–10 COI requests per week.

Prerequisites

• A Zapier account (free tier includes 5 Zaps and 100 tasks/month — enough to start)
• Gmail or Outlook for work email
• Google Sheets (for the tracking log)
• Permission from your manager to set up automated email responses from the agency inbox
• Cost: Free tier available; paid plans at {{tool:Zapier.price}} for higher volume

The Concept

Zapier works like an "if this, then that" rule for your software. You define a trigger (an email with certain words arrives in your inbox) and an action (send a reply, add a row to a spreadsheet). Once it's set up, it runs automatically in the background every time a new COI request comes in — no manual steps required from you.

Think of it as a very reliable assistant who reads every email and immediately handles the boring first step for you.

Build It Step by Step

Part 1: Create your Zapier account and set up the trigger

1. Go to zapier.com and click Sign Up Free.
2. Log in with your work Gmail or Microsoft account for the easiest email connection.
3. Once in the dashboard, click Create Zap (the orange button).

Setting up the trigger (what starts the automation):

1. In the Zap builder, click Trigger and search for your email provider: Gmail or Outlook / Microsoft 365.
2. Select your email app and click Connect Account — follow the prompts to authorize Zapier to read your inbox.
3. For the trigger event, select New Email (Gmail) or New Email Matching Search (Outlook).
4. In the filter settings, enter: subject:certificate OR subject:COI OR subject:cert request (use your email provider's search syntax).
5. Click Test trigger — Zapier pulls a recent matching email so you can see the data it will work with.

What you should see: A sample email displayed with fields like Subject, From, Body, Date — these become variables you can use in the next steps.

Part 2: Set up the auto-acknowledgment email

1. Click + to add an Action step.

2. Search for your email app (Gmail or Outlook) and select Send Email.

3. Configure the fields:

   To: Use the "From" variable from the trigger — this automatically addresses the reply to whoever sent the COI request.

   Subject: Re: {{subject}} — this keeps the same subject line for the thread.

   Body: Paste this template (customize with your agency info):

Thank you for your certificate of insurance request.

We have received your request and will process it within [2 business hours / same business day].

To help us issue the certificate accurately, please confirm:
- The exact legal name for the certificate holder / additional insured
- Any specific wording required in the Description of Operations field
- Whether you need the certificate emailed, faxed, or both

If you have questions, contact us at [phone number] or reply to this email.

[Agency Name] — [CSR Name / Team Name]

1. Click Continue.

Part 3: Create a tracking log entry in Google Sheets

1. Add another + Action step.

2. Search for Google Sheets and select Create Spreadsheet Row.

3. Connect your Google account.

4. Select (or create) a spreadsheet named "COI Request Tracker."

5. Map these columns:

   • Date Received: Use the trigger's Date variable
   • Requestor Name / Email: Use the From Name and From Email variables
   • Subject / Account: Use the Subject variable
   • Status: Type "Pending" (static text — you'll update this manually as you process)
   • Notes: Leave blank (fill in manually)

6. Click Continue.

Part 4: Test the full Zap

1. Click Test Zap — Zapier runs through the whole workflow with the sample email.
2. Check that: (a) the acknowledgment email was sent to the right address, (b) a new row appeared in your Google Sheet.
3. If both work, click Publish Zap.

What you should see: The Zap is live and will run automatically on every new matching email from now on.

Real Example: Monday Morning at 8:30am

Setup: Zap is live. Your Google Sheet has headers: Date Received, Requestor, Subject, Status, Notes.

What happens: A contractor emails your agency at 8:27am: "Hi, I need a certificate of insurance for the ABC project by 10am — can you please send?"

Automatically (before you even open your inbox):

• Zapier detects the email matches your trigger
• Sends an acknowledgment email within 2 minutes: "We received your COI request and will process it within 2 business hours. Please confirm the additional insured name..."
• Adds a row to your Google Sheet: "3/25/2026 | contractor@email.com | Certificate Request — ABC Project | Pending"

When you arrive at 8:45am:

• The contractor already has a response
• Your Google Sheet has 3 COI requests logged (2 more came in before you arrived)
• You sort by Status, process them in order

Time saved: 5–10 minutes per request on intake alone; zero dropped requests; better client experience.

What to Do When It Breaks

• Zap isn't triggering → Check the email filter keywords; the subject line may not match your trigger. Try broader keywords or add more variants.
• Acknowledgment goes to the wrong address → Verify you're using the "From Email" variable, not a hardcoded address.
• Google Sheet isn't getting new rows → Check that your Google Sheets connection is still authorized (re-connect if needed in Zapier settings).
• Getting too many false positives (emails that aren't COI requests) → Make your trigger filter more specific: add subject:certificate AND subject:insurance or filter by specific sender domains.

Variations

• Simpler version: Skip the Google Sheets step and just set up the auto-acknowledgment email — even this alone saves significant time and improves client experience.
• Extended version: Add a third step that sends you a Slack or Teams notification with the requestor's email and subject, so you see COI requests in your team chat without opening email.

What to Do Next

• This week: Build and test the Zap with just 2 steps (trigger + acknowledgment). Add Google Sheets after you've confirmed the basics work.
• This month: Review your Google Sheet tracker — what are the most common requestors? What information is most often missing from their requests? Use that data to refine your acknowledgment template.
• Advanced: Add a 4th Zapier step that sends a follow-up email 4 hours later if the row is still marked "Pending" — an automated reminder system for your own queue.

Advanced guide for insurance customer service representative professionals. These techniques use more sophisticated AI features that may require paid subscriptions.