The Scenario
You are a Shopify store owner. Your seasonal collection launches in four days. You have 150 new products in a Google Sheet — product ID, name, price, image URL, and category — assembled by your merchandising team over the past two weeks.
They need to be in Omnisend before the campaign emails go out, because Omnisend's product block pulls from its own product catalog. If the products are not in Omnisend, the campaign template cannot render them.
The bad version of this week:
- You look for a product CSV import in Omnisend
- Realize there is not one — products go in via API
- Open the API docs, look up the product object schema
- Start writing a script, or try to find someone who can
- Run it, get errors on 30 rows where the image URL format is not what Omnisend expects
- Fix the errors, re-run
- The campaign is delayed by a day because the product catalog was not ready.
The fast version is one prompt and the catalog is in Omnisend before you finish your next standup.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the sheet 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:
Create an Omnisend batch job to add all 150 products from this sheet — product ID from column A, name from column B, price from column C, image URL from column D, and category from column E.
SheetXAI reads the sheet, builds the batch product payload, fires the request, and confirms the job is running. The catalog lands in Omnisend before the creative team finishes the email copy.
What You Get
A single Omnisend batch product import covering all 150 rows:
- Product ID — used as Omnisend's external product identifier so updates later are clean
- Name — as listed in the sheet, no reformatting needed
- Price — numeric, mapped to Omnisend's price field
- Image URL — mapped to the product image so campaign blocks render correctly
- Category — mapped so Omnisend's segmentation rules can reference product category
All 150 products go in one batch, not one API call per row. SheetXAI uses the batch endpoint specifically so the import runs as a single job rather than 150 individual requests.
If you need the Omnisend product IDs written back to the sheet for reference, ask SheetXAI to pull the batch result and populate a column F with the returned IDs.
What If the Data Is Not Quite Ready
Product sheets assembled by a merchandising team are almost always slightly wrong. SheetXAI fixes them inline.
When image URLs are missing the protocol
Some URLs start with "www." instead of "https://" and Omnisend rejects them.
Before importing, fix all image URLs in column D: any URL that starts 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 number.
Strip currency symbols and comma separators from all values in column C so they are plain numeric decimals. Then create the Omnisend batch product import.
When some products are missing a category
About 20 rows have a blank category. You still want to import them, but you want a placeholder category so Omnisend does not reject the payload.
For any row where column E is blank, set the category to "Uncategorized" before building the import payload. Then run the Omnisend batch product import and write the batch job ID into cell G1.
When the sheet needs deduplication and cleanup before import
The merchandising team worked in parallel and submitted products from two different files. Some product IDs appear twice with slightly different names.
Deduplicate column A by product ID, keeping the row with the longer product name (assume it is the more complete version). Fix any image URLs missing "https://". Strip currency symbols from prices. Then run the Omnisend batch product import and write the job ID into cell G1.
The pattern: the cleanup and the import are one instruction. SheetXAI does not require a clean sheet as a precondition.
Try It
Get the 7-day free trial of SheetXAI and open any product catalog sheet, 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 Google Sheets overview.