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 a Google Sheet. Column A has the email addresses.
The bad version:
- You open MailerLite and search for the first email
- You click into the subscriber profile, find the Groups section, 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 the bulk actions in MailerLite's UI — it supports 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 that both ran on the same rows
- On Monday, three subscribers receive the re-engagement sequence while still flagged as active customers because they fell through the gap.
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 spreadsheet that handles per-subscriber group moves in one operation and writes the outcome back so you can verify the whole 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 the subscriber from one group and add them to the other, and writes the outcome per row. If a subscriber is not found — because the email never existed or was already deleted — NOT_FOUND lands in column B and you know exactly which rows need investigation.
What You Get
1,500 subscribers moved between groups, with outcomes in the Sheet:
- Remove from 'Active Customers' — one API call per subscriber
- Add to 'Win-Back' — in the same pass, not a separate operation
- MOVED or NOT_FOUND written into column B per row
- No manual cross-check — the outcome in the Sheet is the record
The NOT_FOUND flag is what saves you. If 43 emails in your Sheet never made it into MailerLite because they bounced at signup, you find out now — before the re-engagement sequence runs on a list with 43 ghosts in it.
What If the Data Is Not Quite Ready
Churn lists come from CRM exports that are never perfectly aligned with MailerLite subscriber records. SheetXAI handles the gaps inline.
When the email column has inconsistent formatting
The CRM export has mixed case and some trailing spaces. MailerLite lookups are case-insensitive but SheetXAI can normalize first.
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 already has a churn reason — 'price' or 'feature gap' or 'competitor'. You want different win-back groups for each.
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 unsubscribe churned subscribers from the product newsletter
The win-back group gets re-engagement emails. But the product newsletter is for paying customers only and churned accounts should be removed from that too.
For each email in column A, remove from MailerLite group '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 pull the new group counts to confirm
After the move, the head of marketing wants to see the 'Win-Back' group size versus 'Active Customers' group size 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 — all without touching the MailerLite UI.
Try It
Get the 7-day free trial of SheetXAI and open any Sheet 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 or the MailerLite in Google Sheets overview.