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 an Excel workbook. The domains are in the first column.
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 Excel workbook. It reads the domain list, calls PersistIQ's DNC API for each entry, and writes the result back to the workbook so you have a confirmation record.
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
What You Get
- A result column filled with SUCCESS or the specific error for each domain
- Domains that were already on the DNC list get ALREADY EXISTS
- Sheet2 populated with the full current DNC domain list as confirmation
- A timestamped record 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 the domain column of the 'Blocked Partners' worksheet 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 in the adjacent column
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.
Add each domain from the 'DNC Domains' worksheet to PersistIQ as a DNC domain entry, then pull the complete PersistIQ DNC domain list and write it to a new worksheet called 'Full DNC List'
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' worksheet — for rows where the type column is 'domain', add the value as a PersistIQ DNC domain; for rows where the type column is 'email', add the value as a PersistIQ DNC email address — write the result in the result column
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 the 'DNC Reference' worksheet, then for each lead in the 'Active Leads' worksheet (email in the email column), check if their domain matches any DNC entry and write BLOCKED or CLEAR in the status column
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 an Excel workbook 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.