Getting Started with Your Package Tracker
Welcome to Your Package Tracker – the easiest way to track shipments directly in Google Sheets!
What is Your Package Tracker?
Your Package Tracker is a Google Sheets add-on that lets you track packages from 1,700+ carriers worldwide using simple spreadsheet formulas. No more switching between tabs or manually checking carrier websites.
Quick Start
1. Install the Add-on
Install Your Package Tracker from the Google Workspace Marketplace.
2. Open the Add-on
In your Google Sheet, go to Extensions → Package Tracking → Subscribe / Manage Billing.
3. Start Tracking
Use these formulas in any cell:
=PKG_STATUS("YOUR_TRACKING_NUMBER", "CARRIER_NAME")
Examples:
=PKG_STATUS("1Z999AA10123456784", "UPS")
=PKG_STATUS("9400111899223456789012", "USPS")
=PKG_STATUS("JD014600006888888888", "FedEx")
Available Functions
| Function | Description |
|---|---|
PKG_STATUS | Returns the current tracking status (e.g., "In Transit", "Delivered") |
PKG_SUMMARY | Returns a summary with status, location, and last update time |
PKG_LAST_EVENT | Returns the most recent tracking event with timestamp |
PKG_EVENTS | Returns all tracking events as a formatted list |
PKG_REFRESH | Force refresh tracking data (bypasses cache) |
PKG_QUOTA | Shows your current usage and remaining quota |
Do not copy-paste formulas to many cells at once. This can trigger rate limiting errors. For tracking multiple packages, use the Bulk Track feature instead.
Bulk Track Packages
Need to track many packages at once? Use the Bulk Track Packages feature for safe, rate-limited processing:
- 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.
Supported Carriers
We support 1,700+ 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.
Pricing
| Plan | Shipments/Month | Price |
|---|---|---|
| Starter | 200 | $19/month |
| Growth | 1,000 | $49/month |
| Business | 3,000 | $99/month |
Free trial: 3 tracking requests to try it out!
Need Help?
- Email: yourpackagetracker@terrydjony.com
- Documentation: Browse the sidebar for detailed guides