The Scenario
Your newsletter has been running for two years. Last month someone handed you a stack of paper forms from a trade show — attendees who had signed up for a newsletter that your company had since folded, and their data got merged into your Goodbits list without consent. Thirty-five of them want off.
A colleague entered all 35 emails into an Excel workbook over the weekend. They're in column A. Column B is blank — that's where the result should go.
The bad version:
- Open Goodbits, go to Subscribers, search for the first email, find it in the list, open the record, change the status to unsubscribed, save, go back to the workbook, move to row 2
- Realize after ten rows that Goodbits's search doesn't always surface exact matches on the first try
- Make a mistake on row 19, set the wrong record to unsubscribed, and spend twenty minutes sorting out which ones you've actually processed
Thirty-five records is enough that doing this by hand is a real commitment. It's also the kind of task where one mistake has a compliance cost — unsubscribing the wrong person, or missing one, matters.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the email list, processes each row against Goodbits, and writes back the result — so you end up with a clear record of what happened to each one.
For each email in column A of the "Unsubscribe Requests" sheet, update the Goodbits subscriber status to "unsubscribed" and write the result into column B — use "done" if it worked, "not found" if the email doesn't exist in Goodbits, and "error" for anything else
What You Get
- Each email in column A processed against Goodbits
- Column B updated with "done," "not found," or "error" for every row — no guessing which ones went through
- A clean audit trail you can keep for compliance purposes — the workbook is the record
- The ones marked "not found" flagged for follow-up without you having to search for them manually
What If the Data Is Not Quite Ready
Some emails in the workbook have inconsistent formatting
For each email in column A of "Unsubscribe Requests," lowercase and trim the email before looking it up in Goodbits — update the status to "unsubscribed" for matches and write the result into column B
You only want to process rows that haven't been handled yet
For each row in "Unsubscribe Requests" where column B is blank, update the Goodbits subscriber status to "unsubscribed" using the email in column A and write "done," "not found," or "error" into column B — leave rows where column B already has a value untouched
You want to pull in a reason code from a third column before updating
For each email in column A of "Unsubscribe Requests," update the Goodbits subscriber status to "unsubscribed" — include the reason from column C as a note if the field is available in Goodbits — write the result into column B
Deduplicate the requests, validate the format, then process the whole list at once
In "Unsubscribe Requests," find any email in column A that appears more than once and keep only the first row — for the remaining rows, lowercase and trim each email, update the Goodbits subscriber status to "unsubscribed," and write "done," "not found," or "error" into column B for each
One instruction handles the cleanup and the action without splitting the work into multiple steps.
Try It
Get the 7-day free trial of SheetXAI and open any workbook of unsubscribe requests, then ask it to process the whole list against Goodbits in a single pass. Also see how SheetXAI handles importing subscribers from a workbook or read the Goodbits integration hub for a full overview.