Automation: Renewal Email Pipeline That Runs Itself

What This Builds

Instead of manually checking who's up for renewal and sending emails by hand, this automation monitors your renewal list in Google Sheets and automatically drafts (or sends) 60/30/7-day renewal reminder emails — so no policy renewal falls through the cracks even during your busiest months. Set it up once; it runs indefinitely.

Prerequisites

• Comfortable using email templates you've built in ChatGPT (Level 3)
• A Zapier account at zapier.com (free plan handles basic version; paid at $20–50/mo for multi-step automations)
• Gmail (or Outlook with Zapier integration)
• A Google Sheet with your renewal list
• Cost: Free (limited) / $20–50/month Zapier paid

The Concept

Zapier is an automation platform — it connects different apps and makes things happen automatically based on triggers. In this case: "When a row in my Google Sheet shows a renewal date 60 days from now — send an email." You define the trigger; Zapier handles the timing and execution.

Think of it as hiring a virtual assistant who checks your renewal calendar every morning and sends the right email to the right client at the right time — without you having to think about it.

Build It Step by Step

Part 1: Set Up Your Renewal Google Sheet

Create a Google Sheet with these columns:

• Column A: Client Name
• Column B: Email Address
• Column C: Policy Type (Auto, Home, Commercial, etc.)
• Column D: Renewal Date (format: YYYY-MM-DD, e.g., 2026-05-15)
• Column E: 60-Day Email Sent (leave blank; Zapier will update this)
• Column F: 30-Day Email Sent (leave blank)
• Column G: 7-Day Email Sent (leave blank)

Populate this sheet from your AMS renewal reports. Most AMS platforms (Applied Epic, HawkSoft, EZLynx) can export renewal lists — export to CSV, open in Google Sheets, and copy the relevant columns.

Why a Google Sheet? Zapier integrates natively with Google Sheets. Your AMS may also integrate directly with Zapier (check zapier.com/apps for your AMS) — if so, you can skip the Google Sheet step.

Part 2: Create Your Email Templates in Gmail

Using the email templates you built in the Level 3 guide, save 3 templates per major policy type in Gmail:

• Go to Gmail Settings → Advanced → enable Templates
• Compose an email → type (or paste) your renewal template → three-dot menu → Templates → Save draft as template

Name them clearly: "Auto - 60 Day Renewal", "Auto - 30 Day Renewal", "Auto - 7 Day Renewal"

For the Zapier setup, you'll use the template text directly in Zapier rather than Gmail's template feature — but having them saved there gives you a reference.

Part 3: Build Your First Zap (60-Day Trigger)

Go to zapier.com and click Create Zap.

Step 1 — Trigger: Search for "Schedule by Zapier" → select Every Day → set time to 8:00 AM. This runs the Zap every morning.

Step 2 — Action 1 (Find renewals): Search for "Google Sheets" → select Lookup Spreadsheet Row. Connect your Google account. Select your renewal sheet. In the lookup configuration, set it to find rows where the Renewal Date equals today's date + 60 days AND the "60-Day Email Sent" column is blank.

This step requires a Zapier paid plan for multi-step Zaps. The free plan supports 2-step Zaps only.

Step 3 — Action 2 (Send email): Search for "Gmail" → select Send Email (for automatic send) or Create Draft (if you want to review before sending — recommended to start). Map the fields:

• To: [Email Address column from Google Sheets]
• Subject: "Quick note about your [Policy Type] renewal in 60 days"
• Body: Paste your 60-day email template, using Zapier's data mapping to insert [Client Name] and the renewal date from your Google Sheet

Step 4 — Action 3 (Mark as sent): Add another Google Sheets action → Update Spreadsheet Row → set the "60-Day Email Sent" column to today's date for that row.

Click Test → verify a test email is sent correctly → Turn on Zap.

Part 4: Build the 30-Day and 7-Day Zaps

Repeat Part 3 twice:

• For 30-Day: Same setup, trigger finds rows where Renewal Date = today + 30 days AND 30-Day Email Sent is blank
• For 7-Day: Renewal Date = today + 7 days AND 7-Day Email Sent is blank

What you should have: Three Zaps running every morning, each checking for the right timing and sending the right email automatically.

Real Example: 45 Renewals in May

Setup: Your Google Sheet has 45 renewals in May (today is March). Three Zaps are running.

What happens automatically:

• March 1: Zap finds 3 clients whose policies renew May 1 (60 days out). Sends 60-day emails to all 3. Updates the sheet to show emails sent.
• March 15: 4 more clients hit the 60-day window. Emails sent automatically.
• April 1: The first 3 clients hit their 30-day window. 30-day emails sent automatically.
• April 22: Those same clients hit 7 days. Final reminder sent.

Time saved: 45 renewals × 3 emails × 3 minutes/email = 405 minutes (6.75 hours) of manual work eliminated per month.

Input: You update the Google Sheet (5 minutes from an AMS export). That's it.

What to Do When It Breaks

• Zap not triggering → Check that the Google Sheet date format is exactly YYYY-MM-DD; Zapier date math fails with other formats
• Wrong clients getting emails → Check the lookup logic; ensure the "already sent" columns are being marked correctly
• Emails going to spam → Gmail sending limits apply; sending more than ~100 automated emails/day from a personal Gmail triggers spam filters; switch to Google Workspace (paid) for higher limits
• Renewal date exported incorrectly from AMS → Build in a manual review step — use "Create Draft" instead of "Send Email" and spend 5 minutes each morning approving the drafts

Variations

• Simpler version: Use Zapier's free plan (2-step Zap) to send you a daily digest of who needs renewal outreach — then you draft and send manually. Less automated but free.
• Extended version: Add a Zap that creates a task in your project management tool (Asana, Todoist, Google Tasks) when a renewal email is sent — so you can track who responded and who needs a follow-up call

What to Do Next

• This week: Build the Google Sheet renewal tracker and manually send the first week's outreach using your Level 3 templates
• This month: Build the 60-day Zap first; get comfortable with the automation before adding 30 and 7-day triggers
• Advanced: Add a Zapier step that checks if the client replied to the 60-day email (using Gmail search) before sending the 30-day — so clients who already responded don't get a redundant follow-up

Advanced guide for insurance agent professionals. Zapier pricing and features change frequently. Verify email sending limits with your email provider before deploying at scale.