The Scenario
You are on the customer success team at a B2B SaaS company. 1,500 accounts cancelled last quarter. Your head of marketing wants every one of them moved from the 'Active Customers' MailerLite group to the 'Win-Back' group so the re-engagement sequence can start this week.
The churned account emails are in an Excel workbook. Column A has the email addresses.
The bad version:
- You open MailerLite and search for the first email
- You click into the subscriber profile, remove 'Active Customers', add 'Win-Back'
- You do this for subscriber two
- You realize on subscriber four that this will take the rest of the week
- You look into MailerLite's bulk actions — they support adding to a group in bulk but not moving between groups in one operation
- You end up doing the removal in one bulk action and the add in a second, then manually cross-checking both ran on the same rows
- On Monday, three subscribers receive the re-engagement sequence while still flagged as active customers.
The fast version is one prompt and every subscriber is moved in a single pass.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that handles per-subscriber group moves in one operation and writes the outcome back so you can verify the batch.
Open the SheetXAI sidebar and type:
For each email in column A, remove them from MailerLite group 'Active Customers' and add them to group 'Win-Back' — write MOVED or NOT_FOUND into column B.
SheetXAI reads every row, calls the MailerLite API to remove and add the subscriber in one pass, and writes the outcome per row. If a subscriber is not found, NOT_FOUND lands in column B.
What You Get
1,500 subscribers moved between groups, with outcomes in the workbook:
- Remove from 'Active Customers' and Add to 'Win-Back' in a single pass per subscriber
- MOVED or NOT_FOUND written into column B per row
- No manual cross-check — the outcome in the workbook is the record
The NOT_FOUND flag is what saves you. If 43 emails never made it into MailerLite, you find out now — before the re-engagement sequence runs on a list with ghosts in it.
What If the Data Is Not Quite Ready
Churn lists from CRM exports are never perfectly aligned with MailerLite subscriber records.
When the email column has inconsistent formatting
The CRM export has mixed case and some trailing spaces.
Trim whitespace from column A and convert to lowercase. Then for each email, remove from MailerLite group 'Active Customers' and add to 'Win-Back'. Write MOVED or NOT_FOUND into column B.
When some subscribers need to go to a different group based on churn reason
Column B has a churn reason — 'price' or 'feature gap' or 'competitor'.
For each row, remove the email in column A from MailerLite group 'Active Customers'. If column B says 'price', add them to 'Win-Back: Price Offer'. If column B says 'feature gap', add them to 'Win-Back: Roadmap'. Otherwise add them to 'Win-Back: General'. Write the outcome into column C.
When you want to also remove churned subscribers from the product newsletter
The product newsletter is for paying customers only.
For each email in column A, remove from MailerLite groups 'Active Customers' and 'Product Newsletter', then add to 'Win-Back'. Write MOVED or NOT_FOUND into column B.
When you want a full audit: move the subscribers, then confirm the new group counts
After the move, the head of marketing wants to see the 'Win-Back' group size versus 'Active Customers' for the weekly update.
For each email in column A, remove from MailerLite group 'Active Customers' and add to 'Win-Back'. Write MOVED or NOT_FOUND into column B. After all moves are done, fetch the subscriber count for both groups and write the group name and count into columns D and E as a summary.
The pattern: one prompt moves the subscribers, writes the outcome per row, and optionally confirms the result.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with email addresses that need to move between MailerLite groups, then ask it to run the batch move and write outcomes back. The MailerLite integration is included in every SheetXAI plan. For related workflows, see how to bulk import subscribers into MailerLite from Excel or the MailerLite in Excel overview.