The Scenario
You are the email lead at a SaaS company. You have 2,000 subscribers in a Mailcoach list, each tagged with their product tier: free, pro, or enterprise. The campaigns team wants to build separate sends for each segment, starting next week.
What they need from you: three separate sheets in the current Google Sheets file, one per tier, with clean subscriber data ready for campaign planning.
The slow version:
- Export the full list from Mailcoach as a CSV
- Open it in Sheets
- Filter by tier tag, copy rows, paste into a new sheet
- Repeat for each of three tiers
- Realize the export put all tags in a single comma-separated string in one column
- Spend twenty minutes splitting the tags column and re-filtering
- You hand off a sheet you are not fully confident in.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that can call the Mailcoach API, write the results into the sheet, and then restructure the data, all in sequence.
Open the SheetXAI sidebar and type:
Fetch all subscribers from Mailcoach list UUID [X] and write email, first name, last name, subscription status, and tags into this sheet. Then create three new sheets called 'Free', 'Pro', and 'Enterprise' and move each subscriber to the matching sheet based on their tag — put untagged subscribers in a fourth sheet called 'Untagged'.
SheetXAI calls the Mailcoach subscribers API, handles pagination across all 2,000 rows, writes the full list into the current sheet, then creates the four destination sheets and routes each subscriber based on their tag value.
What You Get
Four named sheets, each clean and ready for campaign planning:
- Free — every subscriber tagged "free," with email, first name, last name, and status
- Pro — every subscriber tagged "pro"
- Enterprise — every subscriber tagged "enterprise"
- Untagged — everyone the tag logic could not route, flagged for your attention
No subscriber is silently dropped. The Untagged sheet catches anything the filter could not resolve, which is exactly what you want before handing work off to the campaigns team.
If a subscriber has multiple tags and fits more than one bucket, you can specify the priority order in your prompt.
What If the Data Is Not Quite Ready
Subscriber exports from Mailcoach are usually clean, but the tag layer can be messier than you expect. SheetXAI handles the normalization inline.
When tag capitalization is inconsistent
Some subscribers were tagged "Pro," some "pro," some "PRO" from different import batches.
Fetch all subscribers from Mailcoach list [UUID], normalize all tag values to lowercase, then split them into Free, Pro, Enterprise, and Untagged sheets.
When you want to filter to active subscribers only
The list includes people who unsubscribed. You want the segment sheets to reflect only active contacts.
Fetch all subscribers from Mailcoach list [UUID] where subscription status is "subscribed." Then split them into Free, Pro, and Enterprise sheets based on their tag, and put untagged actives in an Untagged sheet.
When a subscriber has multiple tags
Some contacts are tagged both "pro" and "beta." You need a rule for which sheet they land in.
Fetch all subscribers from Mailcoach list [UUID]. If a subscriber has both a tier tag and another tag, use the tier tag for routing. Create Free, Pro, Enterprise, and Untagged sheets. If a subscriber has no tier tag but has other tags, put them in Untagged.
When you want a summary count before the full split
You want to know the segment sizes before committing to creating the sheets.
Fetch all subscribers from Mailcoach list [UUID], count how many are tagged Free, Pro, Enterprise, and untagged, and write a summary table on the current sheet with segment name and count. Then, if I confirm, create the four destination sheets and route each subscriber.
The pattern: instead of exporting first and restructuring manually, you describe the output you want and SheetXAI handles the routing.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet, then ask it to export and segment your Mailcoach subscribers. The Mailcoach integration is included in every SheetXAI plan. For related workflows, see how to apply tags to Mailcoach subscribers in bulk or the Mailcoach in Google Sheets overview.