The Scenario
You are a compliance manager. GDPR unsubscribe requests came in over the past two weeks. 400 customers have opted out. Their phone numbers are in an Excel workbook on SharePoint. The next WhatsApp send to the "Newsletter" list is Friday at 9 AM.
If those 400 numbers are still in the list when Friday's send fires, you have a compliance problem.
The bad version:
- Open Spoki's contact list manager
- Find the "Newsletter" list
- Search for the first phone number
- Remove it
- Search for the second
- Remove it
- Do this 400 times
- Lose track around row 200
- Send to three people who opted out because you missed them.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the opted-out numbers from the workbook and removes every one from the Spoki list, writing the result back per row for your compliance record.
Open the SheetXAI sidebar and type:
Remove all contacts listed in column A (phone numbers in E.164 format) from Spoki list "Newsletter" and write the removal status for each into column B of this workbook.
SheetXAI loops through all 400 numbers, calls Spoki's remove endpoint for each, and writes "removed" or any error into column B. Done before Friday morning.
What You Get
A clean "Newsletter" list and a documented audit trail:
- Column B populated for every row — "removed" or a specific error
- All 400 numbers processed — no manual searching in the Spoki UI
- Per-row compliance record — if legal asks, the workbook is the answer
The compliance value is column B. If a question comes up about whether a specific number was removed before the Friday send, you check the workbook.
What If the Data Is Not Quite Ready
When phone numbers are in local format rather than E.164
Normalize all numbers in column A to E.164 format with Italian country code +39. Then remove each contact from Spoki list "Newsletter" and write the result into column B.
When the same number appears twice in the opt-out list
Deduplicate column A, keeping each phone number once. Then remove each unique number from Spoki list "Newsletter" and write the result into column B.
When you need to remove from two lists, not one
For each phone number in column A, remove that contact from both Spoki list "Newsletter" and Spoki list "PromoEstiva2026." Write the result for each list into columns B and C respectively.
When you also need to update a Spoki custom field to record the opt-out date
For each phone number in column A, remove the contact from Spoki list "Newsletter" and update the contact's custom field "gdpr_optout_date" to today's date. Write the result into column B.
The pattern: normalize, remove, record — all in one prompt.
Try It
Get the 7-day free trial of SheetXAI and ask it to process any opted-out contact column against a Spoki list. The Spoki integration is included in every plan. For related workflows, see how to add contacts to a Spoki list from a workbook or the Spoki in Excel overview.