The Scenario
You are a packaging coordinator at a mid-size e-commerce company. Your fulfillment team codes every outbound order with a ShipEngine carrier package type code. The problem: the reference list is out of date. Last time someone printed it was eight months ago. Two new carrier accounts have been added since then and nobody knows their package codes.
Wrong codes mean label failures. Label failures mean missed pickups. Missed pickups mean the customer gets the package late and files a complaint.
You need an up-to-date reference table in Excel listing all available package types for your UPS, FedEx, and USPS accounts — name, code, and dimensions — before the Thursday warehouse walkthrough.
The bad version of building this table:
- Log into ShipEngine
- Navigate to the carrier settings for each account
- Screenshot the package types page
- Manually type the codes and names into the workbook
- Ninety minutes later, you have a table that is already one step removed from the source of truth.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads your connected carrier accounts from ShipEngine and pulls the actual available package types directly.
Open the SheetXAI sidebar and type:
Get all available ShipEngine package types for FedEx and USPS and paste them into my Package Reference Excel workbook — separate them into two named tables, one per carrier, with columns for package name, code, and dimensions.
SheetXAI calls ShipEngine's carrier package type endpoints and writes the results into the workbook, organized as separate tables per carrier. The reference is accurate to your account's current configuration.
What You Get
Two named tables in the Package Reference workbook:
- FedEx table — package name, code, and dimensions for all FedEx package types on your account
- USPS table — same structure for USPS
These reflect your connected accounts, not a generic catalog. If your FedEx contract includes package types not in the standard catalog, they show up here.
What If the Data Is Not Quite Ready
Reference tables need to be structured for the people who actually use them. SheetXAI builds the right format in the same prompt.
When you want all carriers in one flat table instead of separate named tables
The team prefers one sortable table they can filter by carrier.
Fetch all ShipEngine package types for UPS, FedEx, and USPS. Write them into a single flat table in the Package Reference tab with columns for Carrier, Package Name, Code, and Dimensions. Sort alphabetically by carrier.
When you want max weight added to each package type row
The ops team picks packages by weight limit, not by name.
Fetch all ShipEngine package types for UPS and FedEx. Write package name, code, dimensions, and max weight into the Package Reference workbook. For any package where ShipEngine does not return a max weight, write 'check carrier' in that cell.
When you want to flag which types are enabled for your account versus catalog-only
Some package types are in ShipEngine's catalog but not configured for your carrier contract.
Fetch all ShipEngine package types for UPS, FedEx, and USPS and write name, code, and dimensions into the Package Reference tab. Add a column indicating whether each type is active on my account or catalog-only.
When you need to refresh the reference table and pull the past week's label usage at the same time
You want to see which package types were actually used last week alongside the current reference.
Refresh the Package Types tab with all current ShipEngine package types for UPS, FedEx, and USPS — columns for carrier, name, code, dimensions. Then fetch all ShipEngine labels from the past 7 days and write the distinct package codes used into a Used This Week tab. In the Package Types tab, add a column flagging whether each code was used in the past 7 days.
The pattern: pull reference data and usage data together so the Thursday walkthrough has current numbers.
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 workbook. 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 Excel overview.