All templates
For air cargo compliance teams, freight forwarders & airline cargo operations

Stay ahead of carrier insurance certificate expiry dates

Every Monday, WebRun opens Awery, finds carriers with insurance certificates expiring within 30 days, drafts a renewal reminder to each carrier for your approval, and updates the compliance tracker in Google Sheets with the latest expiry dates.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
Every Monday at 9:00 AM WebRun
1 Awery find carriers with expiring insurance certs
2 Gmail draft renewal reminder to each carrier
3 Google Sheets update compliance expiry tracker
Run a sample
In short

How do I automatically track carrier insurance certificate expiry for air cargo?

WebRun opens Awery every Monday, finds every carrier with an insurance certificate expiring within 30 days, and drafts a renewal reminder to each carrier in Gmail for your compliance team to approve. The Google Sheets tracker is updated with expiry dates and draft status so nothing slips through unmanaged.

  • No carrier insurance certificate lapses unnoticed with weekly automated scanning
  • Renewal draft emails are ready for one-click approval every Monday morning
  • Google Sheets gives the compliance team a single source of truth for all expiry dates

Built for air cargo compliance teams · freight forwarders · airline cargo operations · ground handling managers

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 awery.aero in a real browser with your saved login - no setup, no API keys.

  2. 1
    Awery - find carriers with expiring insurance certs
    awery.aero How to Automate Awery
    WebRun in Awery: find carriers with expiring insurance certs
    WebRun opens Awery to find carriers with expiring insurance certs.
    • Open Awery and navigate to carrier and partner records
    • Filter carriers whose insurance certificate expiry date falls within the next 30 days
    • Capture carrier name, contact email, certificate type, and exact expiry date for each

    Done when Every carrier with an insurance cert expiring in 30 days is listed with contact and certificate details.

  3. 2
    Gmail - draft renewal reminder to each carrier
    gmail.com How to Automate Gmail
    WebRun in Gmail: draft renewal reminder to each carrier
    WebRun opens Gmail to draft renewal reminder to each carrier.
    • Draft a professional renewal reminder to each carrier with their certificate expiry date
    • Include your company name, the certificate type, and instructions for submitting the updated document
    • Save each draft unsent in Gmail Drafts for your compliance team to review and approve before sending

    Done when A Gmail draft reminder exists for every carrier with an expiring certificate, awaiting your approval.

  4. 3
    Google Sheets - update compliance expiry tracker
    google.com How to Automate Google Sheets
    WebRun in Google Sheets: update compliance expiry tracker
    WebRun opens Google Sheets to update compliance expiry tracker.
    • Open the carrier compliance tracker sheet
    • Update or insert a row for each carrier with the certificate type, expiry date, and reminder-drafted status
    • Sort by expiry date so the most urgent renewals appear at the top

    Done when The compliance sheet shows current expiry data for all carriers flagged this week.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
awery.aero
ScheduleRuns automatically on this cadence
Every Monday at 9:00 AM
DeliveryHow each run's result reaches you
Expiry tracker · Google Sheets
OutputWhat each run produces - A Google Sheets compliance tracker updated with upcoming expiry dates plus Gmail draft renewal reminders ready for approval.
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

Will it email the carriers automatically?

No. Every reminder is saved as a Gmail draft for your compliance team to review first. Nothing is sent until you approve it.

What if a carrier submits a new certificate before I send the reminder?

Update the expiry date in Awery and the carrier will drop off the next week's flagged list automatically.

Can it track other compliance documents like dangerous-goods approvals?

Yes. If expiry dates for other document types are stored in Awery carrier records, WebRun can be configured to flag those too.

Put this on autopilot.

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