The Scenario
You are the ops coordinator at a fulfillment warehouse. Your facility ships with 8 standard box sizes. Every time someone creates a shipment in Shippo, they re-enter the dimensions from a laminated reference sheet on the wall. Last week someone read the wrong row and a shipment got the wrong box size, which meant a repack and a missed pickup.
You want all 8 sizes registered as Shippo user parcel templates so anyone creating a shipment can select a template by name and never re-enter dimensions again.
The box dimensions are in an Excel workbook on the Standard Packages tab: template name in column A, length in column B, width in column C, height in column D (all in inches), and max weight in column E.
The slow version:
- You open Shippo's parcel templates section
- You click "Add template," fill in name and dimensions for template one
- You save it, go back, click "Add template" for template two
- Eight templates, eight trips through the same form.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the box sizes workbook and creates all 8 Shippo parcel templates in one go.
Open the SheetXAI sidebar and type:
Read my Standard Packages tab and create Shippo parcel templates for each row, then write the returned template ID into column G.
SheetXAI reads the 8 rows, creates each one as a Shippo user parcel template, and writes the returned template ID into column G.
What You Get
Eight reusable parcel templates in Shippo with IDs in the workbook:
- Column G — the Shippo template ID for each box size
- Templates available by name — future prompts can say "use the Medium Flat Box template" and SheetXAI will look it up
- No dimension re-entry — every shipment using one of these templates inherits length, width, height, and max weight from the template record
One-time setup, permanent reuse. The next time you create 200 shipments, you reference the template name, not the ruler.
What If the Data Is Not Quite Ready
Box dimension workbooks are usually tidy, but edge cases happen. SheetXAI handles them inline.
When dimensions are stored in centimeters and Shippo needs inches
Your internal standard is metric. Shippo's default for user templates is inches.
Convert the dimensions in columns B, C, and D of my Standard Packages tab from centimeters to inches before creating the Shippo parcel templates. Round to two decimal places. Write the converted values back into those columns and write the template ID into column G.
When you want to add a notes field to each template for warehouse staff
You want each template to describe which product lines it is best for so staff can find the right one quickly.
For each row in my Standard Packages tab, create a Shippo user parcel template using columns A through E. Use the notes in column F as the template description. Write the template ID into column G.
When some templates already exist and you only want to create the new ones
You added 3 new box sizes this week. The other 5 are already in Shippo.
Skip any row in my Standard Packages tab that already has a value in column G. For rows where column G is empty, create a Shippo user parcel template using columns A through E and write the new template ID into column G.
When you want to create the templates and build a printed quick-reference card for the warehouse in one shot
Your warehouse manager wants a reference card with template name, dimensions, and ID posted at each packing station.
Create Shippo user parcel templates for all rows in my Standard Packages tab where column G is empty. Write the template ID into column G. Then create a new tab called "Quick Reference" with three columns: Template Name (from column A), Dimensions (formatted as LxWxH inches from columns B, C, D), and Shippo Template ID (from column G). Sort by template name alphabetically.
The pattern: create the templates and build the warehouse reference artifact in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with standard box dimensions, then ask it to create Shippo user parcel templates for every row. The Shippo integration is included in every SheetXAI plan. For related workflows, see how to list all carrier parcel templates into a reference workbook or the Shippo in Excel overview.