The Scenario
You are a packaging coordinator at a mid-size e-commerce company. Your fulfillment team codes every outbound order with a carrier package type: "ups_letter," "fedex_pak," "usps_large_flat_rate_box." The codes come from ShipEngine.
The problem: nobody has a complete, current reference list. Reps guess. Wrong package codes cause label failures. And every time you add a new carrier account, the list is out of date before you print it.
You need a definitive reference table in Google Sheets listing all available UPS and FedEx package types — name, code, and dimensions — that the team can sort and search.
The bad version of building this table:
- Log into ShipEngine's developer docs
- Find the list of package type codes for UPS
- Copy them out manually into the sheet
- Repeat for FedEx
- Realize the docs are not the same as what your account has enabled
- Check your ShipEngine account settings to find the actual available types
- Spend 90 minutes on something that should take 5.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads your connected carrier accounts from ShipEngine and pulls the actual available package types, not the docs.
Open the SheetXAI sidebar and type:
Fetch all carrier package types for UPS from ShipEngine and write package name, code, and dimensions into my UPS Package Types sheet as a reference table. Then do the same for FedEx in my FedEx Package Types sheet.
SheetXAI calls ShipEngine's carrier package type endpoints and writes the results into the two named sheets. Your reference table reflects what your account actually has access to, not a generic docs page.
What You Get
Two populated reference tables, one per carrier:
- Package name — the human-readable label (e.g. "UPS Express Box")
- Package code — the ShipEngine API code the fulfillment team uses (e.g. "ups_express_box")
- Dimensions — where ShipEngine returns them, listed as length × width × height
These are the package types enabled for your specific carrier accounts, not a universal list. If you added a new package type agreement with FedEx last month, it shows up here. The reference table is accurate to the day you run the prompt.
What If the Data Is Not Quite Ready
Reference tables need to be structured for the people who use them. SheetXAI builds the right structure in the same prompt.
When you want all carriers in one sheet instead of separate tabs
The fulfillment team prefers one sorted list they can filter by carrier.
Fetch all ShipEngine package types for UPS, FedEx, and USPS. Write them all into my Package Reference sheet with a Carrier column, a Package Name column, a Code column, and a Dimensions column. Sort by carrier alphabetically.
When you want to add a "Max Weight" column alongside the package types
Some packages have weight limits the team needs to see when picking the right box.
Fetch all ShipEngine package types for UPS and FedEx. Write package name, code, dimensions, and maximum weight into my Package Types sheet. For any package where ShipEngine does not return a max weight, write 'check carrier' in that cell.
When you need to flag which package types are enabled for your account versus which are in the ShipEngine catalog but not active
Some package types are available in ShipEngine's catalog but not configured for your carrier account.
Fetch all ShipEngine package types for UPS and FedEx and write package name, code, and dimensions into my Package Reference sheet. Add a column indicating whether each package type is active on my account or catalog-only.
When the reference table needs to be refreshed automatically alongside a weekly operations pull
You pull operations data every Monday and want the package type reference refreshed at the same time.
Fetch all ShipEngine package types for UPS, FedEx, and USPS and refresh the Package Types tab with the current list — name, code, dimensions. Then pull all ShipEngine labels created in the past 7 days and write label ID, carrier, service code, package code, and cost into the Weekly Labels tab.
The pattern: pull reference data and operational data in one prompt so the context is always current.
Try It
Get the 7-day free trial of SheetXAI and ask it to fetch your ShipEngine carrier package types and write them into a reference sheet. The ShipEngine integration is included in every SheetXAI plan. For related workflows, see how to export LTL carrier services to a reference table or the ShipEngine in Google Sheets overview.