The problem
A delivery company handling COD parcels for e-commerce sellers gets flooded with "where is my parcel?" calls. Worse, 25% of delivery attempts fail because the client is absent or unreachable.
The solution, step by step
- Parcel statuses live in Google Sheets (or the TMS), updated by drivers scanning at each step.
- An n8n workflow watches status changes and sends the right WhatsApp Business message: "picked up", "out for delivery today", "driver 30 minutes away".
- The "out for delivery" message asks the client to confirm availability or choose another day with one tap.
- Unconfirmed clients are called by the dispatcher before loading, not after a failed trip.
- After delivery, a message confirms and asks for a rating; COD totals are reconciled in the sheet.
- "Where is my parcel" calls drop by 70%.
- Failed first attempts fall from 25% to under 10%, saving fuel and driver hours.
- Sellers see reliable tracking, which brings more contracts.