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, whichever contains the course name)
• CE Hours → This is harder to automate (email format varies). You can either map a placeholder "0" and update manually, or 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," which you can 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, which 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 your 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.