Open enrollment follow-up: an n8n workflow for insurance agencies
A ready-to-import n8n workflow for ACA open enrollment. Each morning it compares current and renewal plans, flags premium jumps and discontinued plans, drafts a personal email and text with a booking link, logs every contact and builds the daily call list. Licensed agents still review every plan with the client.
Overview
The problem
Open enrollment is a short window. Agencies need to reach every client whose renewal changed before the deadline, and a spreadsheet plus memory does not scale when hundreds of renewals land at once.
What we built
What we built, piece by piece.
Morning schedule
Runs every morning at 8 AM over the renewal list (demo data in the template).
Renewal comparison
Compares this year's plan with next year's and decides whether a review call is needed.
Outreach drafts
Drafts an email and text with a booking link for clients who need a call, or a short check-in note for small changes.
Follow-up list
Logs every contact and adds anyone with no reply after three days to the broker call list.
Architecture
Open enrollment follow-up workflow from the code.
- Input
- Data
- Logic and services
- Output
- People
How it flows
- 1 Each morning the workflow loads the renewal list.
- 2 It compares current and renewal plans and flags premium jumps and discontinued plans.
- 3 Clients who need a review get a drafted email and text with a booking link; small changes get a check-in note.
- 4 Anyone who has not replied in three days goes on the broker call list.
Tech stack
Project planner
How we would set it up for your agency
How we would set it up for your agency
Typical time to launch: about 2 weeks, then support
-
01
Discovery
1 to 2 days
Where renewal data comes from and your compliance rules for outreach.
-
02
Design
1 to 2 days
Thresholds for a review call, wording and booking link.
-
03
Build
About 1 week
Connect your CRM or sheet, email and SMS.
-
04
Test
3 to 5 days
Dry run on real renewals with sending switched off.
-
05
Launch
1 day
Switch on at the start of the enrollment window.
-
06
Support
Ongoing
Adjust thresholds as renewal data arrives.
Results
Results, only what you can check.
Free template, ready to import
12 nodes, runs on demo renewals first.
Agents stay in charge
Licensed agents review every plan with the client; the workflow drafts and organizes.
No invented metrics: we do not publish traffic, revenue or user numbers we cannot show you.
The n8n workflow from our video: it checks every 2027 renewal each morning, flags premium jumps and discontinued plans, drafts a personal email and text with a booking link before the December 15 deadline, logs every contact and builds your daily call list. Your licensed agents still review every plan with the client.
Services used in this project
Free 20-minute call
Want something like this for your business?
Book a free 20-minute call. We will look at how the work runs today, tell you honestly whether it is worth building and give you a fixed quote if it is.
More case studies
All workBookMySpot
BookMySpot helps players find courts, pitches and sports venues near them across the United States and the United Kingdom, then contact the venue directly. It is our own...
Read the case studyMakeItFlow Chrome Extension
The MakeItFlow extension grades the security headers of every page you visit, flags mixed content, insecure forms and third-party trackers, and shows a short corner alert...
Read the case studyMake It Flow Platform
makeitflow.si is our own platform and the site you are on. It runs website audits across speed, SEO, security, email and DNS, offers more than 150 free tools, serves indu...
Read the case study