The Scenario
You are a compliance manager. On Tuesday afternoon you received an opt-out file from a third-party data provider: 300 email addresses that have formally requested removal from all marketing communications.
Under your organisation's GDPR policy, they must all be marked as unsubscribed in eSputnik before the next send, which is scheduled for Thursday morning.
The slow version of this task:
- You open the eSputnik UI and look for a bulk unsubscribe option
- The interface lets you manage unsubscribes manually, one contact at a time
- You find a reference to an API endpoint for batch unsubscribes but it requires bearer token authentication and a specific JSON body format
- You ask the developer on the team to help. They are on leave until Thursday
- You consider doing 300 manual unsubscribes
- The Thursday send goes out with 300 contacts who 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 sheet.
Open the SheetXAI sidebar and type:
Add all email addresses in column A of my 'Opt-Out List' sheet to the eSputnik unsubscribed contacts list.
SheetXAI processes every row and marks each address as unsubscribed in eSputnik. The Thursday send will exclude them automatically.
What You Get
300 contacts marked as unsubscribed in eSputnik, with confirmation in the sheet:
- All addresses processed — not one by one through the UI, but in a single API call batch
- Status written back per row — "unsubscribed" or the specific error per address
- Audit trail in the sheet — your compliance record showing which addresses were processed and when
- No developer required — no API auth, no JSON construction, no code
The per-row status column is your compliance evidence. If the DPA asks for proof that a specific email address was removed before the Thursday send, you have a timestamped sheet with "unsubscribed" next to that address. That is the record you need.
What If the Data Is Not Quite Ready
Suppression files from third-party providers are often messy. SheetXAI handles cleanup and the unsubscribe in the same prompt.
When the file has emails in inconsistent formats
Some addresses are uppercase, some have trailing spaces, some have typos from a manual entry process. eSputnik will not match "User @Example.com " to the existing contact.
Normalize all email addresses in column A to lowercase and trim whitespace. Then unsubscribe the normalized addresses from eSputnik. Write the result into column B for each row.
When the file includes addresses that are not in eSputnik at all
Some of the 300 opt-out addresses were never in your system. You want to log those separately.
Unsubscribe all email addresses in column A from eSputnik. Write "unsubscribed," "not found in eSputnik," or the error message into column B for each row. After all rows are processed, write the count of "not found" addresses into cell C1 for the compliance report.
When the suppression file also needs to be applied to a second tool
Your sending stack uses eSputnik for email but a separate SMS platform for text messages. Same opt-out list, two systems.
Unsubscribe all emails in column A from eSputnik. Then mark the same addresses as opted out in Twilio Messaging if they have a phone number in column B. Write the eSputnik result into column C and the Twilio result into column D.
When you want to clean the file, apply the suppression, and generate a compliance memo in one pass
Your DPA requires a written summary of the suppression action for the compliance file.
Normalize all emails in column A to lowercase and trim whitespace. Unsubscribe each one from eSputnik. Write "unsubscribed" 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 of the action, the total number of addresses submitted, the number successfully unsubscribed, and the number that were not found in eSputnik.
The pattern: instead of handling the data clean-up, the API work, and the compliance documentation as three separate tasks across two days, you ask for all of it in one prompt and have the evidence ready before the Thursday send.
Try It
Get the 7-day free trial of SheetXAI and open any suppression file or opt-out list in Google Sheets, 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 or the eSputnik in Google Sheets overview.