The Scenario
The next campaign drops in 48 hours and you just got a message from the compliance team: any contact who unsubscribed from Enginemailer in the last 30 days needs to be suppressed in Salesforce before the send. You have no idea how many that is. You have no list. You have a deadline.
The bad version:
- Log into Enginemailer, navigate to the suppression or unsubscribe section, export the list — if an export option even exists for just the last 30 days.
- Open the exported file, notice the dates are in a non-standard format, reformat them in Excel so you can filter by date range, then pull only the rows within the 30-day window.
- Send the cleaned list to the Salesforce admin, wait for confirmation that the contacts are suppressed, and hope the campaign doesn't go out before that confirmation arrives.
The data is in Enginemailer. You need it in a spreadsheet in the next few minutes, not at the end of a multi-step export process that depends on two other people.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It connects to Enginemailer and pulls unsubscribe events directly into the sheet — date-filtered, deduplicated, ready to share.
Fetch all Enginemailer unsubscribe events since 30 days ago and write the subscriber email, unsubscribe date, and campaign or autoresponder name into columns A, B, and C of this sheet.
What You Get
- Every unsubscribe event from the past 30 days written into the sheet — one row per event, with email in column A, unsubscribe date in column B, and the source campaign or autoresponder name in column C.
- Dates in a standard format you can filter and sort immediately.
- The list is ready to share with the Salesforce admin or import into a suppression workflow the moment SheetXAI finishes writing.
- No manual date range filtering, no reformatting step.
What If the Data Is Not Quite Ready
You need to pull two months of unsubscribes and deduplicate by email
Some contacts unsubscribed multiple times — from different campaigns — and you only need one row per unique email.
Pull every unsubscribe event from Enginemailer for the past 60 days, deduplicate by email address keeping the earliest unsubscribe date, and paste the unique list into my 'Suppression List' sheet with columns for email and first unsubscribe date.
You want to cross-reference against your existing Salesforce suppression list in column E
Before sharing the new list, you want to flag anyone who is already suppressed in Salesforce so the admin only acts on the net-new rows.
Fetch all Enginemailer unsubscribes from the past 30 days into columns A, B, and C. Then check each email in column A against the existing suppression emails in column E and write 'already suppressed' or 'new suppression needed' into column D.
You want unsubscribes grouped by campaign so you can identify which send caused the most opt-outs
Pull all Enginemailer unsubscribe events from the past 30 days into my sheet. Then add a second tab called 'By Campaign' showing each campaign name, the number of unsubscribes it generated, and the unsubscribe rate if total sends are available.
Pull, deduplicate, cross-reference, and flag net-new suppressions in one operation
Fetch 30 days of Enginemailer unsubscribes into columns A, B, and C. Deduplicate by email. Cross-reference each email against column E. Write 'already suppressed' or 'new' to column D. Add a 'By Campaign' tab with unsubscribe counts per source campaign.
One prompt, one answer — so you're not stitching together four separate tasks before the campaign deadline.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet you're using for suppression management — then ask it to pull the last 30 days of unsubscribes, deduplicate them, and flag the net-new rows. For related tasks, see Export Transactional Email Report or the Enginemailer hub overview.