Track Employee Certifications and Training Expiry Dates
Forty employees, eleven kinds of certificate, all renewing on their own schedules. The tracking spreadsheet was accurate the day it was made, which was fourteen months ago.
The short answer
A certificate carries its own expiry date on its face, so the tracking information does not need re-keying — it needs reading. A workflow uses the Read Details from File step to pull the employee, the certificate type and the expiry date off each document, the Rename step to write that date into the filename, and the Move step to file it under the person. The On a Schedule trigger then runs across the folders, and the Ask AI About the File and Send a Message steps report what expires in the next sixty days.
Steps this uses
Before and after
What actually changes
As they arrive
- cert.pdf
- first aid.pdf
- Scan_0512.pdf
- training certificate.pdf
After the workflow
- Okafor, D/2027-04-30-first-aid-certificate.pdf
- Okafor, D/2026-11-15-forklift-licence.pdf
- Reyes, M/2027-01-20-food-hygiene-level-2.pdf
- Reyes, M/2026-10-02-manual-handling.pdf
Four certificates for two employees, filed under each person and named by the date each one runs out.
Setting it up
Described once, then it runs
This is the sentence. Send it to the builder and the steps below appear on a canvas, wired and named, for you to change before anything runs.
When a certificate or training record arrives, read the employee, the certificate type and the expiry date off it, put the expiry date at the front of the filename, and file it under that person. Email me monthly about what expires within sixty days.
File under the person, not the certificate type
Questions are asked about people — is this employee current, can they work this shift. A folder per certificate type answers a question nobody asks and scatters one person across eleven folders.
Put the expiry date in the filename
The Rename step writes it, so an employee folder is readable from the list view. The latest date for a given certificate type is the live one, which makes superseded copies harmless to keep.
Let the renewal supersede
A renewed certificate does not replace the old file, it joins it with a later date. Keeping the history is useful and costs nothing once the dates are in the names.
Check weekly, report sixty days out
The On a Schedule trigger runs over the folders and Send a Message reports what is approaching. Sixty days is usually enough to book training; thirty often is not.
Why the spreadsheet always drifts
A certification tracker is a copy of information printed on documents. Every renewal is a chance for the copy and the certificate to disagree, and they disagree silently — nothing breaks, the spreadsheet just becomes wrong. Reading the date off the document removes the copy entirely, and the folder becomes the tracker rather than a description of one that somebody has to maintain.
Expired and missing are different problems
An expiring certificate produces a reminder because there is a document to read. An employee who was never certified at all produces nothing, and that is the more serious gap. A scheduled check finds the first; the second needs a comparison against your own list of who is required to hold what, which is a roster question rather than a document one.
What it does not do
It tracks documents and reports dates. It does not book training, verify that a certificate is genuine, or know which roles require which certifications. The requirement matrix comes from you. What this removes is the failure mode where the requirement was known, the certificate lapsed, and nobody noticed until an audit or an incident.
FAQ
Common questions
How do you track employee certification expiry?
File each certificate under the employee with the expiry date written into the filename, then check the folders on a schedule for anything expiring in the next sixty days. Reading the date off the certificate rather than copying it into a spreadsheet is what keeps the tracker from drifting out of date.
Should certificates be filed by person or by certificate type?
By person. The questions asked are about individuals — is this employee current, can they cover this shift. Filing by certificate type scatters one person's record across many folders and answers a question that rarely comes up.
Will it tell me about someone who was never certified?
No, not from documents alone, because there is nothing to read. That gap has to come from comparing your list of who is required to hold a certification against what is on file. The scheduled check covers what you hold; the requirement matrix covers what you should.
Can expiry dates be read from a scanned certificate?
Yes. Scanned and photographed certificates are read with OCR, so the date comes off the page rather than the filename. This matters because certificates very often arrive as a photo or a scan rather than a clean PDF from the training provider.
The folder is the tracker.
Expiry dates read off the certificates, not copied into a spreadsheet.
5 GB free · No credit card required