The Scenario
Your online store launched its spring catalog three weeks ago. The 80 SKUs are all in an Excel workbook — product ID, name, category, price, and product URL — but none of them exist yet in Mailbluster's product catalog. You want to start using Mailbluster's revenue attribution features for the next campaign, and attribution requires the products to be in the system first. The campaign brief is already written. The products are not loaded.
The bad version:
- Open Mailbluster's product management interface and add each product one at a time through the form — product ID, name, URL, price, image URL
- Realize there's no bulk import option for products the way there is for leads — you're clicking through a form for each SKU
- After 20 products, you've been at it for 30 minutes and you have 60 left
Product catalog entry is not a marketing task. It shouldn't be on your plate at all, and yet here you are, manually transferring data that already exists in structured form in your workbook.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your product table and creates every Mailbluster product record through the API — no form clicking, no copy-pasting rows.
Excel 'Catalog' has product_id, name, category, price, and product_url for 80 rows — bulk-create all as Mailbluster products
What You Get
- All 80 rows are submitted to Mailbluster's product API
- product_id, name, price, and product_url are mapped to the correct Mailbluster fields automatically
- A status column is written back to the workbook confirming which products were created and flagging any that failed due to duplicate IDs or missing required fields
What If the Data Is Not Quite Ready
Some rows are missing product URLs
Excel 'Catalog' columns: product_id, name, category, price, product_url — skip any rows where product_url in column E is blank and create Mailbluster products for all remaining rows; note skipped rows in column F
Prices are stored as text with currency symbols
Excel 'Catalog' — strip the dollar sign from the price column and convert to numeric, then bulk-create all products in Mailbluster using the cleaned price
Products span two worksheets — core and seasonal
Worksheets 'Core' and 'Seasonal' both have product_id, name, price, product_url in the same column order — combine and create all as Mailbluster products, skipping duplicate product_ids
Full clean-and-load in one shot
Excel 'Catalog' — remove rows with blank product_id or blank product_url, strip currency symbols from price, deduplicate by product_id, bulk-create all remaining rows as Mailbluster products, write status to column F
Cleanup and creation in the same prompt — no intermediate export steps.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook holding your product catalog, then ask it to load every product into Mailbluster before your next campaign. See also how to bulk update product details once the catalog is live, or return to the Mailbluster overview.