AI operations analytics for a last-mile carrier

Alongside its main operations app, Tryfaz, a last-mile delivery company with about 450 drivers across 8 sites, needed a cockpit to see what really happens on the ground: which site is slipping and since when, whether the issue comes from drivers, from the client forecast or from the data itself, and which routes were planned by the client but never run.

We built a second Softr app for the operations lead. It reads the operations data without ever writing to it, and keeps its own tables for imports, daily summaries, AI analyses and tickets.

CLIENT DATA, MATCHED THE RIGHT WAY
Amazon scorecards and Vinted files are imported and matched to drivers by their client driver ID, never by name, because there are too many homonyms. The operations team linked about 195 drivers to their Amazon ID in a day, up from 23.

DAILY SUMMARIES WITH A CONFIDENCE SCORE
A Softr workflow computes one line per site per day: delivery, returns, attendance, planning and forecast. Because part of the data is declared by drivers from their phones, each summary carries a data confidence score, with clear rules such as a forecast at least 90% filled in.

A WEEKLY AI ANALYSIS
Every Monday morning, n8n builds a numbers dossier (12 weeks of history, sites, drivers, causes, anomalies) and Claude writes the commentary on top of it, exported to PDF and PowerPoint, ready for the weekly meeting. One rule: figures and charts always come from the computed dossier, never from the AI's text. A weekly meeting view per site sends a prefilled WhatsApp message to each depot group.

THE MAINTENANCE DESK OF THE MAIN APP
A Report button on every page of the main app sends the user's message and a screenshot. AI cleans it up into a clear ticket so the team can prioritise and fix it quickly; nothing is published without the team's validation.

RESULTS
The weekly analysis now produces itself in a few minutes instead of hours of manual reporting. Data reliability is measured instead of guessed, with a clear target. Field requests reach a single ticket board, already clarified, and the operations lead can report to management with figures nobody has to argue about.