The Scenario
You are on the packaging team at a mid-size e-commerce company. When your team builds a new shipment in Shippo, they need to pick the right package_code for the carrier, USPS flat-rate envelope, FedEx small box, UPS tube. Right now they Google it every time, and half the time they pick the wrong one and the label gets rejected.
What you actually need is a lookup table in Google Sheets listing every available Shippo carrier parcel template, grouped by carrier, that the team can reference without leaving the spreadsheet.
The slow version:
- You open Shippo's API docs
- You scan the carrier template list, which is not sorted by carrier and is not comprehensive
- You copy-paste the ones you recognize into a sheet
- You miss three templates and someone picks a deprecated package code next week.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI calls Shippo's carrier template endpoint and writes the full list into the sheet, grouped and sorted.
Open the SheetXAI sidebar and type:
Fetch all Shippo carrier parcel templates and write the carrier, template name, token, and dimensions into my Carrier Packages reference sheet. Group rows by carrier.
SheetXAI calls Shippo's carrier parcel template list, retrieves every template across all carriers, and writes carrier name, template name, token, length, width, and height into the sheet, grouped by carrier.
What You Get
A complete carrier package reference table for your team:
- Carrier — USPS, FedEx, UPS, DHL, and any others in your Shippo account
- Template name — the human-readable name like "USPS Flat Rate Envelope" or "FedEx Small Box"
- Token — the
package_codeyour team needs to pass when creating a shipment - Dimensions — length, width, height so your team can match the physical package to the right template
The table is sortable and filterable. Your team can filter to "USPS" and instantly see every flat-rate option without touching Shippo's documentation.
What If the Data Is Not Quite Ready
Carrier template lists sometimes need massaging before they are usable as a reference. SheetXAI handles it in the same prompt.
When you want the table sorted by carrier, then by template name within each carrier
The raw API returns templates in a mixed order that makes the reference hard to scan.
Fetch all Shippo carrier parcel templates and write carrier, template name, token, and dimensions into my Carrier Packages reference sheet. Sort rows first by carrier alphabetically, then by template name alphabetically within each carrier.
When you want to add a "best for" notes column
Your team ships mostly soft goods and small electronics. You want a column flagging which templates are best suited for your product types.
Fetch all Shippo carrier parcel templates and write carrier, template name, token, and dimensions into my Carrier Packages reference sheet. Add a "Best For" column and fill it in based on the template dimensions: packages under 1 lb as "soft goods or documents," packages 1 to 5 lb as "small electronics or accessories," and larger packages as "general goods."
When you only want templates from specific carriers
Your account only has USPS and FedEx activated. You do not need UPS or DHL templates cluttering the reference.
Fetch all Shippo carrier parcel templates for USPS and FedEx only. Write carrier, template name, token, and dimensions into my Carrier Packages reference sheet, grouped by carrier.
When you want to pull the template list and cross-reference against which ones your team has actually used in the last 90 days
You want to flag templates that appear in Shippo but have never been used, so you can trim the reference to what is actually relevant.
Fetch all Shippo carrier parcel templates and write them into the Templates tab of my Carrier Packages sheet. Then fetch all Shippo transactions from the last 90 days and check which package codes appear. In the Templates tab, add a "Used in Last 90 Days" column and mark each template "yes" or "no" based on whether it appears in the transaction data.
The pattern: fetch the reference data and annotate it with usage history in one prompt. Your team gets a reference table that reflects actual behavior.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet, then ask it to fetch all Shippo carrier parcel templates into a reference table. The Shippo integration is included in every SheetXAI plan. For related workflows, see how to create user parcel templates from a box sizes sheet or the Shippo in Google Sheets overview.