All projects
Automation +Custom Software · Live · 2026 · 2 min read

"Project Daily Coach DSP" — automated defect coaching

Defect data in, tailored coaching out — same day, by SMS.

Client: Last-mile delivery operation

A Node.js + Express service that ingests the operation's daily defect spreadsheet the moment it lands, attributes each defect to the right driver, generates coaching matched to the actual issue, and texts it to the driver before their next route — closing the awareness gap that lets repeat behaviors slip through.

The problem

Drivers usually find out about a customer-reported defect long after the delivery — or never at all. Manually sorting through the daily defect data and writing coaching for each affected driver is grinding work that slips the moment dispatchers get pulled into something else. The result: repeat issues, slipping scorecards, and drivers who feel blindsided when problems do surface.

Our approach

A Node.js + Express backend that picks up the defect spreadsheet as soon as it's available, processes it end-to-end, generates per-driver coaching matched to the specific defect type, and delivers it directly by SMS. The dispatcher's coaching workflow runs itself; drivers see the feedback while it still has a chance to change tomorrow's behavior.

The outcome

Live with the operation now, running every business day. The dispatcher's morning that used to vanish into manual sorting and per-driver coaching is hands-off; drivers get specific defect feedback within hours of the delivery instead of weeks later — or never. We're tracking first-quarter scorecard movement against the prior baseline and will post the deltas here once the numbers settle.

Tech stack
Node.jsExpressExcel ingestSMS delivery
Have something like this?

Most of these started with one paragraph.

Send yours and we’ll tell you whether we’re the right fit before either of us spends another minute on it.