The Scenario
You are a compliance manager at a financial services firm. On Wednesday afternoon you receive a suppression file from a third-party data broker: 300 email addresses that have formally requested removal from all marketing communications under GDPR Article 17.
Your firm's policy requires all opt-outs to be applied in every sending platform within 24 hours. That means eSputnik needs to be updated before the Thursday morning send.
The slow version of this task:
- You open the suppression file in Excel
- You open eSputnik and look for a bulk unsubscribe option
- The UI handles individual unsubscribes only
- You find the API documentation for the unsubscribe endpoint, but your firm's IT policy requires API credentials to go through a request process that takes 48 hours
- You contact the digital marketing team to do the unsubscribes manually, but they are running the Thursday campaign and have no capacity
- The Thursday send goes out with 300 contacts who have legally opted out.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the suppression file and calls eSputnik's unsubscribe API for every address in the workbook.
Open the SheetXAI sidebar and type:
For each email in column A of my Excel 'Suppression File' sheet, unsubscribe the contact from eSputnik and write 'done' into column B.
SheetXAI processes every row, calls the unsubscribe endpoint for each address, and writes "done" or the error into column B. The Thursday send will exclude all 300.
What You Get
300 contacts marked as unsubscribed in eSputnik, with per-row confirmation in the workbook:
- All addresses processed — in a single session, not one by one through the UI
- Column B shows the result per row — "done" for each success, the specific error for any failure
- Compliance evidence in the workbook — a timestamped record that each address was actioned before the next send
- No API credentials required from IT — SheetXAI handles the authentication to eSputnik through its existing integration
The per-row "done" confirmation is your compliance record. If the DPA audits your data processing and asks for evidence that a specific email was removed before Thursday's send, you have a timestamped Excel cell with "done" next to that address. That is the documentation the compliance report needs.
What If the Data Is Not Quite Ready
Suppression files from data brokers are reliably messy. SheetXAI handles the cleanup and the unsubscribe in the same prompt.
When email addresses have inconsistent formatting
Some are uppercase, some have trailing spaces, some have extra dots or characters from manual entry. eSputnik will not match "User @Example.com " to the existing contact record.
Normalize all email addresses in column A of the 'Suppression File' tab to lowercase and trim whitespace. Then unsubscribe the normalized addresses from eSputnik. Write "done" or the error into column B for each row.
When some addresses are not in eSputnik at all
Part of the suppression list came from a legacy platform your organisation no longer uses, so some emails were never in eSputnik.
Unsubscribe all emails in column A of the 'Suppression File' tab from eSputnik. Write "unsubscribed," "not found in eSputnik," or the error message into column B. After all rows are processed, write the total "not found" count into cell C1 for the compliance report.
When the suppression file needs to be applied across two sending platforms
Your firm also sends transactional SMS through a second platform. The opt-out applies to all channels.
Unsubscribe all emails in column A of the 'Suppression File' tab from eSputnik. Write the eSputnik result into column B. Then, for rows that have a phone number in column C, mark those as opted out in the SMS platform as well. Write the SMS result into column D.
When you want to clean the file, apply the suppressions, and generate the compliance memo in one pass
Your DPO requires a written summary of the action for the compliance file within two hours of application.
Normalize all emails in column A of the 'Suppression File' tab to lowercase and trim whitespace. Unsubscribe each one from eSputnik. Write "done" or the error into column B. After all rows are processed, write into cell A1 of the 'Compliance Memo' tab a 4-sentence paragraph summarizing: the date and time of the action, the total number of addresses submitted, the number successfully unsubscribed, and the number not found in eSputnik.
The pattern: normalization, suppression application, and compliance documentation all in one prompt. The Thursday send is clean and the DPO has their memo.
Try It
Get the 7-day free trial of SheetXAI and open any Excel suppression file or opt-out list, then ask it to apply the unsubscribes in eSputnik. The eSputnik integration is included in every SheetXAI plan. See also how to bulk-add contacts to a segment in Excel or the eSputnik in Excel overview.