Automation: Build an Enrollment Season Email Sequence

What This Builds

Instead of manually sending enrollment reminder emails to hundreds of families at key points in the re-enrollment season, you'll build a Zapier automation that monitors your enrollment data and triggers personalized email sequences automatically, so the right family gets the right message at the right time, without you touching it.

Prerequisites

• A Zapier account: the free tier allows 2 automations (Zaps), and a paid plan ($20/month) is needed for more
• Google Sheets with your re-enrollment tracking data (or ability to export from FACTS/PowerSchool to Sheets)
• Gmail or Google Workspace account for sending
• ChatGPT to write and refine the email templates (one-time setup)
• 2-3 hours for initial build

The Concept

A Zapier automation is like a rule sheet for your email system: "When [X happens in Google Sheets], send [Y email] to [Z person]." You write the templates once using AI, then the automation runs itself throughout re-enrollment season.

Think of it as programming your assistant to send follow-ups while you're focused on actually talking with families, not chasing down the ones who haven't clicked "re-enroll" yet.

Build It Step by Step

Part 1: Write Your Email Templates with ChatGPT

Before touching Zapier, write your email templates. Open ChatGPT and request:

I'm a private [school type] administrator preparing for re-enrollment season. Write 4 emails for a re-enrollment reminder sequence:

Email 1 (Announcement - Day 0): Announce that re-enrollment is now open for [school year]. Warm, excited tone. Include deadline [DATE] and how to re-enroll [brief steps].

Email 2 (Friendly Reminder - Day 14): Gentle reminder that the deadline is in 2 weeks. Emphasize the benefits of early re-enrollment (schedule preference, community, etc.).

Email 3 (Deadline Approaching - Day 25): Urgent but still warm. Emphasize that [DATE] is the final deadline. Include brief FAQ about the process.

Email 4 (Last Chance - Day 30): Final notice. Clear, direct. State what happens if they miss the deadline (waitlist, no guarantee of spot). Still professional.

Format each email with: Subject Line, Body. Use placeholders: [FAMILY NAME], [STUDENT NAME], [SCHOOL NAME], [DEADLINE DATE], [RE-ENROLLMENT LINK].

Save the 4 email templates in a Google Doc.

Part 2: Set Up Your Google Sheet as the Trigger

Create or export a Google Sheet with these columns:

• Column A: Family Name
• Column B: Student Name
• Column C: Student Email (for personalization)
• Column D: Parent Email
• Column E: Enrollment Status (Pending / Submitted / Withdrawn)
• Column F: Re-enrollment Open Date
• Column G: Sequence Step (leave blank, since Zapier will populate this)

Populate rows with all families who need re-enrollment reminders. Update Column E as families submit.

Part 3: Create Your Zapier Account and First Zap

1. Go to zapier.com and create a free account (use your school email)
2. Click Create Zap
3. Trigger: Search for "Google Sheets" → choose New or Updated Row in Google Sheets
4. Connect your Google account → select your re-enrollment spreadsheet
5. Set the trigger: "When Column E = Pending AND today = [enrollment open date]"

What you should see: Zapier confirms it can read your spreadsheet and shows a sample row.

Part 4: Set Up the Email Action

1. Click + Add Action → search "Gmail" → choose Send Email
2. Connect your Gmail/Google Workspace account
3. In the To field, select the "Parent Email" column from your spreadsheet (dynamic field)
4. In Subject, type your Email 1 subject line, inserting the Family Name dynamic field: "Re-enrollment is now open, [Family Name]!"
5. In Body, paste your Email 1 template. Replace placeholder text with dynamic fields from your spreadsheet wherever you used [FAMILY NAME] and [STUDENT NAME]
6. Click Test to send a test email to yourself

Part 5: Build the Reminder Steps

For a full 4-email sequence, you'll need 4 Zaps (one per email) or a Zapier "multi-step Zap" (paid plan). Each Zap triggers on a different condition:

• Zap 1: Status = Pending AND enrollment open date = today → send Email 1
• Zap 2: Status = Pending AND enrollment open date + 14 days = today → send Email 2
• Zap 3: Status = Pending AND enrollment open date + 25 days = today → send Email 3
• Zap 4: Status = Pending AND enrollment open date + 30 days = today → send Email 4

Important: Add a condition to each Zap: "Only send IF Column E = Pending" to prevent families who already re-enrolled from receiving reminder emails.

Part 6: Test the Complete Flow

Before going live:

1. Add yourself (with a test row) to the spreadsheet with Status = Pending
2. Manually trigger the Zap
3. Verify the email arrives correctly with your name and student name populated
4. Check the email reads naturally, since dynamic field insertions can sometimes create awkward capitalization

Real Example: Enrollment Season at St. Andrew's

Setup: 280 families. Re-enrollment opens February 1 with a March 2 deadline.

Week of January 28: Administrator runs ChatGPT prompts to generate all 4 email templates, reviews and adjusts tone. Uploads 280 family rows to Google Sheets. Builds 4 Zaps.

February 1: All 280 families receive Email 1 automatically. February 15: 180 families have submitted. 100 still have Status = Pending. Only those 100 receive Email 2. February 26: 50 families still pending. Only those 50 receive Email 3. March 2: 20 families still pending. They receive the final notice.

Result: Administrator spent 3 hours building the system, then it ran itself. In prior years, manually tracking and sending these emails took 6-8 hours across the season, plus families were missed.

What to Do When It Breaks

• Families who re-enrolled still get reminders → Check your Zap condition and make sure "Only continue if Column E = Pending" is active; update status to "Submitted" promptly when families enroll
• Dynamic fields show [FAMILY NAME] instead of actual names → In Zapier, you need to map the spreadsheet column to the email field using the dynamic field selector (click the blue "+" icon in the email field)
• Zapier says "Zap is paused" or hits free plan limits → Free Zapier limits 100 tasks/month; for 280 families × 4 emails, you need the Starter plan (~$20/month); only needed during enrollment season
• Emails land in spam → Use your Google Workspace domain email (not a personal Gmail) for sending; add a plain-text footer with your school's physical address (required for CAN-SPAM compliance)

Variations

• Simpler version: Skip Zapier entirely and use ChatGPT to write the templates once, then use Gmail's "Schedule Send" feature to manually batch-send each email at the right time (still saves significant writing time)
• Extended version: Add a fifth Zap that sends a "Welcome back!" confirmation email automatically when a family updates their row to "Submitted"

What to Do Next

• This week: Write your email templates in ChatGPT and save them, since this alone is worth doing even if you don't build the automation
• This month: Set up the Google Sheet structure and test one Zap before enrollment season starts
• Advanced: Add a Zapier Zap that updates a "days since last contact" counter in your sheet so you can identify families who need a personal phone call rather than another automated email

Advanced guide for school administrator professionals. Zapier paid plan required for full sequence ($20/month). Tool interfaces may change.