All templates

iClassPro Automated Coach Certification Expiry Tracking

Every Monday, WebRun checks coach and staff certification expiry dates stored in iClassPro and a Google Sheet tracking log, identifies anyone whose CPR, USA Gymnastics, or SafeSport credential expires within 60 days, and posts a prioritized alert to Slack so the gym director can act before a deadline is missed.

Runs on WebRun · Strict Lockdown policy
Every Monday at 8:00 AM WebRunorchestrates each step
1 iClassPro read staff certification records
2 Google Sheets cross-check expiry dates in tracking log
3 Slack post certification expiry alerts
In short

How do I automatically track gymnastics coach certification expiry dates?

WebRun checks iClassPro and a Google Sheet certification log every Monday, flags any coach or staff member whose CPR, USA Gymnastics, or SafeSport credential expires within 60 days, and posts a ranked Slack alert to the gym director. Red items expiring within 30 days are listed first so renewals are never missed.

  • Expiring certifications are caught 60 days out, not the day after they lapse
  • The gym director gets a ranked weekly alert with days remaining per credential
  • Coach renewal outreach is always handled by a human, never automated

Built for gymnastics gym directors · studio compliance managers · cheer and tumbling gym owners · youth sports program administrators

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens app.iclasspro.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    iClassPro - read staff certification records
    iclasspro.com
    WebRun in iClassPro: read staff certification records
    WebRun opens iClassPro to read staff certification records.
    • Open iClassPro and navigate to the Staff section
    • Read each staff member's certification records and expiry dates on file
    • Capture name, role, certification type, and expiry date for each credential

    Done when All staff certification records are read with their current expiry dates.

  3. 2
    Google Sheets - cross-check expiry dates in tracking log
    google.com
    WebRun in Google Sheets: cross-check expiry dates in tracking log
    WebRun opens Google Sheets to cross-check expiry dates in tracking log.
    • Compare the iClassPro records against the certification tracking sheet to fill any gaps
    • Flag any certification expiring within 60 days as orange and any expiring within 30 days as red
    • Update the last-checked date for each record

    Done when The certification log is updated and all near-expiry credentials are flagged by color.

  4. 3
    Slack - post certification expiry alerts
    slack.com
    WebRun in Slack: post certification expiry alerts
    WebRun opens Slack to post certification expiry alerts.
    • Post a weekly certification status alert to the gym-director Slack channel
    • List certifications expiring within 30 days first, then within 31 to 60 days
    • Include each staff member's name, credential type, and days remaining

    Done when The gym director has this week's certification expiry alert in Slack.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.iclasspro.com
ScheduleRuns automatically on this cadence
Every Monday at 8:00 AM
DeliveryHow each run's result reaches you
Expiry alert · Slack
OutputWhat each run produces - A Slack certification expiry alert ranked by urgency plus an updated Google Sheet log showing each credential's days remaining.
Text
Setup & safety

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.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Which certifications does it track?

It tracks any certification recorded in iClassPro or your Google Sheet log, including CPR, USA Gymnastics professional membership, SafeSport training, and any custom credentials your gym requires.

Does it contact coaches directly about their expiring certification?

No. WebRun posts the alert to the gym director's Slack channel only. Any direct communication to a coach about renewal is left to the director to handle personally.

What if a coach renews their certification mid-week?

On the next Monday run WebRun reads the updated expiry date from iClassPro or the tracking sheet and the coach will drop off the expiry list automatically.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.