Track package deliveries and update Google Sheets with WhatsApp alerts

The system checks all your shipment tracking codes automatically and sends a WhatsApp summary of what's delivered or pending.

How the work actually flows

A straight line. Runs once per each tracking code.

Pattern: Sequence (1) · Multiple Instances with a priori Run-Time Knowledge (14)

flowchart TD trig(["scheduled tracking check"]):::trigtime s0[("read tracking codes")]:::store s1[["check shipment status"]]:::mi s2["classify each status"]:::task s3[("update tracking sheet")]:::store s4["send whatsapp summary"]:::svc trig --> s0 s0 -->|"one per each tracking code"| s1 s1 --> s2 s2 --> s3 s3 --> s4 out[/"updated tracking log and summary"/]:::out pay{{"saves time checking each shipment"}}:::pay s4 --> out 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 stepAn outside serviceRuns once per itemA record or sheetResultPayoff

Build size

Advanced

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

Business functions

Messaging & NotificationsSpreadsheet & Database Ops

Connects

Google SheetsWhatsApp

Featured in

Manufacturers

The problem it solves

Checking on dozens of shipments one at a time means logging into a tracking site, copying statuses into a spreadsheet, and repeating that for every package. It's tedious, easy to lose track of, and takes time away from the rest of your operations.

Who it fits

A small business or operations team that ships or receives many packages and tracks them in a spreadsheet.

How it works

On a schedule, the system reads tracking codes from your Google Sheets
It skips anything already marked delivered and cleans up each code
It checks the current shipment status for each remaining code
AI classifies each one as delivered, pending logistics, or pending materials
Google Sheets is updated and your team gets a WhatsApp summary of the results

Quick estimate

What it is worth to you

Your numbers, your hourly cost. We add nothing hidden.

Shipments tracked per week

per week

Minutes to check and log one shipment by hand

minutes

Loaded hourly cost

$ per hour

0Hours freed per month

0Value per year at your hourly cost

Assumes you still act on any pending shipments flagged, and freed time is redirected to other work.

What you get

An updated tracking spreadsheet and a WhatsApp message summarizing how many shipments are in each status.

What you need

A Google Sheets account, a shipment tracking API account, a WhatsApp messaging account, and an AI API key.

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