Track pilot certifications and alert before they expire
Every Monday, WebRun opens your pilot certification tracker in Google Sheets, checks expiry dates for FAA Part 107 certificates, TRUST completions, and equipment authorisations, cross-references active assignments in DroneDeploy, and posts a renewal alert to Slack for every certification expiring in the next 60 days.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically track drone pilot certification expiry dates?
Every Monday, WebRun reads your pilot certification tracker in Google Sheets, flags FAA Part 107, TRUST, and equipment authorisations expiring within 60 days, checks active DroneDeploy assignments to prioritise the most urgent cases, and posts a clear renewal alert to Slack so no pilot flies on an expired credential.
- Expiring certifications are flagged 60 days out, not the day before a flight
- Pilots with active job assignments are prioritised in the renewal alert
- The compliance team has a clear renewal list every Monday morning
Built for drone service companies · UAV fleet operators · commercial drone operators · drone operations 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
docs.google.com/spreadsheetsin a real browser with your saved login - no setup, no API keys. -
1
Google Sheets - read all pilot certification expiry dates
google.com How to Automate Google Sheets
WebRun opens Google Sheets to read all pilot certification expiry dates. - Open the pilot certification tracker Google Sheet
- For each pilot, read the expiry dates for FAA Part 107 remote pilot certificate, TRUST completion, aircraft registration, and any equipment type authorisations
- Flag any certification expiring within 60 days and calculate days remaining
Done when Every expiring certification is listed with the pilot name and exact days remaining.
-
2
DroneDeploy - check active pilot assignments
dronedeploy.com How to Automate DroneDeploy
WebRun opens DroneDeploy to check active pilot assignments. - Open DroneDeploy and check which pilots are assigned to flights in the next 60 days
- Cross-reference expiring certifications against those active assignments to flag any pilot who may be flying with an expiring credential
Done when Active pilots with expiring certifications are identified and prioritised.
-
3
Slack - post renewal alerts for expiring certifications
slack.com How to Automate Slack
WebRun opens Slack to post renewal alerts for expiring certifications. - Post a weekly certification alert to the #compliance channel listing pilots with items expiring within 60 days
- Sort by urgency: highlight pilots with active assignments whose certifications expire soonest
- Include the certification type, expiry date, and renewal link where applicable
Done when The compliance team has this week's certification renewal list in Slack.
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
Which certifications does it track?
It tracks whatever you record in the Google Sheets tracker: typically FAA Part 107 remote pilot certificates, TRUST completions, aircraft registration, and any equipment type authorisations you add.
Will it file the renewal on my behalf?
No. WebRun alerts the team about upcoming expirations and posts renewal links, but submitting any renewal to the FAA or another body requires a pilot or manager to complete it directly.
How do I add a new pilot to the tracker?
Add a new row to the Google Sheets tracker with the pilot name and certification expiry dates. WebRun picks it up automatically on the next Monday run.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.