The Scenario
You are a Shopify store owner. The seasonal collection launches in four days. You have 150 new products in an Excel workbook — product ID, name, price, image URL, and category — put together by your merchandising team over the past two weeks.
They need to be in Omnisend before the campaign emails go out. Omnisend's product block pulls from its own product catalog, and if the products are not there, the campaign template cannot render them.
The bad version of this week:
- You look for a product CSV import in Omnisend — there is not one
- Find the API docs, look up the product object schema
- Start writing a script, or find someone who can
- Run it, get errors on rows where the image URL format is not what Omnisend expects
- Fix the errors, re-run
- The campaign goes out a day late because the product catalog was not ready.
The fast version is one prompt and the catalog is in Omnisend before your next standup.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the workbook and calls Omnisend's batch product API so you do not have to write a script or learn the product object schema.
Open the SheetXAI sidebar and type:
Read my Excel product catalog (150 rows: SKU, Title, Price, Stock Status, Category URL) and bulk-create all products in Omnisend using the batch API in one shot.
SheetXAI reads the workbook, maps the columns to Omnisend's product schema, builds the batch payload, and fires the request. All 150 products go in as a single batch job.
What You Get
A single Omnisend batch product import covering all 150 rows:
- Product ID — mapped so future updates replace rather than duplicate
- Name — as listed in the workbook
- Price — numeric, mapped to Omnisend's price field
- Image URL — mapped so campaign product blocks render correctly
- Category — mapped for Omnisend segmentation rules
One batch request, not 150 individual API calls. SheetXAI uses the batch endpoint so the import runs as a single job with a trackable status.
If you need the returned Omnisend product IDs written back to the workbook, ask SheetXAI to pull the batch result and populate a new column.
What If the Data Is Not Quite Ready
Merchandising workbooks are almost always slightly wrong. SheetXAI fixes them inline.
When image URLs are missing the protocol
Some URLs start with "www." and Omnisend rejects them without "https://".
Before importing, fix all image URLs in column D: any URL starting with "www." should be prepended with "https://". Then run the Omnisend batch product import.
When prices have currency symbols or comma separators
The merchandising team pasted prices as "$1,499.00" and Omnisend expects a plain decimal.
Strip currency symbols and comma separators from column C so all values are plain numeric decimals. Then create the Omnisend batch product import.
When some products are missing a category
About 20 rows have blank category. You want to import them with a placeholder so the payload does not fail validation.
For any row where column E is blank, set the category to "Uncategorized" before building the import payload. Run the Omnisend batch product import and write the job ID into cell G1.
When the workbook needs deduplication and cleanup before import
The team worked in parallel files and merged them. Some product IDs appear twice with slightly different names.
Deduplicate column A by product ID, keeping the row with the longer product name. Fix any image URLs missing "https://". Strip currency symbols from prices. Then run the Omnisend batch product import and write the job ID into G1.
The pattern: cleanup and import in one instruction. SheetXAI does not require a clean workbook as a precondition.
Try It
Get the 7-day free trial of SheetXAI and open any product catalog workbook, then ask it to push the data to Omnisend. The Omnisend integration is included in every SheetXAI plan. For related workflows, see how to replace stale product data in Omnisend or the Omnisend in Excel overview.