The Scenario
You are a newsletter operator. You just made the call to leave Mailchimp. The export file came back with 5,000 subscribers: email, first name, last name, and the tags each person picked at signup. They need to land in your new Mailcoach list before your next send goes out in four days.
You have the file open in Google Sheets. Column A is email, B is first name, C is last name, D is tags.
The bad version of this migration:
- You format the file, save it as CSV, upload it through the Mailcoach dashboard
- Mailcoach's CSV import does not handle all your tag values cleanly
- You spend an hour remapping columns in the UI
- Some rows fail silently because an email has a trailing space
- You get a summary count but no row-level feedback, so you cannot tell which 47 subscribers did not make it
- You go into your first send with a list you cannot fully trust.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads your subscriber data and calls the Mailcoach import API directly, so you do not need to leave the sheet.
Open the SheetXAI sidebar and type:
Take the subscriber data in this sheet — email in column A, first name in column B, last name in column C, tags in column D — create a CSV import in Mailcoach targeting the list UUID in cell F1, then start it. Write QUEUED or ERROR into column E for each subscriber row.
SheetXAI reads the rows, trims whitespace, formats the payload, calls the Mailcoach import API with the correct list UUID, starts the import job, and writes per-row status back into column E. You can see exactly which rows succeeded and which ones need attention.
What You Get
A completed Mailcoach import with per-row accountability:
- Column E status — QUEUED for rows accepted by the API, ERROR with a reason for rows rejected
- Import started — the job is running in Mailcoach, no dashboard visit required
- Tag assignment — each subscriber's tags from column D are included in the import payload
- Zero silent failures — anything that did not queue shows up as an ERROR you can filter and fix
5,000 rows is not a constraint. SheetXAI batches the import automatically. You do not need to split the file, upload it in chunks, or babysit the progress.
If some rows came back ERROR, you can ask SheetXAI to pull just those rows into a new sheet and retry the import after fixing the issue.
What If the Data Is Not Quite Ready
Most migrated subscriber files are not export-clean. SheetXAI handles normalization and the import in the same prompt.
When tag values are inconsistent
Your old platform capitalized tags differently across rows — "newsletter", "Newsletter", "NEWSLETTER" all coexist in column D.
Normalize all tag values in column D to lowercase. Then run the Mailcoach CSV import for list UUID in cell F1 and write QUEUED or ERROR into column E.
When some rows have no email
A handful of rows have a name but an empty column A. You do not want those to go to the API.
Skip any row where column A is blank. For those rows, write SKIPPED into column E. For the rest, run the Mailcoach import and write QUEUED or ERROR.
When you only want active subscribers
The export includes unsubscribed contacts. You want to import only the people who were actively subscribed.
Filter to rows where column F is "subscribed." Import only those rows into Mailcoach list UUID in cell F1. For rows excluded by the filter, write EXCLUDED in column E.
When the file has duplicate emails and inconsistent names
The export has 5,000 rows but 400 of them are duplicates from a merge. Some first names have trailing punctuation.
Deduplicate by email in column A, keeping the first occurrence. Trim and clean the first name in column B. Then run the Mailcoach CSV import for list UUID in cell F1, write QUEUED or ERROR into column E for each row that was processed.
The pattern: instead of cleaning the file before the import, you clean and import in one prompt. SheetXAI handles the conditional logic inline.
Try It
Get the 7-day free trial of SheetXAI and open any subscriber sheet, then ask it to run the Mailcoach import. The Mailcoach integration is included in every SheetXAI plan. For the next step after importing, see how to apply tags to Mailcoach subscribers from a sheet or the Mailcoach in Google Sheets overview.