Automated CE Tracking: Never Miss Your Recertification Deadline

What This Builds

Instead of manually checking how many CE credits you've earned and hoping you don't hit your NREMT recertification deadline with a gap, this automation tracks your credits automatically: logs completions, calculates your running total, and emails you a progress report every month. You set it up once and it runs in the background until your next recertification.

When your credits from a CE platform like NAEMT Online, EMS1, or FISDAP land in your Gmail inbox as completion certificates, Zapier detects them, logs the hours and topic to a Google Sheet, and updates your totals. A monthly summary email keeps you informed without having to check.

Prerequisites

• A free Zapier account (zapier.com)
• A Google account (for Sheets and Gmail)
• Your CE platform sends completion confirmations to your Gmail (NAEMT Online, EMS1, and FISDAP all do this)
• Basic comfort navigating web apps — no coding required
• Account/subscription needed: Zapier free tier (1 Zap, 100 tasks/month) may be sufficient; Zapier Starter ($20/month) for multiple Zaps

The Concept

Think of Zapier as a relay runner: when something happens in App A (a CE completion email arrives in Gmail), Zapier automatically does something in App B (logs it to a Google Sheet). You define the baton pass once — then it runs every time without you touching it.

Your Google Sheet becomes a live CE ledger: every course logged with date, hours, topic, and NCCP component (national/local/individual). A Google Sheets formula calculates your running totals. A monthly Zapier email tells you where you stand.

Build It Step by Step

Part 1: Set Up Your CE Tracking Google Sheet

Step 1: Go to sheets.google.com and create a new spreadsheet. Name it "EMS CE Tracker — [Your Name] — Recertification [Year]."

Step 2: Create these column headers in Row 1:

• A: Date Completed
• B: Course Name
• C: CE Hours
• D: NCCP Component (National / Local / Individual)
• E: Provider (NAEMT, EMS1, FISDAP, Agency, etc.)
• F: Source (email / manual entry)

Step 3: In a separate section (Row 1, columns H–L), create a summary:

• H1: "Total CE Hours:" | I1: =SUM(C2:C1000)
• H2: "National NCCP Credits:" | I2: =SUMIF(D2:D1000,"National",C2:C1000)
• H3: "Local/State Credits:" | I3: =SUMIF(D2:D1000,"Local",C2:C1000)
• H4: "Individual Credits:" | I4: =SUMIF(D2:D1000,"Individual",C2:C1000)
• H5: "Remaining to 60 hours:" | I5: =60-I1
• H6: "Recertification Date:" | I6: [type your actual date]

Step 4: Enter any CE credits you've already completed manually into the rows below the headers. This gives you a starting baseline.

Part 2: Build the Zapier Automation

Step 1: Go to zapier.com and create a free account if you don't have one.

Step 2: Click "Create Zap" to start a new automation.

Step 3: Set the Trigger — Gmail detects a CE completion email

• Search for "Gmail" as your trigger app
• Choose trigger event: "New Email Matching Search"
• Connect your Google account
• In the Search field, enter: subject:"certificate" OR subject:"completion" OR subject:"CE credit" from:naemt.org (adjust for your CE provider's email domain)
• Test the trigger — Zapier will pull your recent matching emails to confirm it's working

Step 4: Set the Action — Log to Google Sheets

• Search for "Google Sheets" as your action app
• Choose action: "Create Spreadsheet Row"
• Connect your Google account
• Select your "EMS CE Tracker" spreadsheet and the main data sheet
• Map the fields:

  • Date Completed → From Trigger: Email Date
  • Course Name → From Trigger: Email Subject (or Body — test which contains the course name)
  • CE Hours → This is harder to automate (email format varies) — you can either: (a) map a placeholder "0" and update manually, or (b) use Zapier's Formatter tool to try to extract a number from the email body
  • NCCP Component → Enter "National" as a static value (or "Individual" — you'll correct as needed)
  • Provider → From Trigger: Email From Address
  • Source → Enter "email" as static text

Step 5: Test the Zap Click "Test" and check that a new row appears in your Google Sheet. Verify the data mapped correctly.

Step 6: Turn on the Zap Click "Publish Zap." From now on, every matching CE email triggers a new row entry automatically.

Part 3: Add a Monthly Summary Email to Yourself

Step 1: Create a second Zap (requires Zapier Starter or higher, OR you can do this manually with a free tool):

Free alternative — use Google Sheets' built-in email notification:

• In your Google Sheet, go to Tools → Notification Rules
• Set to notify you "When changes are made" → "Daily digest" → your email
• This sends a daily email showing any new entries — a simpler version of the monthly summary

Zapier approach (Starter tier):

• Trigger: "Schedule" → Monthly → First day of each month
• Action: Gmail "Send Email" → To yourself
• Body: Manually write a static reminder template — Zapier's free tier won't pull live Sheet data, but it will remind you to check your Sheet

Step 2: Set your Google Sheet summary section to always show your current standing — this is the real dashboard. The email is just a nudge to look at it.

Real Example: Full Workflow in Action

Setup: You've configured the Zap and entered your baseline (12 credits from agency skills days entered manually).

Trigger: You complete a 2-hour NAEMT online course on "EMS Response to Behavioral Emergencies." NAEMT emails you a completion certificate.

What happens automatically:

• Zapier detects the email (matches "certificate" + from naemt.org)
• New row added to your Google Sheet: "2026-03-19 | EMS Response to Behavioral Emergencies | [hours pending manual entry] | National | NAEMT | email"

What you do: Open the Sheet, see the new row, enter "2" in the CE Hours column, and change NCCP Component to "National."

What you see immediately in the summary: Total CE Hours: 14 | National NCCP: 12 | Remaining to 60: 46.

Time saved: Instead of manually hunting through old emails to reconstruct your CE history at recertification time, everything is logged chronologically in one place.

Time saved: 2–3 hours per recertification cycle spent reconstructing CE history eliminated.

What to Do When It Breaks

Zap stops triggering (common)

• Check Zapier's task history — it shows why each Zap ran or didn't
• CE provider may have changed their email format; update the search filter
• Your Gmail filters may be catching completion emails before Zapier sees them — check Gmail filters

Google Sheets rows appear but data is wrong

• Open the Zap editor and re-map fields; CE email formats vary significantly between providers
• For problematic providers, log entries manually — the Sheet structure is still valuable even without full automation

CE provider doesn't email certificates

• NREMT's registry portal doesn't send automatic emails for every CE completion; log these manually when you check your NREMT account (do this quarterly, not annually)
• Some state-required local CE hours are completed in person; log these manually with the date and topic

Variations

Simpler version: Skip Zapier entirely. Just maintain the Google Sheet manually. Add a row every time you complete a CE activity. The formulas do all the math. Set a monthly phone calendar reminder to check your totals. This takes 5 minutes per month and eliminates 90% of the recertification deadline stress.

Extended version: Add a second sheet tab that breaks down National NCCP topic requirements vs. what you've covered — cross-referencing the NREMT's mandated topic list. Then use ChatGPT to analyze your gaps: "I've completed these CE topics this cycle [paste list]. What NCCP national component topics am I still missing based on the 2024-2026 NREMT requirements?"

What to Do Next

• This week: Build the Google Sheet and enter all your current CE credits; that alone solves 80% of the problem
• This month: Set up the basic Zapier Zap for your primary CE provider
• Advanced: Add all CE providers as separate Zap triggers; build out the NCCP topic tracking tab

Advanced guide for EMT and Paramedic professionals. Zapier features and pricing change — verify current plans at zapier.com. Google Sheets functions referenced here use standard spreadsheet formula syntax.