Automated Air Cargo Lane Capacity Digest
Every Monday, WebRun opens Awery, reads booking and available capacity figures for the week ahead grouped by origin-destination lane and carrier, calculates lane load factors, writes a structured breakdown to Google Sheets, and posts a concise capacity digest to Slack for your commercial and operations teams.
How do I get an automatic weekly air cargo lane capacity digest?
WebRun opens Awery every Monday and reads booking and available payload figures for every active lane in the coming week. It calculates load factors by origin-destination pair and carrier, writes a detailed breakdown to Google Sheets, and posts a concise Slack digest highlighting the most oversold and undersold lanes so your commercial team can act before the week starts.
- Commercial team sees the week's oversold and undersold lanes in Slack before Monday's planning call
- Google Sheets holds a weekly capacity history for trend analysis and forecasting
- No manual Awery reporting or spreadsheet building needed for the weekly capacity meeting
Built for airline cargo commercial teams · capacity planners · air freight managers · cargo revenue 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 - read lane capacity and booking data for the week ahead
awery.aero
WebRun opens Awery to read lane capacity and booking data for the week ahead. - Open Awery and navigate to Cargo Reservation and flight planning
- For each active lane in the coming week, read total available payload and booked weight
- Group by origin-destination pair and carrier, and note departure dates
Done when Available and booked capacity figures are captured for every active lane in the coming week.
-
2
Google Sheets - write lane load-factor breakdown
google.com
WebRun opens Google Sheets to write lane load-factor breakdown. - Open the lane capacity tracker sheet and add a new weekly section dated for the coming week
- Calculate load factor percentage for each lane and carrier combination
- Flag lanes above 90% load factor as at risk of overflow and lanes below 50% as undersold
Done when Google Sheets contains a complete lane capacity breakdown for the week ahead with risk flags applied.
-
3
Slack - post weekly capacity digest to commercial team
slack.com
WebRun opens Slack to post weekly capacity digest to commercial team. - Post the weekly capacity digest to the #cargo-commercial Slack channel
- Lead with the top three oversold and top three undersold lanes for immediate action
- Link to the full Google Sheets breakdown for detail
Done when Commercial team has this week's lane capacity digest in Slack with a direct link to the full Sheets data.
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
Does it make any booking changes or reallocate capacity?
No. WebRun only reads and reports. All capacity decisions and reallocations are made by your commercial or operations team after reviewing the digest.
Can it cover more than one week ahead?
Yes. The default is the coming 7 days. You can extend the horizon to 14 or 28 days in your WebRun settings to support longer-range planning.
What are the default thresholds for oversold and undersold lanes?
Oversold is flagged at 90% load factor and above; undersold at 50% and below. Both thresholds are configurable in your WebRun settings.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.