Already using Google Sheets to manage orders? Now you can track delivery status without leaving your spreadsheet — on any device, including Mac.
Why Google Sheets?
Unlike Excel VBA macros (Windows-only), Google Apps Script works everywhere:
- Mac, Windows, Chromebook, even mobile
- No software to install — runs in the browser
- Easy sharing — just copy a link, no file downloads
- Free — Google Sheets is free with a Google account
Two Ways to Get Started
Option 1: Copy Our Template (Easiest)
- Click here to make a copy
- A “WhereParcel” menu appears at the top
- Click WhereParcel > Setup All (use the menu, not the button — this installs the triggers)
- Done — start tracking! Checkbox buttons now work too.
Option 2: Add to Your Existing Spreadsheet
Already have an order management sheet? Add tracking to it:
- Open your Google Sheet
- Go to Extensions > Apps Script
- Delete any existing code
- Download Code.gs and paste the contents
- Press Ctrl+S to save
- Go back to your spreadsheet and refresh the page
- A “WhereParcel” menu appears — click Setup All
This creates Settings, Tracking, Carrier Codes, and Instructions sheets automatically. Your existing data sheets are untouched.
How to Track Parcels
- Enter carrier codes (column B) and tracking numbers (column C) in the Tracking sheet
- Go to WhereParcel > Register Tracking
- Wait 5-10 seconds
- Go to WhereParcel > Fetch Results
Results populate automatically: delivery status, location, receiver name, and timestamps.
Smart Carrier Codes
You don’t need to memorize carrier codes. Just type the common name:
| You Type | Becomes |
|---|---|
ups | us.ups |
fedex | us.fedex |
dhl | intl.dhl |
yamato | jp.yamato |
royal mail | gb.royalmail |
cj | kr.cj |
The script normalizes them automatically. Need a carrier with no shortcut? Use the full code like de.hermes for Hermes Germany.
Color-Coded Results
Results are color-coded for quick scanning:
- Green — Delivered
- Blue — In Transit / Out for Delivery
- Orange — Pending
- Red — Failed / Returned / Cancelled
43+ Carriers Supported
The full carrier list covers 11 countries:
- US: UPS, USPS, FedEx, OnTrac, Amazon Logistics
- Korea: CJ Logistics, Lotte, Hanjin, Korea Post
- Japan: Yamato, Sagawa, Japan Post
- UK: Royal Mail, DPD, Evri
- Germany: Hermes, DPD, GLS
- International: DHL Express, EMS, Aramex, TNT, Cainiao
Check the “Carrier Codes” sheet for the complete list.
Google Sheets vs Excel — Which Should I Use?
| Google Sheets | Excel | |
|---|---|---|
| OS | Any (Mac, Windows, Chromebook) | Windows only |
| Install | None — browser-based | Download .xlsm file |
| Sharing | Link sharing | File sharing |
| Offline | Limited | Full |
| VBA macros | No (Apps Script instead) | Yes |
Use Google Sheets if you work on Mac, share sheets with a team, or prefer browser-based tools.
Use Excel if you work offline or already have an Excel-based workflow. Download the Excel version.
Tips
- First-time authorization: Google will ask you to authorize the script when you first run it. This is normal — the script needs permission to make API calls.
- “Untracked Only” mode: Set this in Settings to skip rows that already have results, saving API usage.
- Batch processing: Up to 100 items per batch, automatically split for larger sets.
Get Your API Keys
The template comes with demo keys for testing. For production use with higher limits, subscribe — cancel anytime.
Need help? Join our community or check the Excel & Google Sheets tracker page for more details.