All templates

Automated Air Cargo On-Time Performance Report

Every Monday, WebRun opens Awery, retrieves completed flight records for the previous week, calculates on-time performance by lane, carrier, and commodity type, writes the results to a Google Sheets report, and posts a summary to Slack for your management review.

Deploy this workflow Browse all templates
Runs on WebRun · Strict Lockdown policy
Every Monday at 8:00 AM WebRunorchestrates each step
1 Awery retrieve completed flight and AWB records
2 Google Sheets calculate and record OTP metrics
3 Slack post weekly OTP summary to management
In short

How do I automatically generate an air cargo on-time performance report each week?

WebRun reads Awery flight records every Monday, calculates on-time performance for the previous week by lane and carrier, and writes a detailed breakdown to Google Sheets. A concise summary is posted to Slack so your management team sees last week's results without building the report by hand.

  • Weekly OTP report is ready in Google Sheets before the Monday standup without any manual work
  • Lanes and carriers breaching your OTP target are flagged automatically for review
  • Management gets a Slack summary with a single click through to the full detail

Built for airline cargo managers · air freight operations teams · cargo capacity planners · freight forwarders

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 - retrieve completed flight and AWB records
    awery.aero
    WebRun in Awery: retrieve completed flight and AWB records
    WebRun opens Awery to retrieve completed flight and AWB records.
    • Open Awery and navigate to completed flight and cargo track-and-trace records for the previous seven days
    • Capture scheduled versus actual departure and arrival times for each flight
    • Group records by lane (origin-destination pair) and carrier

    Done when All completed flight records for last week are captured with scheduled and actual times.

  3. 2
    Google Sheets - calculate and record OTP metrics
    google.com
    WebRun in Google Sheets: calculate and record OTP metrics
    WebRun opens Google Sheets to calculate and record OTP metrics.
    • Open the weekly OTP report sheet and add a new section dated for last week
    • Calculate on-time percentage per lane and carrier (flights within 30 minutes of schedule)
    • Highlight any lane or carrier with OTP below your target threshold in red

    Done when Google Sheets contains a complete OTP breakdown for last week with threshold flags applied.

  4. 3
    Slack - post weekly OTP summary to management
    slack.com
    WebRun in Slack: post weekly OTP summary to management
    WebRun opens Slack to post weekly OTP summary to management.
    • Post a brief OTP summary to the #cargo-management Slack channel
    • List overall OTP, best-performing and worst-performing lanes, and any threshold breaches
    • Link to the full Google Sheets report for detail

    Done when Management has a weekly OTP summary in Slack with a link to the detailed Sheets report.

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 8:00 AM
DeliveryHow each run's result reaches you
OTP report · Google Sheets
OutputWhat each run produces - A Google Sheets OTP report by lane and carrier plus a Slack summary of last week's on-time performance with threshold breach flags.
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

What counts as on-time for the calculation?

The default tolerance is 30 minutes versus scheduled departure or arrival. You can change the tolerance in WebRun settings to match your SLA definition.

Can it include OTP broken down by commodity or shipment type?

Yes. If commodity data is recorded against AWBs in Awery, WebRun can group the OTP calculation by commodity type as well as by lane and carrier.

Does it change any data in Awery?

No. WebRun reads flight records from Awery in read-only mode and writes only to Google Sheets. No Awery records are created or modified.

Keep going

Related templates

Automated Air Cargo Accessorial Charge Audit
WebRun compares accessorial charges on carrier invoices in QuickBooks against the approved tariffs stored in Awery, flags discrepancies above your tolerance threshold, and logs the findings in Google Sheets for your finance team to dispute.
Awery›QuickBooks›Google Sheets
Automated Air Cargo Claim Tracking and Follow-Up
WebRun monitors open cargo claims in Awery, tracks response deadlines, drafts follow-up messages to insurers or handlers for your approval, and posts a weekly claim status digest to Slack so no claim misses its deadline.
Awery›Mailchimp›Slack
Automated Carrier Insurance Certificate Expiry Tracking
WebRun checks Awery for carrier records with insurance certificates expiring in the next 30 days, drafts renewal reminder emails to each carrier, and logs expiry dates in Google Sheets so your compliance team is never caught off-guard.
Awery›Gmail›Google Sheets

Put this on autopilot.

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

Deploy this workflow Talk to us