Etsy Order Tracking in Google Sheets: The Complete Seller's Guide
Every Etsy seller past their first dozen sales knows the two-front shipping war. Outbound: buyer orders that need to arrive on time, because late deliveries mean "where is my order?" messages, bad reviews, and a dented Star Seller badge. Inbound: the beads, fabric, packaging, and blanks you ordered from suppliers — the purchase orders your whole production schedule depends on.
Etsy's dashboard shows you neither side well. It tells you a label was purchased, not where the package actually is. And it knows nothing at all about your supply orders.
This guide shows you how to run both sides — every buyer order and every inbound PO — in a single Google Sheet with live, auto-updating tracking statuses.
Why a spreadsheet beats the Etsy dashboard for tracking
Etsy's Orders & Shipping page is built for fulfilling orders, not following them. Once you mark an order shipped, Etsy shows the tracking number as a link — and that's it. To know whether order #2481 actually got delivered, you click through to the carrier site. Thirty orders in transit means thirty clicks, every day.
A Google Sheet flips this around:
- Every order's live status in one column. Delivered, In Transit, Out for Delivery, Exception — visible at a glance, no clicking.
- Statuses update themselves. With Your Package Tracker, each cell subscribes to live carrier push notifications. New scans appear in the sheet without you refreshing anything.
- Any carrier, one formula. USPS for domestic, FedEx for the oversized stuff, Royal Mail or Australia Post for international buyers, plus whatever your suppliers use — 3,000+ carriers, all in the same column.
- It holds your data too. Order number, buyer name, item, ship date, notes — everything Etsy shows, plus everything Etsy doesn't.
Step 1: Get your Etsy orders into the sheet
Two ways, depending on how you like to work:
Option A — CSV export (best for backfilling). In Etsy: Shop Manager → Settings → Options → Download Data, choose the Orders CSV type and your month. The export includes order ID, buyer, and date. Paste it into a Google Sheet, add your tracking numbers, and you have your base table.
Option B — add rows as you ship (best day-to-day). When you print a label, add one row: order number, buyer, tracking number, carrier. Ten seconds per order, and the sheet is always current.
Either way, aim for this layout:
| Col | Header | Example | Notes |
|---|---|---|---|
| A | Order # | #2481 | Etsy order ID |
| B | Buyer | sarah_m | For answering messages fast |
| C | Item | Ceramic mug — speckled | Optional but handy |
| D | Ship date | 2026-08-15 | For "is this late?" checks |
| E | Tracking # | 9400 1000 0000 ... | Required |
| F | Carrier | USPS | Required |
| G | Status | (formula) | =PKG_STATUS_LIVE(E2, F2, TODAY()) |
| H | Summary | (formula) | =PKG_SUMMARY_LIVE(E2, F2, TODAY()) |
If you buy shipping labels through Etsy, the carrier is usually USPS (US sellers), Canada Post, Royal Mail, or Australia Post depending on where you ship from — put whichever you used in column F. Sellers using Pirate Ship or Shippo: same thing, the underlying carrier is what goes in the column.
Step 2: One formula, live statuses
In G2:
=PKG_STATUS_LIVE(E2, F2, TODAY())
In H2:
=PKG_SUMMARY_LIVE(E2, F2, TODAY())
Drag-fill both down the whole order list. The first lookup of each tracking number shows Registering... for a few seconds, then live data replaces it. From that point on the cells keep themselves up to date as carriers post new scans — no refresh button, no scripts, no triggers.
Live auto-updating is the part other tracking tools don't do. A one-shot lookup goes stale the moment the next scan happens; these formulas subscribe to carrier push notifications so your whole sheet stays current on its own.
Step 3: Make "where is my order?" a ten-second answer
Buyer messages about shipping are the single biggest support load for most Etsy shops. With the sheet in place, the workflow becomes:
- Buyer messages you.
Ctrl+Ftheir username or order number in the sheet.- Read the Summary column — "In Transit — Departed USPS Regional Facility, Des Moines IA, Aug 16" — and paste exactly that into your reply.
Add conditional formatting so problems find you before buyers do:
- Delivered → green. Done, ignore.
- Out for Delivery → yellow. Arriving today.
- Exception / Alert / Return to Sender → red. Message the buyer proactively — a "hey, I saw your package hit a delay, here's what I'm doing" message before they notice is the cheapest 5-star review you'll ever earn.
That last point matters for Star Seller: the messaging and dispatch metrics are yours to control, but delivery problems you catch late become reviews you can't undo. A red-row check each morning is the habit that protects the badge.
Step 4: Track your supply POs in the same file
Here's the use case Etsy sellers tell us changed how they work: inbound purchase orders, tracked right next to outbound orders.
Your production schedule is only as reliable as your supply chain. Clay from one vendor, glaze from another, boxes from Uline, custom stamps from another Etsy shop — each PO ships with its own carrier and its own tracking number, and whether you can fulfill next week's orders depends on all of them.
Make a second tab, Inbound POs:
| Col | Header | Example | Notes |
|---|---|---|---|
| A | PO / order ref | PO-0231 | Your reference or the vendor's |
| B | Vendor | ClaySupplyCo | |
| C | What | 25lb stoneware x4 | So you know what's arriving |
| D | Need by | 2026-08-25 | The date production is blocked without it |
| E | Tracking # | 1Z999AA1... | |
| F | Carrier | UPS | Whatever the vendor used |
| G | Status | (formula) | Same PKG_STATUS_LIVE formula |
| H | Last event | (formula) | =PKG_LAST_EVENT_LIVE(E2, F2, TODAY()) |
Same formulas, same live updates. Now "can I promise this custom order by Friday?" is answered by looking at one tab instead of digging through five vendor confirmation emails. Overseas supply orders (fabric from India, findings from China via YunExpress or China Post) work identically — customs events show up in the Last event column, which is exactly where delays happen.
One sheet, two tabs, the whole physical flow of your shop: materials in, orders out.
Real Etsy scenarios this handles
The holiday-rush shop. October–December, 40 orders a week instead of 10. The sheet scales by drag-filling further down; the morning red-row check stays a two-minute habit even at peak.
The international seller. UK shop, buyers in the US, EU, and Australia. Royal Mail hands off to USPS mid-journey — the tracking timeline in the sheet stays continuous across the handoff. See our multi-courier guide for how mixed and hand-off carriers behave.
The made-to-order shop with tight supply timing. Custom pet portraits; blank canvases arrive weekly. The Need by column vs. live PO status tells you today whether to pause listings before you oversell — instead of finding out when the canvas doesn't show up.
Frequently asked questions
Does this connect to my Etsy account? No connection needed. You bring tracking numbers into the sheet (CSV export or typing as you ship); the add-on takes it from there. Nothing touches your Etsy credentials.
Etsy already emails buyers tracking links. Why do I need this? Those links tell your buyer where the package is — if they check. This tells you, for every order at once, so you catch exceptions and answer messages without clicking through carrier sites one by one.
I use Etsy shipping labels, Pirate Ship, and sometimes drop off at FedEx. Mixed carriers OK? Yes — carrier is just a column value. USPS rows query USPS, FedEx rows query FedEx, in the same Status column.
Do my supply POs from Alibaba/overseas vendors work? Yes. 3,000+ carriers includes China Post, YunExpress, Yanwen, SF Express, and the other cross-border networks those shipments typically use.
What does it cost? 3 free lookups to try it. Paid plans from $19/month — full pricing. Quota is pooled across all carriers and both tabs; re-reading an already-tracked number is free.
The takeaway
Your Etsy shop already runs on two flows of packages — supplies in, orders out — and neither Etsy nor your vendors give you one place to watch them. A Google Sheet with live tracking formulas does: one file, one formula, every package your business depends on, updating itself.
Install Your Package Tracker free from the Google Workspace Marketplace →
Also selling on other platforms? See our guides for Shopify sellers and Amazon sellers, or start with the basics of tracking packages in Google Sheets.