The Scenario
You are a fulfilment team lead. Today is Friday at 10 AM. The carriers arrive at 2 PM and you need a Zoho Inventory package record created for each of 50 confirmed sales orders before they get here.
The sales order IDs are already in your Google Sheet — column A. The quantity to ship is in column B. The package date is today.
The bad version of this Friday:
- You open Zoho Inventory and navigate to the first sales order
- You click "Create Package," enter the quantity, set today's date, save
- You move to the next order
- By order eleven the system is slow and you have been at this for forty minutes
- By order twenty-eight you have accidentally created two packages for order #5019 because you double-clicked
- At 1:45 PM you have forty-one packages done and the carriers are already in the yard.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads the order IDs and calls Zoho Inventory's package creation API for each one, then writes the package ID back into the sheet.
Open the SheetXAI sidebar and type:
Create a Zoho Inventory package for each sales order ID in column A of this sheet using quantity from column B and today's date as the package date. Write the returned package ID into column D. Flag any rows where the package creation fails in column E.
SheetXAI reads all 50 rows, creates one package per order, and writes the package IDs back into column D. Done before 11 AM.
What You Get
- 50 Zoho Inventory packages created, one per confirmed sales order
- Column D holds the package ID for each row — your record for shipping label generation and dispatch tracking
- Failures flagged in column E so you know which orders had a problem (order not confirmed, item quantity mismatch, etc.)
The package IDs in column D are the next step in the fulfilment chain. When the shipping team generates labels or records tracking numbers, they pull from these IDs. Having them in the sheet means no lookup step before dispatch.
If some orders need to be split into multiple packages because the full quantity does not fit in one box, include that logic in the prompt.
What If the Data Is Not Quite Ready
Real fulfilment runs always have edge cases. SheetXAI handles them before creating packages.
When some sales orders are not yet in "confirmed" status
The sheet includes orders that are still in "draft" or "pending" status. Creating a package for a non-confirmed order will fail.
For each sales order ID in column A, check the status in Zoho Inventory before creating a package. If the status is not "confirmed," write the current status into column E and skip that row. For confirmed orders, create the package with quantity from column B and today's date, and write the package ID into column D.
When quantities in column B exceed the available item stock
Some orders cannot be fully packed because inventory is short. You want to know before the carriers arrive.
For each sales order ID in column A, check whether the quantity in column B is available in Zoho Inventory stock. If the stock is insufficient, write "STOCK SHORT — available: [qty]" into column E and skip the package creation. For fully stocked orders, create the package and write the package ID into column D.
When you need to split large orders into multiple packages with a maximum of 10 units per box
Your packing constraint is ten units per box. Orders with more than ten units need multiple package records.
For each sales order in column A with a quantity in column B greater than 10, create multiple Zoho Inventory packages — each with a maximum quantity of 10 — until the full order quantity is covered. Write all returned package IDs into column D, separated by commas, so you know how many boxes each order needs.
When you also need to add a shipping carrier and tracking number to each package immediately
The carriers are handing you tracking numbers as they pick up each box. You want to record the tracking number in Zoho Inventory at the same time as you create the package.
Create a Zoho Inventory package for each sales order ID in column A with quantity from column B and today's date. After creating each package, update it with the carrier name from column C and the tracking number from column D. Write the package ID into column E.
The pattern: the order list is the input, the package records are the output, and the tracking chain is maintained from the moment the box leaves the dock.
Try It
Get the 7-day free trial of SheetXAI and open any pick list with sales order IDs, then ask it to create Zoho Inventory packages for each one. The Zoho Inventory integration is included in every plan. For the upstream step, see how to export open sales orders for pick planning or the Zoho Inventory in Google Sheets overview.