From 4 Hours of Daily Admin to a 15-Minute Morning Review
The Challenge
Every morning the operations team spent 3–4 hours copy-pasting load confirmations from carrier emails into their TMS, updating a shared Google Sheet, and manually emailing status updates to shippers. Errors were common — the wrong load number on a confirmation caused a $4,200 invoice dispute that took two weeks to resolve. The team knew the process was broken but assumed fixing it required an expensive TMS upgrade.
What We Built
We built a three-stage AI pipeline that runs on their existing email inbox — no TMS change required. First, a document-parsing agent reads every inbound carrier confirmation PDF and email, extracts load number, pickup/delivery addresses, driver name and ETA with 98% accuracy. Second, a rules engine matches each confirmation to the correct load record in their TMS via API and pushes the update automatically. Third, a summarisation agent composes and sends a plain-English status email to the shipper the moment a milestone is hit — pickup, in-transit, delivered.
“I was convinced we needed to replace our whole TMS. Turns out the problem was never the software — it was the manual bridge between our inbox and the software. That bridge is gone now.”
Results
- Daily admin time reduced from ~3.5 hours to under 15 minutes (a 93% reduction)
- Confirmation-to-TMS update lag dropped from 2–6 hours to under 3 minutes
- Invoice disputes caused by data-entry errors fell to zero in the 6 months post-launch
- The team redirected saved time to prospecting, adding 2 new carrier relationships in Q1
Stack Used
- n8n workflow automation
- OpenAI GPT-4o (document parsing)
- Custom TMS REST API connector
- Gmail + Resend for email delivery
Timeline: 6 weeks from discovery to go-live