The Scenario
Your ops team just handed you an Excel workbook with 150 prospect emails collected from three different list sources over the last two weeks. Before you bulk-add them to the next Sendspark campaign, you need to know which ones are already members of an existing campaign. Importing duplicates means the same person gets targeted twice — and your SDRs start getting replies asking why they're receiving the same video from two different sequences.
The bad version:
- Open Sendspark, search each email address one at a time in the prospect lookup, and note down whether they're found and which campaign they belong to.
- Keep a running tally in a separate doc because there's no way to batch-check membership without doing it manually.
- After 20 minutes, realize you've only gotten through 30 of 150 and the remaining 120 are going to take the rest of the morning — time you were supposed to spend on the actual campaign setup.
The work here isn't hard. It's just pointless at this scale. 150 lookups by hand, when the answer is either "found" or "not found."
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the email list and checks it against your Sendspark workspace in one pass — returning membership status and campaign name for each row without you touching the Sendspark UI once.
Check each email in column A against my Sendspark workspace and write 'found' or 'not found' in column B of my Excel sheet, along with their campaign name in column C if found
What You Get
- Every email in column A gets checked against your Sendspark workspace.
- Column B receives "found" or "not found" for each row.
- Column C receives the campaign name for any prospect already in Sendspark, blank otherwise.
- You can filter column B for "not found" to get your clean import list in seconds.
What If the Data Is Not Quite Ready
The email column has mixed-case addresses and some trailing spaces
Normalize each email in column A — lowercase and trim whitespace — then check each one against my Sendspark workspace and write 'found' or 'not found' in column B, along with their campaign name in column C if found
You only want to flag the ones that are already active in a campaign, not just present in the workspace
For each email in column A, check my Sendspark workspace and write 'active', 'inactive', or 'not found' in column B based on their current campaign status — add the campaign name in column C for any active member
The email list is split across two worksheets — "Source A" and "Source B" — and you need a combined result
Check every email in column A of both the 'Source A' and 'Source B' worksheets against my Sendspark workspace, write 'found' or 'not found' in column B of each worksheet, and add the campaign name in column C — flag any email that appears in both worksheets as 'duplicate list source' in column D
You want to do the deduplication check and immediately queue the unfound prospects for import
For each email in column A, check my Sendspark workspace — mark 'already a member' in column B for any that are found, then bulk-add all not-found rows to Sendspark campaign 'dyn_abc123' using column A as email and column C as name, and write 'added' or the error in column D
The deduplication and the import happen in the same step — no intermediate export, no manual split of the list.
Try It
Get the 7-day free trial of SheetXAI and open your prospect workbook, then ask it to check every email against your Sendspark workspace before your next campaign import. See also: bulk-adding prospects to a campaign and the Sendspark integration overview.