Getting Started

Overview

Your Package Tracker is 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.

It tracks 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.

Quick Start

1. Install the Google Sheets add-on

Install the add-on from the Google Workspace Marketplace. You get 3 free tracking lookups to try — no credit card required.

After installation, refresh your Google Sheets document if the menus don’t appear immediately.

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.

Drag-fill is safe

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? Extensions → Your Package Tracker → Refresh Live Tracking 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

About the on-demand formulas

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 _LIVE variants (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:

1. Go to menu: Extensions → Your Package Tracker → Bulk Track Packages
2. Enter your tracking numbers range (e.g., A2:A50)
3. Enter your carrier codes range (e.g., B2:B50)
4. 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
5. (Optional) For carriers like JNE Express, expand “Advanced Options” and enter the phone last 4/5 digits
6. 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. See the Supported Couriers page for the full list.

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 — no credit card required. Install from the Google Workspace Marketplace →

Need Help?

If you encounter any issues during setup or use:

• Email: [email protected]
• Support page: Contact & common questions

We’re here to ensure you have a smooth experience!