All templates
For roll-off dumpster rental companies, waste haulers & fleet managers

Track driver and vehicle certification expiry dates

Every Monday, WebRun reads driver and vehicle certification records from Google Sheets, cross-references active assignments in Starlight Software, and posts a Slack alert listing every CDL, registration, or permit expiring within 60 days so your fleet stays compliant without a manual calendar check.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
Every Monday at 7:30 AM WebRun
1 Google Sheets read driver and vehicle certification records
2 Starlight Software confirm which drivers and vehicles are active
3 Slack alert the team to upcoming expiries
Run a sample
In short

How can I automatically track driver and vehicle certification expiry dates for my dumpster rental fleet?

Every Monday, WebRun reads driver CDL, vehicle registration, and permit expiry dates from a Google Sheet, confirms which drivers and vehicles are active in Starlight Software, and posts a sorted Slack alert listing everything expiring within 60 days. Your compliance team sees the full picture before any certificate lapses.

  • Certifications expiring within 60 days surface every Monday with days remaining
  • Only active drivers and vehicles in Starlight appear on the expiry list
  • Compliance team never has to manually scan a spreadsheet for upcoming renewals

Built for roll-off dumpster rental companies · waste haulers · fleet managers · dumpster rental compliance officers

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 docs.google.com/spreadsheets in a real browser with your saved login - no setup, no API keys.

  2. 1
    Google Sheets - read driver and vehicle certification records
    google.com How to Automate Google Sheets
    WebRun in Google Sheets: read driver and vehicle certification records
    WebRun opens Google Sheets to read driver and vehicle certification records.
    • Open the certification tracking Google Sheet
    • Read every row: driver name, CDL expiry date, vehicle, registration expiry date, and permit expiry dates
    • Calculate days until expiry for each record and flag those within 60 days

    Done when All certification records are read and records expiring within 60 days are flagged.

  3. 2
    Starlight Software - confirm which drivers and vehicles are active
    starlightsoftwaresolutions.com How to Automate Starlight Software
    WebRun in Starlight Software: confirm which drivers and vehicles are active
    WebRun opens Starlight Software to confirm which drivers and vehicles are active.
    • Open Starlight Software and check the driver and vehicle roster
    • Confirm which drivers and vehicles are currently active and assigned to routes
    • Exclude any driver or vehicle that is inactive or removed from service

    Done when The expiry list is filtered to only active drivers and vehicles in current rotation.

  4. 3
    Slack - alert the team to upcoming expiries
    slack.com How to Automate Slack
    WebRun in Slack: alert the team to upcoming expiries
    WebRun opens Slack to alert the team to upcoming expiries.
    • Post a structured alert to the compliance Slack channel listing each expiring certification
    • Sort by days remaining, with the most urgent items first
    • Include the driver name, certification type, expiry date, and days remaining for each item

    Done when The compliance team has a Slack alert listing all certifications expiring within 60 days, sorted by urgency.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
docs.google.com/spreadsheets
ScheduleRuns automatically on this cadence
Every Monday at 7:30 AM
DeliveryHow each run's result reaches you
Expiry alert · Slack
OutputWhat each run produces - A Slack alert listing every driver CDL, vehicle registration, and permit expiring within 60 days, sorted by urgency.
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

Does it file renewals or contact licensing agencies?

No. WebRun only posts an internal Slack alert so your team knows what needs renewing. All renewal submissions are handled by your team.

What if we update an expiry date after the alert goes out?

Update the expiry date in the Google Sheet and the next Monday run will reflect the corrected date automatically. Historical Slack alerts are not edited.

Can it track permits and DOT numbers too?

Yes. Add columns to the tracking Google Sheet for any certification type and WebRun will include them in the expiry check. The sheet structure is yours to define.

Put this on autopilot.

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