The Scenario
You are a fulfillment coordinator. Your ops manager reviewed the rate quotes in the workbook this morning and approved 60 of them. The Approved Rates tab has a rate ID in column B for each approved row.
You need to buy all 60 labels and get tracking numbers and label PDF URLs back into the workbook before the 3 PM carrier pickup.
The bad version of this afternoon:
- You open the Shippo dashboard and search for the first rate ID
- You confirm the purchase, copy the tracking number, switch to Excel, paste it
- You go back to Shippo for rate ID two
- Forty minutes in you have done 18 labels
- Shippo's purchase UI slows down; you are hitting the dashboard's rate limits
- You are still clicking when the driver arrives.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the rate IDs and purchases all 60 labels in sequence, writing tracking numbers and PDF URLs back to the workbook as each transaction completes.
Open the SheetXAI sidebar and type:
Read all rate IDs in my Approved Rates tab and create Shippo transactions for each. Write the label PDF URL and tracking number into columns D and E.
SheetXAI reads column B, calls Shippo's transaction endpoint for each rate ID, and writes label PDF URL and tracking number into D and E row by row.
What You Get
A completed purchase log with everything your warehouse needs:
- Column D — the direct URL to the label PDF, ready to send to your print queue
- Column E — the tracking number for each purchased label
- Failed purchases surfaced — if a rate ID expired or the transaction fails, the row gets an error message instead of a blank cell
- No manual dashboard work — 60 labels purchased without opening Shippo once
The label URLs in column D are print-ready. Share the workbook with your warehouse team and they can download and print directly.
What If the Data Is Not Quite Ready
Label purchase batches always have edge cases. SheetXAI handles them inline.
When some rate IDs have already been purchased
You ran part of this batch earlier and some rows already have tracking numbers in column E. You do not want to purchase those again.
Skip any row in my Approved Rates tab that already has a value in column E. For all rows where column E is empty but column B has a rate ID, purchase the Shippo label transaction and write the label PDF URL and tracking number into columns D and E.
When rate IDs have expired and need to be refreshed
Shippo rate quotes are only valid for a short window. If your rate IDs are old, some may have expired.
For each rate ID in column B of my Approved Rates tab, attempt to purchase the Shippo label. If the rate has expired, create a new rate quote using the origin and destination in columns F and G and the weight in column H, then use the new rate ID to purchase the label. Write the label PDF URL and tracking number into columns D and E.
When you only want to purchase labels for rows under a rate threshold
Your ops manager approved all rates under $12. Anything above needs a second review before purchase.
Filter my Approved Rates tab to rows where column C shows a rate under $12. Purchase Shippo label transactions for those rows and write the label PDF URL and tracking number into columns D and E. For rows where the rate is $12 or more, write "PENDING REVIEW" into column D.
When you want to purchase, log transaction status, and build a CS message column in one shot
Your CS team needs a ready-made customer message for each shipment right after labels are purchased.
Purchase a Shippo label transaction for each rate ID in column B of my Approved Rates tab. Write the label PDF URL into column D, the tracking number into column E, and the transaction status into column F. For each row where the status is "valid," write a short customer message into column G: "Your order is on its way. Track it here: [tracking number]."
The pattern: purchase, validate, and generate downstream output in one prompt. Your CS team does not need a second pass.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with approved Shippo rate IDs, then ask it to purchase all the labels and write tracking numbers back. The Shippo integration is included in every SheetXAI plan. For related workflows, see how to look up tracking status for a list of shipments or the Shippo in Excel overview.