Getting Started
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 |
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