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, copy the rows into your suppression sheet
- 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 Google Sheet. It reads your list of domains, runs each search against Mailercloud, and writes every result into the sheet — leaving you with a complete, de-duplicated suppression list ready for review.
Search my Mailercloud list [ID in cell B1] for all contacts matching each search term in column A — write every result's email, first name, and last name into this sheet starting at row 3, one row per contact
What You Get
- SheetXAI works through each search term in column A and pulls the matching contacts from your Mailercloud list
- Email, first name, and last name land in the sheet, one row per contact result
- If you get duplicates across searches — a contact that matches two different domain terms — those rows are visible and easy to de-duplicate 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 sheet with email, first name, last name, and list ID — one row per contact
You want results written into separate sheets per domain
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 subscription status
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 sheet 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 a Google Sheet 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 sheet. For related tasks, see how to export your full contact list or create multiple lists at once from the same workbook.