The Scenario
You are a marketing ops analyst. Your company just completed a Mixmax audit and the unsubscribe list has over 300 addresses that have accumulated over 18 months of outbound.
Your job: export every one of those addresses into a Google Sheet so you can cross-reference them against Salesforce and mark the corresponding contacts as unsubscribed there too. The reconciliation report is due to the VP of Marketing by end of week.
The bad version of this week:
- You open Mixmax and look for an export option on the unsubscribe list page
- The UI shows the addresses but you cannot find a download button
- You start copying them manually into a sheet
- By address 40 you calculate you will finish the manual export sometime next Tuesday
- You try the API, pull the data, and it comes back as a JSON blob that needs reshaping
- You deliver an incomplete reconciliation report at the end of the week and your VP asks why it is only 80% complete.
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 copy a single address from the UI or reshape a JSON response.
Open the SheetXAI sidebar and type:
Pull the full Mixmax unsubscribe list and write every email address into this sheet in column A. Add a timestamp in column B showing when the address was added to the list, if available.
SheetXAI calls the Mixmax unsubscribe API, writes every address into column A, adds the timestamp if the API returns it, and you have your full export in under a minute.
What You Get
A complete unsubscribe export, ready for CRM reconciliation:
- Column A — every email address on the Mixmax unsubscribe list
- Column B — the date each address was added, if Mixmax returns it
- One row per address — no pagination to manage, no JSON to parse
300 addresses in a flat sheet is what you need to run a VLOOKUP or MATCH against your Salesforce export. You paste the Salesforce export into the next tab, write the formula, and the reconciliation is done in a few minutes. The Mixmax export is not the bottleneck.
Want to add a "Found in Salesforce" column that flags addresses already marked as unsubscribed there? Tell SheetXAI to cross-reference the list against a Salesforce export in another tab. It adjusts.
What If the Data Is Not Quite Ready
Unsubscribe list exports from any platform have their quirks. SheetXAI handles them in the same prompt.
When you want to see only recent additions
You only need addresses added in the last 90 days for a focused reconciliation.
Pull the Mixmax unsubscribe list filtered to addresses added in the last 90 days. Write each email and the date added into this sheet.
When the Salesforce export is already in a tab and you want the comparison done automatically
You have a Salesforce contact export in the SF tab with email addresses in column A. You want SheetXAI to flag which Mixmax unsubscribes are not yet marked as unsubscribed in Salesforce.
Pull the full Mixmax unsubscribe list into column A of the Unsubscribed tab. Then compare that list against column A of the SF tab. For each email that appears in the Mixmax list but is not marked as unsubscribed in Salesforce, write it into the Action Needed tab with the date added.
When you need the list deduplicated
The Mixmax unsubscribe list may have duplicate entries from multiple form submissions or API calls.
Pull the full Mixmax unsubscribe list, deduplicate by email address, and write each unique address into column A of this sheet. Add a count at the bottom of how many duplicates were removed.
When you need the export, the Salesforce comparison, and a summary in one shot
You need the full unsubscribe list, a flag for which addresses are missing in Salesforce, and a count of the gap, all in one sheet before the end-of-week report.
Pull the full Mixmax unsubscribe list into the Unsubscribed tab. Compare against the SF tab (column A = email, column B = unsubscribed status in Salesforce). In the Gap tab, write every email that is on the Mixmax list but not marked as unsubscribed in Salesforce. At the top of the Gap tab, write a count of the total gap.
The pattern: describe the full reconciliation you need and SheetXAI assembles it from the Mixmax API and your existing sheet data in one pass.
Try It
Get the 7-day free trial of SheetXAI and open any reconciliation sheet, then ask it to pull the Mixmax unsubscribe list. The Mixmax integration is included in every SheetXAI plan. For adding new opt-outs to the list, see how to bulk-add opt-outs to the Mixmax unsubscribe list or the Mixmax in Google Sheets overview.