The Scenario
You are a compliance manager. Your web form collected 120 opt-out email addresses over the past two weeks. They are sitting in a Google Sheet, one email per row in column A.
Your next campaign send is in 48 hours. Every one of those 120 addresses needs to be on the Mixmax unsubscribe list before the campaign goes out.
The bad version of the next two hours:
- You open Mixmax and look for the unsubscribe list management page
- You find an option to add individual emails
- You start adding them one at a time
- By address 30 you are questioning every career decision you have ever made
- You get interrupted and lose track of which row you were on
- You send the campaign with 60 of the 120 addresses still missing from the unsubscribe list.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads the data and calls Mixmax directly, so you do not have to add a single address by hand.
Open the SheetXAI sidebar and type:
Add every email in column A of this sheet to the Mixmax unsubscribe list. Write "Unsubscribed" or the error into column B for each row.
SheetXAI reads column A, calls Mixmax's unsubscribe API for each email, and writes the result into column B. All 120 addresses, one prompt, 48 hours before the send.
What You Get
120 emails added to the Mixmax unsubscribe list, with a status column showing what happened per row:
- "Unsubscribed" — the email was successfully added to the list
- Error message — for any row that failed, so you can investigate before the send
The status column is your compliance audit trail. You can share the sheet with legal or send it to whoever runs the campaign as confirmation that every opt-out was processed. You have a record of when each address was added.
Want to also remove those contacts from any active sequences in the same prompt? Tell SheetXAI to cancel their sequence enrollments while adding them to the unsubscribe list. It adjusts.
What If the Data Is Not Quite Ready
Opt-out lists collected through web forms are rarely clean. SheetXAI handles the edge cases in the same prompt.
When some emails in column A are duplicates
The form was submitted twice by some respondents, giving you duplicate entries in the sheet.
Deduplicate column A by email address before processing. Then add each unique email to the Mixmax unsubscribe list and write the result into column B.
When emails have leading or trailing spaces
The web form did not trim whitespace and some addresses have a space before or after them.
Trim whitespace from every email in column A before adding them to the Mixmax unsubscribe list. Write the cleaned email and the result into columns B and C.
When some rows have names in addition to emails
Your form captured first name and email, but the Mixmax unsubscribe endpoint only needs the email.
For each row in this sheet, extract the email from column B and add it to the Mixmax unsubscribe list. Ignore column A (first name). Write the result into column C.
When you need to unsubscribe, cancel sequences, and report in one shot
The 120 opt-outs may also be enrolled in active sequences. You need to handle both actions and produce a compliance report before the send.
For each email in column A: add it to the Mixmax unsubscribe list, cancel any active sequence enrollments for that contact, and write the result into column B. At the bottom of column B, add a count of how many emails were successfully unsubscribed and how many sequence enrollments were cancelled.
The pattern: describe the full compliance operation in one prompt and SheetXAI handles the row-level work.
Try It
Get the 7-day free trial of SheetXAI and open your opt-out sheet, then ask SheetXAI to push the addresses into the Mixmax unsubscribe list. The Mixmax integration is included in every SheetXAI plan. For exporting the unsubscribe list, see how to export the Mixmax unsubscribe list for CRM reconciliation or the Mixmax in Google Sheets overview.