Automation: Trigger Annual Review Prep from Your CRM

What This Builds

An automated workflow that detects when a client's annual review is approaching (30 days out) in your CRM or calendar, then automatically generates a pre-populated review prep document and sends it to you — so instead of scrambling to prep the morning of the meeting, you have a structured agenda and talking points waiting in your inbox a month in advance.

For an advisor with 80 active clients, this replaces 80 × 45-minute manual review prep sessions per year — saving over 60 hours annually.

Prerequisites

• A Zapier account — free plan works to start; Starter plan (${{tool:Zapier.price}}) required for multi-step zaps — Sign up
• Your CRM connected to Zapier (Redtail, Wealthbox, and most major CRMs have Zapier integrations)
• A ChatGPT Plus account for the AI step
• Gmail or Outlook connected to Zapier for email delivery
• Basic client data entered in CRM: policy anniversary date, product type, initial premium, current values (or a process for updating them)

The Concept

Zapier is a connection tool — it watches for events in one app (your CRM showing an anniversary date approaching) and triggers actions in others (generating a document with ChatGPT and emailing it to you). Think of it as an invisible assistant who notices important dates and automatically prepares your briefing packet before you have to ask.

The full chain: CRM event → Zapier detects trigger → Zapier sends client data to ChatGPT → ChatGPT generates review prep document → Zapier emails document to you.

Build It Step by Step

Part 1: Set up your CRM data structure (20 minutes)

Your CRM needs to have the right data for this to work. Make sure each client record includes:

• Policy anniversary date (the date they purchased, which drives the annual review schedule)
• Product type (FIA, MYGA, IUL, etc.)
• Initial premium amount
• Current surrender value (update annually — even quarterly if possible)
• Income start date (if applicable)
• Client age and spouse age (if applicable)
• Primary goal (income, protection, growth)
• A "Last Annual Review" date field

If these fields don't exist in your CRM, add custom fields before proceeding.

Part 2: Create the Zapier account and connect your apps (30 minutes)

1. Go to zapier.com and create an account (free plan to start)
2. Click My Apps → Add a new app
3. Connect your CRM — search for your CRM name (Redtail, Wealthbox, HubSpot, etc.) and follow the authentication steps
4. Connect your email (Gmail or Outlook) — same process, search and authenticate
5. Connect ChatGPT — search "ChatGPT" in Zapier apps and authenticate with your OpenAI API key

Getting your OpenAI API key:

• Go to platform.openai.com → log in with your ChatGPT account
• Click API keys in the left sidebar
• Click Create new secret key → copy the key immediately (it only shows once)
• In Zapier, paste this key when connecting ChatGPT

What you should see: Three connected apps showing green checkmarks in Zapier: your CRM, ChatGPT, and Gmail/Outlook.

Part 3: Build the Zap (45-60 minutes)

1. Click Create Zap in Zapier
2. Step 1 — Trigger: Select your CRM as the trigger app

   • Choose New or Updated Record (or the event type that fires when an anniversary date is upcoming)
   • Configure the filter: trigger when the Policy Anniversary Date is 30 days from today
   • Test the trigger by selecting a sample client record

What you should see: Zapier shows sample data from one of your client records — name, policy date, product type, etc.

1. Step 2 — Filter: Add a Zapier Filter step to ensure only active clients trigger the workflow:

   • Only continue if Client Status equals "Active"
   • Only continue if Policy Anniversary Date is not empty

2. Step 3 — ChatGPT: Add a ChatGPT action step

   • Action: Send Prompt
   • Model: {{tool:ChatGPT.model:general}}
   • In the Prompt field, build a dynamic prompt using your CRM data:

Create an annual review meeting agenda and preparation notes for an insurance financial planning client.

Client details:
- Name: [map CRM field: Client First Name]
- Age: [map CRM field: Client Age]
- Product: [map CRM field: Product Type]
- Purchased: [map CRM field: Purchase Date]
- Initial premium: [map CRM field: Initial Premium]
- Current surrender value: [map CRM field: Current Value]
- Primary goal: [map CRM field: Client Goal]
- Years since purchase: [calculated field]

Generate:
1. A 5-item meeting agenda appropriate for an annual review of this product type
2. 3 talking points specific to where this client is in their contract timeline
3. 2 questions to ask about any life changes in the past year
4. Any relevant information to share (e.g., if near surrender period end, approaching income start date)

Output as a formatted document the advisor can use in the meeting.

What you should see: The prompt field populated with a mix of static text and dynamic CRM data fields (shown as blue pills in Zapier).

1. Step 4 — Email: Add Gmail or Outlook as the final step

   • Action: Send Email
   • To: your email address
   • Subject: "Annual Review Prep: [Client Name] — [Meeting Date]"
   • Body: Paste the ChatGPT output from Step 3

What you should see: A preview of the email that will be sent to you — formatted review prep document with the client's name in the subject line.

1. Test the full Zap: Click Test & Continue at each step to verify the chain works end to end.

2. Turn on the Zap: Click the toggle to activate. From now on, the automation runs automatically.

Part 3: Refine and monitor (20 minutes)

Run the automation for 2–3 clients manually first (using Zapier's "Run Zap" button) to verify the output quality. Common adjustments:

• If ChatGPT output is too generic: add more CRM fields to the prompt (years to income start, any noted life changes)
• If email formatting looks messy: ask ChatGPT to format output as bullet points rather than paragraphs
• If the trigger fires at wrong times: adjust the "30 days before" filter logic

Real Example: The Thompson Annual Review

Setup: Your Zap has been running for 2 months.

Input (automatic, no action from you): Zapier detects that Jim and Carol Thompson's policy anniversary is 30 days away. Their record shows: FIA purchased in 2021, $240K initial premium, current surrender value $268K, primary goal: income in 3 years.

What happens: Zapier sends the data to ChatGPT. ChatGPT generates:

• Meeting agenda with 5 items including "Review income rider timeline — 3 years to income start"
• Talking points about reviewing their income account value and current payout projection
• Questions: "Any health changes? Still planning to move to Arizona?"
• Note: "Surrender period ends in 3 years — same timeline as income start. No penalty to start income on schedule."

What arrives in your inbox: A clean, client-specific prep document — 30 days before the meeting.

Time saved: 45 minutes of manual prep per client → 2 minutes to review the AI-generated document.

Output: "Annual Review Prep: Jim and Carol Thompson — April 15, 2026"

What to Do When It Breaks

• Trigger doesn't fire → Check that the anniversary date field in your CRM is formatted as a date (not text). Zapier requires a proper date format to calculate "30 days before."
• ChatGPT returns empty or generic output → Your CRM fields aren't mapping correctly. Open the Zap editor and verify each [CRM field] is showing real data, not blank values.
• Email not received → Check your spam folder first. Then verify the email step in Zapier shows a successful run in the Zap History tab.
• Too many emails (all clients triggering at once) → Add a filter: only trigger for clients whose "Last Annual Review" date was more than 11 months ago. This prevents duplicate triggers.
• ChatGPT API costs getting high → Switch from GPT-4 to a faster, cheaper model for this routine prep task. In the Zapier ChatGPT step, change the model to {{tool:ChatGPT.model:fast}}.

Variations

• Simpler version: Instead of connecting your CRM, create a recurring Google Calendar event 30 days before each annual review that triggers the Zap manually via a Google Calendar integration.
• Extended version: Add a second email step that sends a "Your annual review is coming up — here's how to prepare" email directly to your client with links to any relevant account documents.

What to Do Next

• This week: Connect your CRM, ChatGPT, and email to Zapier. Test the integration with one client record.
• This month: Run the full automation for 5–10 clients. Note any output quality issues and refine the prompt.
• Advanced: Add a second automation that generates prospect follow-up emails 7 days after seminar attendance, using the same CRM → ChatGPT → email chain.

Advanced guide for Insurance Financial Planner professionals. Requires Zapier paid plan and ChatGPT API key for multi-step automation.