The Scenario
You are the e-commerce manager at a DTC brand. You are launching a Mailchimp connected store for product-recommendation emails. 350 SKUs are sitting in an Excel product catalogue your merchandising team exported last week: product name, SKU, price, image URL, and inventory quantity.
The email strategist needs the products in Mailchimp before she can configure the recommendation block. Her setup call is on Thursday. It is Monday.
The bad version of this week:
- You read Mailchimp's e-commerce product API documentation
- You discover each product needs a product object and at least one variant object linked by ID
- You start writing a script to create them in pairs
- The variant creation step fails because you misread the required fields
- You fix it, rerun, and hit the API rate limit at product 180
- You walk into Thursday's setup call with 170 products still missing.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads your product catalogue and creates each product and variant in your Mailchimp store, with the Mailchimp product ID written back per row.
Open the SheetXAI sidebar and type:
For each row in my Products sheet, create a product in Mailchimp store ID in cell G1 using product name in column A, SKU in column B, price in column C, image URL in column D, and inventory quantity in column E. Create one variant per product using the SKU as the variant ID. Write the Mailchimp product ID into column F when created, or ERROR with the reason if it fails.
SheetXAI reads all 350 rows, calls the Mailchimp e-commerce API for each product, creates the product and variant, and writes the Mailchimp product ID or a specific error back to column F. No schema research, no rate-limit retry logic.
What You Get
350 rows processed, with column F showing the outcome:
- Mailchimp product ID — the product exists in your store and is eligible for recommendation emails
- ERROR — the specific failure: missing price, invalid image URL, store not found
The email strategist has her product catalogue by Monday afternoon. She walks into Thursday's call with a configured recommendation block, not a blank store.
Want to write a count of successfully created products in cell H1 so you can confirm coverage at a glance? Add it to the prompt.
What If the Data Is Not Quite Ready
Product catalogues from merchandising teams are rarely import-ready. SheetXAI handles data cleanup and the upload in the same prompt.
When prices are formatted as currency strings instead of numbers
Your catalogue has "$49.99" in the price column and Mailchimp expects 49.99 as a float.
Before creating products in Mailchimp, strip the $ sign and any commas from prices in column C and convert to a number. Then for each row, create a product in Mailchimp store ID in cell G1 using product name from column A, SKU from column B, and cleaned price from column C. Write the Mailchimp product ID into column F.
When some products have multiple variants in separate rows
The catalogue has one row per variant, not one row per product. You need to group variants under a parent product.
Group the rows in this sheet by product name in column A. For each unique product name, create a single Mailchimp product in store ID in cell G1 with a variant per SKU row. Use the first image URL in the group as the product image. Write the Mailchimp product ID next to the first row of each group in column F.
When some image URLs are broken or missing
The catalogue has blank image URL cells for 40 products and a handful of malformed URLs. You do not want those products to fail the import.
For any row in this sheet where column D is blank or does not start with http, skip the image URL when creating the Mailchimp product. Create the product without an image and write a flag "NO IMAGE" into column G. For rows with a valid image URL, include it as usual.
When you want to update existing products instead of creating duplicates
Some SKUs may already exist in the Mailchimp store from a previous partial upload. You want to update those rather than error out.
For each row in this sheet, check whether a product with SKU in column B already exists in Mailchimp store ID in cell G1. If it exists, update the price in column C and inventory quantity in column E. If it does not exist, create the product. Write CREATED, UPDATED, or ERROR into column F for each row.
The pattern: describe the conditional logic in the prompt. SheetXAI checks first and creates or updates based on what it finds, so you do not end up with duplicate products.
Try It
Get the 7-day free trial of SheetXAI and open your product catalogue sheet, then ask it to push the SKUs into your Mailchimp connected store. The Mailchimp integration is included in every plan. For related workflows, see how to import historical orders into a Mailchimp store or the Mailchimp in Google Sheets overview.