Package Tracker for Google Sheets — Getting Started
Welcome to Your Package Tracker, the only package tracker for Google Sheets with live auto-updating parcel tracking. Drop a formula into any cell, drag-fill across hundreds of rows, and watch every parcel's status update itself as carriers post new scans — no Apps Script, no API keys, no manual reruns.
What is the Package Tracker for Google Sheets?
Your Package Tracker is a Google Sheets add-on that lets you track parcels from 3,000+ carriers worldwide using simple spreadsheet formulas. Unlike other Google Sheets parcel tracking add-ons that return one value and then sit stale, ours uses live carrier push notifications so your sheet stays current on its own — no scripts, no triggers, no manual reruns.
Quick Start: Set up parcel tracking in Google Sheets
1. Install the Google Sheets add-on
Install Your Package Tracker from the Google Workspace Marketplace. You get 3 free tracking lookups to try.
2. Try the Live formula (recommended)
In any empty cell, drop:
=PKG_STATUS_LIVE("YOUR_TRACKING_NUMBER", "CARRIER", TODAY())
Examples:
=PKG_STATUS_LIVE("1Z999AA10123456784", "UPS", TODAY())
=PKG_STATUS_LIVE("9400111899223456789012", "USPS", TODAY())
=PKG_STATUS_LIVE("794657458294", "FedEx", TODAY())
You'll briefly see Registering... while the carrier push gets wired up. Within a few seconds the cell shows the actual status — and from then on it stays current as the carrier posts new scans. Pass TODAY() so Google Sheets re-evaluates the formula daily.
With _LIVE formulas, drag-filling across hundreds of rows just works. We batch registrations server-side and respect every carrier's rate limit. No #ERROR! cascade.
3. Force-refresh on demand
Want to see fresh values right now? Your Package Tracker → Refresh Live Tracking in the menu re-evaluates every _LIVE cell on the active sheet.
Available Functions
The add-on ships with two families of formulas — _LIVE (auto-updating, recommended) and the classic on-demand variants.
Auto-updating (LIVE)
| Function | Description |
|---|---|
PKG_STATUS_LIVE | Auto-updating tracking status |
PKG_SUMMARY_LIVE | Auto-updating summary with location and last update |
PKG_LAST_EVENT_LIVE | Auto-updating most recent event |
PKG_EVENTS_LIVE | Auto-updating full event history |
Pass TODAY() as the 3rd argument so values refresh daily; use the menu's Refresh Live Tracking for instant updates.
On-demand (manual)
| Function | Description |
|---|---|
PKG_STATUS | Tracking status (manual refresh, 6h cache) |
PKG_SUMMARY | Summary (manual refresh, 6h cache) |
PKG_LAST_EVENT | Most recent event (manual refresh, 6h cache) |
PKG_EVENTS | All events (manual refresh, 6h cache) |
PKG_REFRESH | Force-refresh a single on-demand cell (bypasses 6h cache) |
PKG_QUOTA | Shows your current usage and remaining quota |
The non-LIVE formulas (PKG_STATUS, PKG_SUMMARY, etc.) are rate-limited at the formula layer to prevent abuse. Don't drag-fill them across many cells. Either:
- Use
_LIVEvariants (designed for bulk drag-fill), or - Use Bulk Track Packages for a one-shot fetch.
Bulk Track Packages
For a synchronous, one-shot fetch (no auto-updates), use Bulk Track Packages:
- Go to menu: Your Package Tracker → Bulk Track Packages
- Enter your tracking numbers range (e.g.,
A2:A50) - Enter your carrier codes range (e.g.,
B2:B50) - Choose your output type:
- Status: Simple status like "In Transit" or "Delivered"
- Summary: Status with location and last update time
- Last Event: Most recent tracking event with details
- All Events: Complete tracking history
- (Optional) For carriers like JNE Express, expand "Advanced Options" and enter the phone last 4/5 digits
- Click Start Bulk Tracking
Results will be written to the column immediately after your carrier codes column.
For most users, the _LIVE formulas are the better path because they keep refreshing on their own. Bulk Track Packages remains useful when you want a frozen snapshot.
Supported Carriers
We support 3,000+ carriers worldwide, including:
- USA: USPS, UPS, FedEx, DHL, Amazon Logistics
- International: DHL Express, TNT, Aramex
- Asia: China Post, SF Express, Japan Post, Korea Post
- Europe: Royal Mail, Deutsche Post, La Poste, PostNL
- Australia/Oceania: Australia Post, NZ Post
- And many more!
You can use either the carrier name (case-insensitive) or the numeric carrier code.
📥 Download the full carrier list (CSV) — every supported carrier name and numeric code in a single file. Useful when you're importing tracking data from a system that uses carrier codes, or when you want to verify a particular carrier is supported before bulk-loading.
Pricing
| Plan | Shipments/Month | Price |
|---|---|---|
| Starter | 200 | $19/month |
| Growth | 1,000 | $49/month |
| Business | 3,000 | $99/month |
Every plan includes live auto-updating + all carriers + email support.
Free trial: 3 tracking requests to try it out!
Need Help?
- Email: yourpackagetracker@terrydjony.com
- Documentation: Browse the sidebar for detailed guides