Validate email addresses in a list
“check our mailchimp audience export and show every contact, status Agrees if the email is valid and unique, Duplicate email if it repeats, Invalid email if it lacks a valid tld, Role-based if it’s support or billing”
Check our Mailchimp audience export and show every contact, status Agrees if the email is valid and unique, Duplicate email if it repeats, Invalid email if it lacks a valid tld, Role-based if it’s support or billing, with precedence in this order: Role-based, invalid, duplicate, agrees.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
- FileMailchimp audience exportCSV export · 14 rows
- StepSet contact email statusStep 1
- ResultEmail Status Check14 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 14 rows came out.
- Download Mailchimp audience export sample (14 rows)Mailchimp: Audience > All contacts > Export audience
What you get back
The result of that run, the rows to look at first.
| Email Address | Contact status | First Name | Last Name | Date Added |
|---|---|---|---|---|
| jules@northwind | Invalid email | Jules | Parker | 2026-10-02 |
| noah.khan@northwindco.com | Agrees | Noah | Khan | 2026-10-09 |
| leo.singh@brightforge.io | Agrees | Leo | Singh | 2026-11-04 |
| maya.chen@lumenberry.com | Duplicate email | Maya | Chen | 2026-09-29 |
| maya.chen@lumenberry.com | Duplicate email | Maya | Chen | 2026-10-21 |
| zoe.patel@brightforge.io | Agrees | Zoe | Patel | 2026-11-01 |
| omar.frost@harborlane.co | Agrees | Omar | Frost | 2026-11-10 |
| tessa.owens@lumenberry.com | Agrees | Tessa | Owens | 2026-10-14 |
| nina.park@harborlane.co | Agrees | Nina | Park | 2026-11-07 |
| ben.ito@northwindco.com | Agrees | Ben | Ito | 2026-09-22 |
| ava.morales@northwindco.com | Agrees | Ava | Morales | 2026-09-18 |
| billing@lumenberry.com | Role-based | Billing | Desk | 2026-10-17 |
How do you validate email addresses in a list?
Upload your Mailchimp audience export and run the email status step. It checks each contact email and marks it as Agrees, Duplicate email, Invalid email, or Role-based. You can then remove the contacts that are not valid for your list.
How it works
How to use the Email Status Check workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Email Status Check: questions
What file should I export from Mailchimp?
What happens to rows that do not match the rules?
How do I change the rules?
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Remove duplicate rows, catch invoices paid twice, match messy names to a master list, standardise spellings and turn wide tables long.
- Pivot table from raw dataTurn a raw sales export into a pivot table of revenue by region and month.See the workflow Built by the agent
- Remove duplicatesOne row of each, with a Copies column saying how many there wereSee the workflow Template
- Match names to a master listEach record with its master name (and ID), and how it matchedSee the workflow Template
- Compare two listsCompare two exported spreadsheet lists by email, see matches, and label rows where name and email agree or differ.See the workflow Built by the agent
- Duplicate invoice checkPairs of bills that look paid twice: same supplier, same amount, close dates or the same numberSee the workflow Template
- Standardise namesA Standard name for every row, so spellings of the same name group togetherSee the workflow Template