Weekly courier scorecard emailed to your ops team

Every Monday at 9am, generate a weekly courier performance scorecard from AfterShip and email it as an HTML report to my ops distribution list via Gmail.

First, use AfterShip's List Trackings action to pull every shipment that was delivered in the past 7 days. Filter by delivered status and a delivery-date window covering the previous week, and paginate through the cursor until you have the full set of trackings.

Then use AfterShip's Get Couriers action to fetch the active courier list so you can enrich each tracking's slug/courier field with a human-readable display name (for example, the slug 'fedex' becomes 'FedEx').

Group the trackings by courier and compute per-courier metrics: on-time rate (delivered on or before the tracking's promised estimated delivery date versus after), average transit time in days (from pickup to delivered), exception rate (share of shipments that hit an exception subtag or checkpoint during the week), and total delivery volume.

Write a narrative report, not a bare table. Call out the best and worst performers with specific tracking examples using their tracking numbers and any exception context, in the style of 'FedEx: 94% on-time, 2.1 day average, best week yet' or 'DHL: 6 exceptions this week, including tracking #ABC123 stuck 5 days in customs'. Note carriers with very low weekly volume so a single delayed shipment does not dominate the story.

Format the report as a clean HTML email with a top-line summary, a per-carrier breakdown, and highlighted callouts for the standout stories. Then use Gmail's Send a Message action to send it to my ops distribution list with a subject line like 'Weekly courier scorecard, week of <start date>'.