Track shipments automatically and notify customers when status changes

Checks courier tracking daily, updates your spreadsheet, and messages customers by WhatsApp and email when a shipment status changes.

How the work actually flows

It branches. Every path runs; runs once per one per active shipment.

Pattern: Multiple Instances with a priori Design-Time Knowledge (13) · Parallel Split (2) · Exclusive Choice (4)

flowchart TD trig(["runs once daily"]):::trigtime s0[("pulls active shipment list")]:::store s1[["checks tracking with courier"]]:::mi s2["updates spreadsheet if changed"]:::task s3["notifies customer of status"]:::task trig --> s0 s0 -->|"one per one per active shipment"| s1 s1 --> s2 s2 --> s3 gx{"+ which channels to notify"}:::gate s3 --> gx p00["sends whatsapp message"]:::task gx -->|"whatsapp update"| p00 p10["sends email message"]:::task gx -->|"email update"| p10 p00 --> out p10 --> out out[/"customers notified of shipment status"/]:::out pay{{"no manual tracking checks needed"}}:::pay out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
Starts itA stepRuns once per itemA record or sheetEvery pathResultPayoff
Build size
Advanced

A larger build with multiple systems, AI reasoning, and custom rules.

Business functions
Email AutomationMessaging & NotificationsSpreadsheet & Database Ops
Connects
Google SheetsDHLDelhiveryWhatsApp
Featured in

The problem it solves

Customers constantly ask where their order is, and checking tracking numbers across different couriers one by one eats up your team's day. Keeping customers updated manually means someone has to remember to do it every single time.

Who it fits

E-commerce or retail businesses shipping orders through multiple couriers.

How it works

  1. Runs automatically once a day
  2. Pulls the active shipment list from a spreadsheet
  3. Checks each tracking number with the relevant courier's system
  4. Updates the spreadsheet only when the status actually changes
  5. Sends the customer a WhatsApp message and email with the new status
What you get

Customers who hear about delays before they ask

Shipment status gets checked every day, your spreadsheet updates itself, and customers get a WhatsApp or email the moment something changes.

What you get

An updated tracking spreadsheet and automatic WhatsApp and email status updates for customers.

What you need

A Google Sheets account, courier API access, a WhatsApp Business account, and an email service.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Back to the AI Playbook