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 a Google Sheet 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. Until they are, your segmentation by spend tier is useless.
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 sitting in the Sheet.
The fast version imports all 600 before the weekend.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet 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 sheet, 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. The customers are in MailerLite with their spend data, ready for segmentation.
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 Sheet and MailerLite. If a customer's spend changes — they make another purchase — you update column D and tell SheetXAI to push the updated spend 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 into column E 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 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.
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 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 or SKIPPED into column E for rows below the threshold.
When you want a summary at the end showing how many were created successfully 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 sheet, 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 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 Sheet 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 or the MailerLite in Google Sheets overview.