The Scenario
You are the e-commerce coordinator at a boutique DTC brand. You just connected MailerLite to your handbuilt checkout and you have 600 existing customers in an Excel workbook exported from your old system — email in column A, first name in column B, last name in column C, and total lifetime spend in column D.
MailerLite's campaign segmentation lets you target by customer spend tier. But it can only do that if those 600 customers are in MailerLite as e-commerce customers, not just subscribers.
The bad version:
- You look for a CSV import for e-commerce customers in MailerLite's UI
- There is none — the UI only supports subscriber imports
- You find the e-commerce customers API endpoint in the docs
- You ask a developer to write the import script
- The developer estimates two days
- The first spend-tier campaign goes out this weekend to 11,000 subscribers, none of them segmented by LTV because the 600 customer records are still in the workbook.
The fast version imports all 600 before the weekend.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that calls the MailerLite e-commerce customers API row by row and writes the created customer IDs back — no script, no developer, no delay.
Open the SheetXAI sidebar and type:
For each row in this workbook, create a MailerLite e-commerce customer in shop [ID] using email in column A, first name in column B, last name in column C, and total spent in column D — write the MailerLite customer ID into column E.
SheetXAI reads the 600 rows, calls the MailerLite e-commerce customers API for each one, and writes the created customer ID into column E. Spend-tier segmentation is available immediately.
What You Get
600 e-commerce customers created in MailerLite with LTV data:
- Email, first name, last name — standard subscriber fields
- Total spent — set as the customer's spend value for segmentation
- MailerLite customer ID written into column E for every successful import
- Spend-tier segmentation available immediately in MailerLite campaigns
The customer ID in column E is your link between the workbook and MailerLite. If a customer's spend changes, you update column D and push the updated value using the ID in column E.
What If the Data Is Not Quite Ready
Customer exports from old platforms are never clean. SheetXAI handles normalization and the import together.
When the spend column has currency symbols
The export has values like "$329.50" with the dollar sign in the number column.
Strip the currency symbol from column D and convert to a plain decimal. Then for each row, create a MailerLite e-commerce customer in shop [ID] using email in column A, first name in column B, last name in column C, and cleaned spend in column D. Write the MailerLite customer ID into column E or ERROR if the import fails.
When some rows have missing first or last names
A subset of records came from a checkout that only required an email address.
For rows where column B or C is blank, use 'Unknown' as the placeholder first or last name. Then for each row, create a MailerLite e-commerce customer in shop [ID] using columns A–D. Write the MailerLite customer ID into column E.
When you only want customers above a spend threshold
You only want to import customers who have spent more than $50 so the segmentation tiers are meaningful.
Filter to rows where column D is greater than 50. Create a MailerLite e-commerce customer in shop [ID] for each filtered row. Write the MailerLite customer ID into column E or SKIPPED for rows below the threshold.
When you want a summary at the end showing how many were created and the total LTV imported
The marketing lead wants to know the total lifetime value now in MailerLite as a sanity check.
For each row in this workbook, create a MailerLite e-commerce customer in shop [ID] using columns A–D. Write SUCCESS or FAILED into column F. After all imports are done, add a summary row showing how many were created successfully and the total lifetime value of all successful imports.
The pattern: import the customers, write the IDs back, and optionally confirm the aggregate — all in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with customer records, then ask it to import them into your MailerLite shop as e-commerce customers. The MailerLite integration is included in every SheetXAI plan. For related workflows, see how to import historical orders into MailerLite from Excel or the MailerLite in Excel overview.