A
B
C
D
1
Tracking Number
Carrier
Formula
Result
2
1Z999AA10123456784
UPS
=PKG_STATUS(A2,B2)Delivered
3
9400111899223100012
USPS
=PKG_STATUS(A3,B3)In Transit
4
7489642568
FedEx
=PKG_STATUS(A4,B4)Out for Delivery
That's it. Paste a tracking number, write a formula, get the status.
Three steps. No config.
- Install the add-on from the Google Workspace Marketplace. One click, no API keys.
- Write a formula like
=PKG_STATUS("tracking_num", "carrier")in any cell. - Read the result. Copy the formula down for as many shipments as you need.
Six formulas. That's the whole API.
PKG_STATUS()Current status — "In Transit", "Delivered", etc.PKG_SUMMARY()One-line summary of where your package isPKG_LAST_EVENT()The most recent tracking event with timestampPKG_EVENTS()Full event history, one row per scanPKG_REFRESH()Force a fresh lookup from the carrierPKG_QUOTA()How many requests you have left this month1,700+ carriers
FedEx / UPS / USPS / DHL / Australia Post / China Post / Royal Mail / Canada Post / Japan Post / Yamato / SF Express / and 1,690 more.
Pricing
3 free lookups to try. No credit card.
Starter$19/mo200 lookups/month
Growth$49/mo1,000 lookups/month
Business$99/mo3,000 lookups/month
Every plan includes all carriers and email support. Full details