Automated Air Cargo Staff Credential Expiry Tracking
Every Monday, WebRun opens Awery, finds drivers and ramp agents with licences, airside-pass renewals, or dangerous-goods certificates expiring within 60 days, logs each case in Google Sheets, and sends a structured Telegram alert to the compliance manager so renewals are actioned before anyone is stood down.
How do I track driver and ramp-agent document expiry dates for air cargo operations?
WebRun opens Awery every Monday and finds every driver and ramp agent with a licence, airside pass, or dangerous-goods certificate expiring within 60 days. It logs each case in a color-coded Google Sheets tracker and sends a structured Telegram alert to the compliance manager, sorted by urgency so the most critical renewals are addressed first.
- No driver or ramp agent is stood down for an expired credential that was caught too late
- Google Sheets shows the full renewal pipeline sorted by urgency every Monday
- Compliance manager gets an actionable Telegram alert without checking Awery manually
Built for air cargo compliance managers · ground handling supervisors · airline safety teams · cargo HR managers
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
awery.aeroin a real browser with your saved login - no setup, no API keys. -
1
Awery - find staff with expiring credentials
awery.aero
WebRun opens Awery to find staff with expiring credentials. - Open Awery and navigate to staff or crew records
- Filter for drivers and ramp agents with any credential expiring within 60 days
- Capture staff name, credential type, expiry date, and assigned base for each
Done when Every staff member with a credential expiring in 60 days is listed with document details.
-
2
Google Sheets - log expiry cases with renewal status
google.com
WebRun opens Google Sheets to log expiry cases with renewal status. - Open the staff credential tracker sheet
- Update or insert rows for each flagged staff member with credential type, expiry date, and days remaining
- Color-code rows red for under 14 days, amber for 15 to 30 days, and yellow for 31 to 60 days
Done when Google Sheets reflects current credential expiry status for all flagged staff, color-coded by urgency.
-
3
Telegram - alert compliance manager
telegram.org
WebRun opens Telegram to alert compliance manager. - Send a structured Telegram message to the compliance manager chat
- List red-zone and amber-zone staff first, with credential type and exact expiry date
- Include the count of yellow-zone renewals coming up this month
Done when Compliance manager receives today's credential expiry alert in Telegram with urgency tiers.
How is each run configured?
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.
Every action is checked against this policy before it runs.
Questions, answered
Will it notify the drivers or ramp agents themselves?
No. The Telegram alert goes only to the compliance manager. Outreach to individual staff is left for your HR or operations team to handle through your normal process.
Which credential types does it track?
Any credential with an expiry date recorded in Awery staff records, including driving licences, airside passes, dangerous-goods certificates, and security clearances.
What happens when a renewal is completed?
Update the new expiry date in Awery and the staff member will drop off the flagged list on the next Monday run automatically.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.