The Scenario
You just landed a wholesale deal that means 200 new products go live next week. The supplier sent the catalog as an Excel file, which you've cleaned up and moved into a Google Sheet — titles, descriptions, vendors, prices, SKUs, all there, all formatted. What's not there: any of it is actually in Shopify.
The bad version:
- Open Shopify's product CSV import template, re-map your columns to match the template's exact order, and save the file.
- Upload the CSV, wait for the import report, and find that 14 rows errored because of a formatting issue in the description field.
- Fix the 14 rows, re-upload, then manually verify a sample of the created products to make sure the vendor and price fields landed in the right place.
You have until Thursday before the campaign goes live and the product pages need to exist. There's no time budgeted for a CSV archaeology session.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your product data and talks to Shopify directly — no CSV export, no column-order memorization, no import template. You tell it what to do.
Create a Shopify product for each row in my Product Catalog sheet using column A for title, B for description, C for vendor, D for price, and E for SKU — write the returned product ID into column F
What You Get
- A Shopify product created for each row, with the product ID written back into column F so you have a direct reference.
- Any rows that fail get flagged in column F with the error message, so you know exactly which ones need attention.
- The products appear in your Shopify admin immediately, ready for collection assignment and publishing.
What If the Data Is Not Quite Ready
The description field has HTML from the supplier's system
Create Shopify products for each row in my Product Catalog sheet — strip any HTML tags from column B before writing to the product description — use columns A, C, D, and E for title, vendor, price, and SKU
Prices are in euros but the store is in USD
Create Shopify products for each row in my Product Catalog sheet, converting column D from EUR to USD at 1.08 — use columns A, B, C, and E for title, description, vendor, and SKU — write the product ID into column F
Products span two tabs that need to be merged
Create Shopify products for all rows in both the Catalog-A sheet and the Catalog-B sheet — use column A for title, B for description, C for vendor, D for price, E for SKU in both — write the Shopify product ID back into column F of whichever tab each row came from
Clean descriptions, convert prices, skip rows already imported, and write back status
For each row in my Product Catalog sheet where column F is blank, create a Shopify product using column A for title, B for description (strip HTML), C for vendor, D for price (convert EUR to USD at 1.08), and E for SKU — write the product ID into column F and 'skipped' for any row that already has a product ID
Running cleanup and creation in a single prompt means you're not doing a separate pass to normalize the data before you try to import it.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where your Shopify product catalog lives, then ask it to create the products from your existing rows. When the next batch arrives from a supplier, you'll use the same prompt again. Also worth reading: how to bulk update prices once the products are live, or the hub overview for all Shopify workflows.