Zapier Automation: Never Miss an IEP Deadline Again

What This Builds

Instead of manually checking your IEP deadline tracker spreadsheet every Monday, this automation watches it for you. When any student's IEP annual review is within 30 days, Zapier automatically sends you a reminder email with the student's code name, the deadline date, and a checklist of what to do next. Set it up once — it runs every week forever.

Prerequisites

• IEP caseload tracker spreadsheet in Google Sheets (from Level 2 guide, or create a new one)
• A free Zapier account at zapier.com (free tier allows 5 Zaps — enough for this)
• Gmail access (the reminders will send to your Gmail)
• About 1 hour to build and test the automation

The Concept

Think of Zapier as a watchful assistant who checks your spreadsheet every morning and sends you a note when something needs attention. You write the rules once ("tell me when any deadline is within 30 days") and Zapier enforces them automatically — even when you forget to look.

Technically: Zapier connects two apps (Google Sheets and Gmail) with a rule — "when [trigger happens in Sheets], do [action in Gmail]." There's no coding involved.

Build It Step by Step

Part 1: Set up your Google Sheets deadline tracker

If you already have the tracker from the Level 2 guide, confirm it has these columns:

• Column A: Student Code (Student 1, Student 2...)
• Column B: Grade
• Column C: Disability Category
• Column D: IEP Start Date (MM/DD/YYYY format)
• Column E: Annual Review Due Date (calculated: =DATE(YEAR(D2)+1,MONTH(D2),DAY(D2)))
• Column F: Re-Evaluation Due Date (calculated: =DATE(YEAR(D2)+3,MONTH(D2),DAY(D2)))
• Column G: Days Until Annual Review (=E2-TODAY())

Make sure all rows are filled out for your current caseload and that column E (Annual Review Due) is correct for all students.

Part 2: Create a Zapier account

1. Go to zapier.com and click Sign up free
2. Enter your email and create a password
3. You'll reach the Zapier dashboard — click Create Zap or + New Zap

What you should see: A two-part builder — "Trigger" on the left (what starts the automation) and "Action" on the right (what happens when it's triggered).

Part 3: Set up the Trigger (Google Sheets → check for upcoming deadlines)

Since Zapier's Google Sheets integration works best with new or updated rows, we'll use a slightly different approach: a scheduled trigger that checks the spreadsheet weekly.

1. In the Trigger section, search for "Schedule by Zapier" (it's a built-in Zapier trigger)
2. Select "Every Week"
3. Set it to run on Monday at 7:00 AM (so you get the reminder at the start of your work week)
4. Click Continue

This tells Zapier: "Every Monday morning, wake up and do something."

Part 4: Add a Google Sheets search step

Now we need Zapier to look in your spreadsheet for upcoming deadlines.

1. Click "+" to add a step after the Schedule trigger
2. Search for "Google Sheets" and select it
3. Choose "Lookup Spreadsheet Row" or "Get Many Spreadsheet Rows"
4. Click Sign in to connect your Google account and grant Zapier access to Google Sheets
5. Select your caseload tracker spreadsheet from the dropdown
6. Select your worksheet tab (usually "Sheet1")

Part 5: Set up a filter to only catch upcoming deadlines

1. After the Google Sheets step, click "+" and search for "Filter by Zapier" (a built-in tool)
2. Set the filter: "Days Until Annual Review" (column G) "(Number) less than" "31"

This means: only continue the automation if a student has an IEP due in 30 days or fewer.

What this does: Every Monday, Zapier wakes up, checks every row in your sheet, and only continues for rows where the deadline is coming up soon.

Part 6: Set up the Gmail email action

1. After the filter, click "+" and add "Gmail"
2. Choose "Send Email"
3. Connect your Gmail account if prompted
4. Fill in the email fields:

   • To: your school email address
   • Subject: IEP Deadline Alert: [Student Code] — Annual Review Due in [Days] days
   • Body:

IEP DEADLINE REMINDER

Student: [Student Code from column A]
Annual Review Due: [Date from column E]
Days Remaining: [Number from column G]
Grade: [Grade from column B]

CHECKLIST:
☐ Schedule IEP meeting (15 days before deadline minimum)
☐ Send parent notice (at least 10 days before meeting)
☐ Request input from general ed teacher
☐ Update present levels and draft goals
☐ Confirm all team members are available
☐ Prepare prior written notice if any changes proposed

Reply to this email if you've already addressed this or need to reschedule.

In Zapier, use the data fields (the "+" icon in the body editor) to insert the actual values from your spreadsheet — Student Code, Due Date, Days Remaining, Grade.

1. Click Continue and then Test the action

Part 7: Turn on your Zap and test it

1. Click Publish Zap to activate
2. To test without waiting until Monday: go back to the Trigger step and click Test Trigger — Zapier will run the automation right now
3. Check your email — you should receive a formatted IEP deadline reminder

What you should see in your email: A clean reminder with the student code, deadline date, days remaining, and your pre-written checklist. If a student's annual review is 27 days away, you'll get this email Monday morning.

Real Example: What It Looks Like in Your Inbox

It's Monday, February 3rd. You open Gmail and see:

Subject: IEP Deadline Alert: Student 14 — Annual Review Due in 18 days

IEP DEADLINE REMINDER

Student: Student 14
Annual Review Due: February 21, 2026
Days Remaining: 18
Grade: 4

CHECKLIST:
☐ Schedule IEP meeting (15 days before deadline minimum)
☐ Send parent notice (at least 10 days before meeting)
...

You didn't open your spreadsheet. You didn't remember to check. You got the reminder automatically.

Setup: 1 Google Sheet, 1 Zapier account, 1 hour of setup. Output: Weekly automated compliance monitoring for your entire caseload. Time saved: 10-15 minutes every Monday of manual spreadsheet checking — plus the peace of mind that eliminates the anxiety of forgetting.

What to Do When It Breaks

• Zapier sends reminders for all students every week → Your filter isn't working correctly. Check that column G is calculating correctly (=E2-TODAY()) and that the filter is checking a number value, not a date
• No emails are arriving → Check Gmail's spam folder. Also verify the Zap is turned "On" in your Zapier dashboard
• Wrong student data in the email → The Zapier data fields may be mapped to wrong columns — go back to the Gmail action step and remap the fields to the correct columns
• Zapier asks you to upgrade for multi-row checking → Free tier has limits. Upgrade to Starter ($20/month) or use the manual approach: sort column G monthly by "soonest deadline" and scan it yourself

Variations

• Simpler version: Skip Zapier entirely — instead, set up a Google Sheets conditional formatting rule that emails you (Google Sheets → Tools → Notification rules → "When any changes are made") — not as automated but works with free tools only
• Extended version: Add a second Zap for re-evaluation deadlines (column F) with a different email template and a 60-day warning window (re-evaluations need more lead time than annual reviews)

What to Do Next

• This week: Build the Google Sheets tracker if you haven't already, then set up the Zapier automation
• This month: Add the re-evaluation deadline Zap so both compliance timelines are automated
• Advanced: Connect your calendar — add a Zapier step that creates a Google Calendar event for each IEP meeting deadline, not just an email reminder

Advanced guide for special education teacher professionals. These techniques use more sophisticated AI features that may require paid subscriptions.