All templates

Automated Auto Salvage Certification Expiry Tracker

Every Monday, WebRun reads your certification and licence expiry dates from a Google Sheet, calculates days remaining for each credential, cross-references any Car-Part.com membership or programme dates, and posts a prioritised renewal list to your Telegram channel so your compliance team can act before anything lapses.

Runs on WebRun · Strict Lockdown policy
Every Monday at 8:00 AM WebRunorchestrates each step
1 Google Sheets read certification and licence expiry dates
2 Car-Part.com check Car-Part.com membership and programme renewal dates
3 Telegram post prioritised renewal list to compliance channel
In short

How can I automatically track salvage yard certification and licence expiry dates?

WebRun reads your salvage yard certifications and licences from a Google Sheet every Monday, checks Car-Part.com for programme renewal dates, and posts a prioritised list to your Telegram compliance channel. Credentials expiring within 30 days are marked urgent so your team renews in time, every time.

  • No licence or permit lapses because every expiry is flagged 60 days in advance
  • Urgent renewals within 30 days are highlighted automatically for immediate action
  • Compliance team spends minutes reviewing the list instead of manually checking dates

Built for auto salvage yards · recycler compliance teams · yard managers · salvage yard owners

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 certification and licence expiry dates
    google.com
    WebRun in Google Sheets: read certification and licence expiry dates
    WebRun opens Google Sheets to read certification and licence expiry dates.
    • Open the certification tracker sheet and read every row with an expiry date
    • Calculate days remaining from today for each credential: state recycler licence, EPA permits, ARA membership, and any others
    • Flag credentials expiring within 60 days as high priority and within 30 days as urgent

    Done when Every credential has a days-remaining count and a priority flag.

  3. 2
    Car-Part.com - check Car-Part.com membership and programme renewal dates
    car-part.com
    WebRun in Car-Part.com: check Car-Part.com membership and programme renewal dates
    WebRun opens Car-Part.com to check Car-Part.com membership and programme renewal dates.
    • Check the Car-Part.com account page for any programme or membership renewal dates
    • Note any listing or data service subscription expiry that would affect yard listings
    • Add these to the expiry list alongside the state and EPA credentials

    Done when Car-Part.com programme and subscription expiry dates have been added to the consolidated list.

  4. 3
    Telegram - post prioritised renewal list to compliance channel
    telegram.org
    WebRun in Telegram: post prioritised renewal list to compliance channel
    WebRun opens Telegram to post prioritised renewal list to compliance channel.
    • Post the prioritised renewal list to the yard compliance Telegram channel
    • Show urgent items (30 days or fewer) at the top in bold
    • List the credential name, expiry date, days remaining, and renewal link or contact for each item

    Done when The compliance team has this week's renewal list in Telegram with urgent items clearly flagged.

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 8:00 AM
DeliveryHow each run's result reaches you
Renewal list · Telegram
OutputWhat each run produces - A Telegram message listing every credential expiring within 60 days, sorted by urgency, with expiry date, days remaining, and renewal guidance for each.
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 automatically renew any licences or memberships?

No. WebRun only posts the renewal list to your Telegram channel. All renewal actions are taken by your compliance team so you stay in full control of every submission.

Which certifications can it track?

Any credential you log in the Google Sheet with an expiry date: state recycler licences, EPA permits, ARA or state association memberships, Car-Part.com subscriptions, and any other dated credential your yard holds.

How early does it warn before expiry?

It flags credentials expiring within 60 days each Monday, and marks those within 30 days as urgent so your team has plenty of time to act without rushing.

Put this on autopilot.

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