The Scenario
Your online store launched its spring catalog three weeks ago. The 150 SKUs are all in a Google Sheet — product ID, name, URL, price, image URL, description — 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 130 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 sheet.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your product table and creates every Mailbluster product record through the API — no form clicking, no copy-pasting rows.
Sheet 'Products' has columns: product_id, name, url, price, image_url, description — create all 150 products in Mailbluster
What You Get
- All 150 rows are submitted to Mailbluster's product API
- product_id, name, url, price, image_url, and description are mapped to the correct Mailbluster fields automatically
- A status column is written back to the sheet 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 image URLs
Sheet 'Products' columns: product_id, name, url, price, image_url, description — where image_url in column E is blank, substitute a default placeholder URL "https://sheetxai.com/placeholder.png" and create all products in Mailbluster
Prices are stored as text strings with currency symbols
Sheet 'Products' — strip the dollar sign from column D and convert to a numeric value, then create all products in Mailbluster using the cleaned price
Products span two tabs — core catalog and seasonal items
Sheets 'Core Catalog' and 'Seasonal Items' both have product_id, name, url, price, image_url in the same column order — combine and create all as Mailbluster products, skipping any duplicate product_ids
Full clean-and-load in one shot
Sheet 'Products' — remove rows with blank product_id or blank url, strip currency symbols from price column, deduplicate by product_id, then bulk-create all remaining rows as Mailbluster products and write status to column G
The pattern: cleanup and creation in the same prompt, no intermediate steps.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet that holds 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.