The challenge
Customers kept phoning to ask about their vehicle - reported, loading, invoiced or despatched?
What we built
We built a mobile app on Google Sheets for the yard supervisor with four one-tap stages, type-ahead search across 2,000 customers, and vehicle number capture. At every stage change, the customer automatically receives a professionally formatted email with the vehicle number and timestamp. Customers now track their despatches without a single phone call, and management has a live log of yard activity. Access is restricted to the named Google accounts of the yard and management team, so the tracker is not open to anyone who simply holds the link.
The result
Before: constant customer phone calls. Now: zero calls.