The Scenario
You are a fashion brand's e-commerce coordinator. You just connected MailerLite to your custom storefront, and your marketing lead wants product-recommendation emails running by end of week. Those emails need a product catalogue in MailerLite to pull from.
You have 300 products across 15 categories in a Google Sheet. The Categories sheet has category name in column A. The Products sheet has product name in column A, price in column B, category in column C, product URL in column D, and image URL in column E.
The bad version:
- You log into MailerLite's e-commerce section and look for a bulk product import
- There is no CSV import for products — the UI only supports adding products one at a time
- You contact support, who confirm you need to use the API
- You spend Wednesday getting a developer to write the import script
- The developer gets to it Friday
- Product-recommendation emails do not run this week, and the campaign launches without them.
The fast version imports everything from the Sheet on Thursday before lunch.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that calls the MailerLite e-commerce API for categories and products in bulk — no script, no developer, no delay.
Open the SheetXAI sidebar and type:
Import all product categories from my 'Categories' sheet into MailerLite shop [ID] using category name in column A. Then bulk import the products in my 'Products' sheet using name in column A, price in column B, category in column C, product URL in column D, and image URL in column E — write the MailerLite product ID into column F for each successful import.
SheetXAI creates the categories first, then imports all 300 products and writes the MailerLite product ID into column F. By Thursday afternoon you have a complete catalogue in MailerLite and the product-recommendation emails can be configured.
What You Get
A complete MailerLite product catalogue built from the Sheet:
- 15 categories created in MailerLite from the Categories sheet
- 300 products imported with name, price, category, URL, and image URL
- MailerLite product ID written into column F for every successful import
- No developer needed — the whole operation runs from the SheetXAI sidebar
The product ID in column F is what links your Sheet to MailerLite. If a product needs to be updated later, you reference it by the ID in the Sheet — no hunting through the MailerLite UI.
What If the Data Is Not Quite Ready
Product catalogues exported from other platforms are never clean. SheetXAI handles normalization and import in the same prompt.
When prices are in the wrong format
The export has prices like "$79.00" with currency symbols embedded.
Strip the currency symbol from column B in the Products sheet and convert to a plain decimal. Then import all product categories from the Categories sheet into MailerLite shop [ID] and import all products from the Products sheet. Write the MailerLite product ID into column F.
When some products are missing image URLs
A subset of products has not been photographed yet. You want to import them without image URLs rather than skipping them.
Import all product categories from the Categories sheet into MailerLite shop [ID]. For each product in the Products sheet, import using name in column A, price in column B, category in column C, and product URL in column D. If column E (image URL) is blank, import without an image. Write the MailerLite product ID into column F or ERROR into column F if the import fails.
When you only want to import products from specific categories for launch week
The full catalogue has 300 products but launch week only features three hero categories.
Import only products from the Products sheet where column C is 'Outerwear', 'Denim', or 'Knitwear' into MailerLite shop [ID] using name in column A, price in column B, product URL in column D, and image URL in column E. Write the MailerLite product ID into column F.
When the catalogue has been updated and you need to reimport changed products
Some product prices were updated after the initial import. You need to push the changes without recreating the whole catalogue.
For each row in the Products sheet where column G says 'Updated', update the MailerLite product using the ID in column F. Set the new price from column B and the new product URL from column D. Write UPDATED or ERROR into column H.
The pattern: describe what you want imported and what to write back. SheetXAI handles the API calls and the record-keeping in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any Sheet with product data, then ask it to push the catalogue into your MailerLite shop. The MailerLite integration is included in every SheetXAI plan. For related workflows, see how to import historical orders into MailerLite or the MailerLite in Google Sheets overview.