The Scenario
Your ops team just handed you a Google Sheet 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 Google Sheet. 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.
For each email in column A of my sheet, look up the prospect data in my Sendspark workspace and write their name, campaign membership, and status in columns B through D
What You Get
- Every email in column A gets checked against your Sendspark workspace.
- Column B receives the prospect's name if found in Sendspark, blank if not.
- Column C receives the campaign name they belong to, or "not found."
- Column D receives their current status in that campaign — so you know not just whether they're in Sendspark but where they are in the sequence.
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 tabs — "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' tabs against my Sendspark workspace, write 'found' or 'not found' in column B of each tab, and add the campaign name in column C — flag any email that appears in both tabs 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 list, 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.