The Scenario
Next month's email campaign is your biggest of the year. Before the send goes out, the head of marketing ops sends a note: "We need our Delighted unsubscribe and bounce list loaded into the suppression list in the email platform before this goes out." The suppression list lives in a Google Sheet that feeds the platform. The Delighted data does not.
You've never pulled this list before. You know it exists somewhere in Delighted's settings, but you're not sure what the export looks like, how bounces differ from unsubscribes in the data structure, or how to get both in the same table in a format the email platform accepts.
The bad version:
- Navigate Delighted's settings looking for an unsubscribe export — find it eventually under a non-obvious menu
- Download the CSV, open it in Sheets, find the columns are labeled differently than what the email platform expects
- Separately find the bounce export — it's in a different section, different format, different column headers
- Try to merge the two tables using VLOOKUP, realize the email columns have trailing whitespace in one file, spend twenty minutes on cleanup before you even have a usable list
The campaign send date does not move. The suppression list has to be ready.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet, understands the structure, and through its built-in Delighted integration it can pull every unsubscribed contact — with timestamps — directly into the sheet in one call.
Fetch all unsubscribed people from Delighted and write their emails and unsubscribe timestamps into the SuppressionList sheet
What You Get
- Column A: unsubscribed email address
- Column B: unsubscribe timestamp
- All records pulled in a single pass — no separate CSV export, no manual merge
- Data formatted consistently, ready to pipe into your email platform's suppression import
What If the Data Is Not Quite Ready
You want bounces included alongside unsubscribes
Export all unsubscribed and bounced contacts from Delighted and populate the SuppressionList sheet with columns for Email, Status (bounced or unsubscribed), and Date
You want to deduplicate before writing — some emails may appear in both lists
Fetch all unsubscribed and bounced contacts from Delighted, deduplicate by email address keeping the most recent date, and write the merged list into the SuppressionList sheet with Email, Status, and Date columns
You want to cross-reference against contacts already in the sheet
Fetch all Delighted unsubscribes and bounces, check each email against column A of the ExistingSuppressions sheet, only write emails that are NOT already in that column into the NewSuppressions sheet with Email, Status, and Date
Full suppression refresh — pull, dedup, cross-reference, timestamp in one pass
Fetch all unsubscribed and bounced contacts from Delighted, deduplicate by email keeping the earliest date per address, remove any already present in column A of the ExistingSuppressions sheet, write the remaining new suppressions into the NewSuppressions sheet with Email, Status, and Date columns, then write today's date into cell F1 of the NewSuppressions sheet as the refresh timestamp
Every suppression update you'd normally spend an hour building — one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet that feeds your email platform's suppression list, then ask it to pull the latest Delighted unsubscribes and bounces into one clean table. Or see how to run a full contact health audit before the next NPS wave. Full overview at Delighted + Google Sheets.