All templates
For dangerous goods compliance managers, hazmat shipping coordinators & freight procurement teams

Stay ahead of hazmat carrier insurance certificate expiries

Every Monday, WebRun reviews your approved DG carrier list in Google Sheets against Labelmaster compliance records, flags any carrier whose insurance certificate or hazmat authority expires within 30 days, drafts renewal request emails for your review, and adds expiry milestones to Google Calendar.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
Every Monday at 8:00 AM WebRun
1 Labelmaster check carrier compliance and cert status
2 Google Sheets update approved carrier expiry tracker
3 Gmail draft renewal request for human review
4 Google Calendar add expiry reminder events
Run a sample
In short

How do I track hazmat carrier insurance certificate expiry dates automatically?

WebRun checks your Labelmaster carrier compliance records every Monday, flags any approved DG carrier whose insurance certificate or hazmat authority expires within 30 days, updates your Google Sheets tracker, drafts renewal request emails for human approval, and adds expiry milestones to Google Calendar so nothing slips past your compliance window.

  • No approved DG carrier slips past its certificate expiry undetected
  • Renewal requests drafted and ready for approval 30 days before expiry
  • Expiry calendar keeps the compliance team on track without manual follow-up

Built for dangerous goods compliance managers · hazmat shipping coordinators · freight procurement teams · logistics 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 www.labelmaster.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Labelmaster - check carrier compliance and cert status
    labelmaster.com How to Automate Labelmaster
    WebRun in Labelmaster: check carrier compliance and cert status
    WebRun opens Labelmaster to check carrier compliance and cert status.
    • Open Labelmaster and review carrier compliance records for each approved DG carrier
    • Note the expiry date of each carrier's insurance certificate, hazmat authority, and operating permits
    • Flag carriers expiring within 30 days and those already expired

    Done when Every carrier with a certificate expiring within 30 days is identified with its expiry date.

  3. 2
    Google Sheets - update approved carrier expiry tracker
    google.com How to Automate Google Sheets
    WebRun in Google Sheets: update approved carrier expiry tracker
    WebRun opens Google Sheets to update approved carrier expiry tracker.
    • Open the Approved Carrier Expiry Tracker sheet
    • Update the expiry date and status column for each carrier reviewed today
    • Color-code rows: red for expired, amber for expiring within 7 days, yellow for within 30 days

    Done when Tracker sheet shows current expiry status for all approved DG carriers.

  4. 3
    Gmail - draft renewal request for human review
    gmail.com How to Automate Gmail
    WebRun in Gmail: draft renewal request for human review
    WebRun opens Gmail to draft renewal request for human review.
    • Draft a renewal request email to each carrier expiring within 30 days
    • Include the certificate type, current expiry date, and your required renewal deadline
    • Leave all drafts unsent for your compliance manager to review and send

    Done when Renewal request drafts are queued in Gmail for every at-risk carrier, awaiting human approval.

  5. 4
    Google Calendar - add expiry reminder events
    calendar.google.com How to Automate Google Calendar
    WebRun in Google Calendar: add expiry reminder events
    WebRun opens Google Calendar to add expiry reminder events.
    • Add a calendar event 7 days before each carrier's certificate expiry date
    • Title each event with the carrier name and certificate type
    • Invite the compliance manager so the deadline is visible on their calendar

    Done when Expiry reminder events are on the compliance calendar for all carriers flagged this week.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.labelmaster.com
ScheduleRuns automatically on this cadence
Every Monday at 8:00 AM
DeliveryHow each run's result reaches you
Expiry tracker · Google Sheets
OutputWhat each run produces - An updated carrier expiry tracker in Google Sheets, renewal request drafts in Gmail for approval, and calendar reminders for upcoming certificate expirations.
Spreadsheet
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

Will it send the renewal requests to carriers without my approval?

No. Every renewal request is drafted in Gmail and left unsent. Your compliance manager reviews and approves each one before it goes to any carrier.

What certificate types does it track?

It tracks any certificate recorded in your Labelmaster compliance records and your Google Sheet, including insurance certificates, hazmat authority documents, and operating permits.

What happens if a carrier's certificate has already lapsed?

Lapsed carriers are flagged in red in the tracker sheet and appear at the top of the weekly list so your team can act immediately, including suspending that carrier from active loads.

Put this on autopilot.

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