The Scenario
You are the operations lead at an export company. Every week you ship 45 international orders to 12 different countries. The items, values, quantities, and countries of origin are all in an Excel workbook on the Export Orders tab, one row per item, with the order ID in column A tying them together.
Before any international label can be purchased, Shippo needs a customs declaration for each shipment, with customs items attached. Without them, the labels are invalid and shipments will not clear customs.
The bad version:
- You open Shippo's customs creation UI
- You fill in the product description, value, quantity, and country of origin for each item in order one
- You create the customs declaration linking all items for that order
- You repeat this for all 45 orders
- It takes the better part of Wednesday afternoon and you still have to QA for typos.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the workbook and creates Shippo customs items and declarations for every order automatically.
Open the SheetXAI sidebar and type:
Read my Export Orders tab and create a Shippo customs declaration for each unique order ID in column A, linking the customs items from columns C through G. Write the customs declaration ID into column H.
SheetXAI reads the workbook, groups rows by order ID, creates customs item objects for each line item, assembles the declarations, and writes each customs declaration ID into column H.
What You Get
A complete customs paper trail in the workbook:
- Column H — the Shippo customs declaration ID for each unique order
- Customs items created — line-item records carrying product description, declared value, quantity, and country of origin
- Ready for label purchase — the declaration IDs in column H can be passed directly to Shippo when creating shipments
No manual customs entry. Your 45 declarations are ready before the Wednesday shipping window.
What If the Data Is Not Quite Ready
International order exports are rarely customs-ready. SheetXAI handles the cleanup and creation in the same prompt.
When product descriptions contain internal SKUs instead of readable names
Your export has "PROD-4421-BLK-M" in column C. Customs forms need a human-readable description.
For each row in my Export Orders tab, check the product description in column C. If it looks like an internal SKU, translate it to a plain-language product description before creating the Shippo customs item. Then create the customs declarations per order ID and write declaration IDs into column H.
When declared values are in the wrong currency
Your export has values in USD but EU-bound shipments need declared values in EUR for some customs authorities.
For each row in my Export Orders tab where the destination country in column B is in the EU, convert the declared value in column D from USD to EUR before creating the Shippo customs item. Write the customs declaration ID into column H for all orders.
When some rows are missing country of origin
A handful of rows have blank country of origin in column F.
For rows in my Export Orders tab where column F is blank, write "US" as the default country of origin before creating the Shippo customs item. Write a note in column I for any rows that used the default. Then create customs declarations per order and write declaration IDs into column H.
When you want to create customs items, create declarations, and write a per-order summary for your broker in one shot
Your broker needs a summary of each declaration, total declared value and item count.
For each row in my Export Orders tab, create a Shippo customs item using columns C through F. Then, for each unique order ID in column A, create a Shippo customs declaration linking all its customs items and write the declaration ID into column H. Create a new tab called "Declaration Summary" with one row per unique order showing order ID, item count, and total declared value.
The pattern: item creation, declaration assembly, and broker summary in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any international order workbook with product, value, quantity, and origin data, then ask it to create Shippo customs declarations for every order. The Shippo integration is included in every SheetXAI plan. For related workflows, see how to create Shippo orders from a sales orders workbook or the Shippo in Excel overview.