The Scenario
A new privacy regulation takes effect next month. It restricts sending to contacts whose email domain belongs to a specific set of corporate and government domains in a particular jurisdiction. Legal handed you a list of 23 domains. You need to pull every Mailercloud contact that matches any of them and build a suppression list before the next campaign run.
Your Mailercloud account has contacts spread across four lists. The contacts don't have a "domain" field — you'd have to search by the domain string and pull results yourself.
The bad version:
- Open Mailercloud's contact search, type in the first domain, export the results as a CSV, open it in Excel, copy the rows into your suppression workbook
- Repeat 22 more times — once per domain — keeping track of which ones you've already done
- Notice that some contacts appear in multiple search results because they're on multiple lists, spend time de-duplicating by hand
Legal needs this before Thursday. Twenty-three separate search-and-export cycles is a Thursday on its own.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your list of domains, runs each search against Mailercloud, and writes every result into the workbook — leaving you with a complete, de-duplicated suppression list ready for review.
For each search term in column A, search Mailercloud list [ID in B1] for matching contacts and paste results into a new sheet named after the search term — include email, name, and any available custom fields
What You Get
- SheetXAI works through each domain in column A and pulls the matching contacts from your Mailercloud list
- A new worksheet is created for each search term, named after the domain, with email, name, and custom fields populated
- If you get duplicates across searches — a contact that matches two different domain terms — those rows appear in each relevant sheet and are easy to consolidate with a follow-up prompt
- The whole operation runs unattended; you don't have to manage 23 browser tabs
What If the Data Is Not Quite Ready
You need to search across multiple Mailercloud lists, not just one
For each search term in column A, search Mailercloud lists with IDs in cells B1, B2, and B3 for matching contacts — combine all results into this worksheet with email, first name, last name, and list ID — one row per contact
You want all results on a single sheet rather than separate sheets per domain
Search my Mailercloud list [ID in B1] for all contacts matching each domain in column A — write every result's email, first name, and last name into this worksheet starting at row 3, one row per contact
You also need any available custom fields for each matched contact
Search my Mailercloud list [ID in B1] for all contacts matching each domain in column A — write email, first name, last name, and any custom fields into this worksheet starting at row 3
Kill chain: search all domains, combine results, flag duplicates, write summary count
For each domain in column A, search Mailercloud list [ID in B1] for matching contacts and write results into columns B, C, and D starting at row 3 — then flag any rows where the email appears more than once by writing DUPLICATE into column E, and write the total unique contact count into cell F1
One prompt builds the suppression list, marks the duplicates, and gives you the count.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook with your domain list in column A, paste your Mailercloud list ID into cell B1, and ask SheetXAI to pull every matched contact into the workbook. For related tasks, see how to export your full contact list or create multiple lists at once from the same workbook.