The Scenario
Your company's partner team just signed five new co-sell agreements, and legal sent over an updated list of 40 domains that should never appear in your outbound sequences — competitors, partners, and a few enterprise accounts in active negotiation. The list is in a Google Sheet. Column A has the domains.
Your sales ops manager needs these in PersistIQ's DNC list before tomorrow morning, when the next campaign wave goes out.
The bad version:
- Open PersistIQ's DNC settings, find the domain-level blocklist section
- Type the first domain into the input field, add it, confirm
- Repeat 40 times
- Realize there's no bulk-import option, and you're 12 domains in with 28 to go
Nobody hired you to be a data-entry clerk for an hour on a Wednesday afternoon.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the domain list, calls PersistIQ's DNC API for each entry, and writes the result back to the sheet so you have a confirmation record.
Take every domain in column A of the 'DNC Domains' sheet and create a PersistIQ Do Not Contact domain entry for each one, writing SUCCESS or error into column B
What You Get
- Column B filled with SUCCESS or the specific error for each domain
- Domains that were already on the DNC list get ALREADY EXISTS in column B
- You end up with a timestamped confirmation you can send to legal or compliance
What If the Data Is Not Quite Ready
The domain column has some messy entries — full URLs mixed with bare domains
Some rows have "https://competitor.com/pricing" instead of just "competitor.com."
Clean column A of the 'DNC Domains' sheet by extracting just the domain from any URLs (strip protocol and path), then create a PersistIQ DNC domain entry for each cleaned domain and write the result into column B
You want to verify the full DNC domain list after adding the new entries
Legal wants a complete list of all blocked domains, not just the 40 you added today.
Read column B of the Excel sheet 'Blocked Partners' (40 rows of domains) and add each as a PersistIQ DNC domain, then pull the full DNC domain list to Sheet2 to confirm
You need to add DNC entries across both domains and individual email addresses
The list has a mix — some full domains to block, plus five specific email addresses for key contacts at sensitive accounts.
Read the 'DNC List' sheet — for rows where column B is 'domain', add the value in column A as a PersistIQ DNC domain; for rows where column B is 'email', add the value as a PersistIQ DNC email address — write the result in column C
You want to cross-reference the DNC list against an existing lead database before the next send
Before the campaign fires, check whether any of your active campaign leads fall under one of the blocked domains.
Pull the full PersistIQ DNC domain list and write it to Sheet2, then for each lead in Sheet1 (email in column C), check if their domain matches any DNC entry and write BLOCKED or CLEAR in column D
Catching blocked leads before the send is the kind of check that prevents a painful compliance conversation the next morning.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet with your partner or competitor domain list, then ask it to push them all to PersistIQ's DNC blocklist in one pass. The export-campaign-inventory spoke shows how to audit which campaigns might be sending to leads in those domains right now.