Automated EV Technician Certification Expiry Tracking
Every Monday, WebRun scans your technician certification tracker in Google Sheets, identifies qualifications expiring within 60 days, checks AMPECO to see which technicians have jobs scheduled in that window, and posts a prioritised Slack alert to your ops manager so renewals can be booked before anyone is deployed uncertified.
How can I automatically track and flag expiring technician certifications for my EV charging network?
WebRun scans your technician certification tracker in Google Sheets every Monday, finds qualifications expiring within 60 days, checks AMPECO for overlapping scheduled maintenance jobs, and posts a prioritised Slack alert to your ops manager. Urgent cases where a job is booked beyond a technician's expiry date are surfaced at the top.
- Expired certifications never block a scheduled maintenance job again
- Ops manager gets a prioritised alert every Monday before conflicts become last-minute problems
- 60-day warning window gives enough lead time to book renewal training without disruption
Built for EV charging ops managers · charge point operators · field service teams · EV network compliance officers
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
docs.google.com/spreadsheetsin a real browser with your saved login - no setup, no API keys. -
1
Google Sheets - scan certification expiry dates
google.com
WebRun opens Google Sheets to scan certification expiry dates. - Open the technician certification tracker sheet
- Filter for rows where the expiry date is within 60 days of today
- Capture technician name, certification type, expiry date, and days remaining for each
Done when Every technician with a certification expiring within 60 days has been listed.
-
2
AMPECO - check scheduled job assignments
ampeco.com
WebRun opens AMPECO to check scheduled job assignments. - Search AMPECO for maintenance jobs scheduled within the expiry window for each flagged technician
- Confirm whether the technician is assigned to any upcoming site visits during or after their expiry date
- Flag technicians with jobs scheduled beyond their certification expiry as urgent
Done when Each expiring technician has been checked for overlapping scheduled jobs in AMPECO.
-
3
Slack - alert ops manager with priority list
slack.com
WebRun opens Slack to alert ops manager with priority list. - Post a prioritised alert to the ops manager's Slack channel
- Lead with urgent cases where a scheduled job falls after the certification expiry date
- List all other expiring certifications below in order of days remaining
Done when The ops manager has a prioritised Slack alert with every expiring certification and any scheduling conflicts.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Does it automatically remove the technician from scheduled jobs if their certification lapses?
No. WebRun flags the conflict in Slack for your ops manager to action. Removing or reassigning jobs is a human decision and is never done automatically.
Can I adjust the 60-day warning window?
Yes. The warning threshold is a configurable setting you set at setup. You can change it in your Google Sheets config tab and the change takes effect on the next Monday run.
What certifications does it track?
It tracks whatever certification types and expiry dates are in your Google Sheets tracker. Common examples include EV installation, 18th edition wiring regulations, and first aid, but the list is fully customisable.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.