The Scenario
The re-engagement campaign worked. 120 contacts confirmed their opt-in through the double-opt-in form. Your email ops team has them in a Google Sheet, column A, confirmed and verified.
The problem: a lot of these addresses were suppressed in SMTP2GO from the previous campaign, which had a rough patch before you cleaned the list. If they stay on the suppression list, the re-engagement emails you just earned will never arrive.
Somebody has to remove 120 addresses from the suppression list. The question is whether that means 120 clicks in the SMTP2GO dashboard or one prompt in the sheet you already have open.
The bad version:
- Log into SMTP2GO and navigate to Suppressions.
- Search for each re-opted-in address individually.
- Click remove, confirm the removal.
- Repeat 119 more times, losing your place twice because the search resets between removals.
Your re-engagement rate was 12 percent. Do not lose those contacts to a suppression list that never got updated.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads column A, connects to SMTP2GO, and handles the unsuppression calls with a writeback telling you what happened to each address.
Remove every email in column A of this sheet from the SMTP2GO suppression list and write "unsuppressed" in column B for each one.
What You Get
- Every address in column A is submitted to the SMTP2GO suppression removal endpoint
- Column B gets "unsuppressed" for each address removed successfully
- Column B gets "not on suppression list" for any address that was not suppressed in the first place
You end up with a complete record of what was processed and what, if anything, was already clear.
What If the Data Is Not Quite Ready
You also want to flag which addresses were not on the suppression list at all
Remove every email in column A from the SMTP2GO suppression list. Write "unsuppressed" in column B for each success. Write "not found on suppression list" in column C for any address that was not suppressed.
Column A has addresses in mixed case that might not match the suppression list entries
Remove every email in column A from the SMTP2GO suppression list after normalizing to lowercase. Write "unsuppressed" in column B for successes and "not found" for any address that did not match.
You need to verify that each address is also on your active contacts list before unsuppressing
For each email in column A, first check if it exists in the contacts list in column D. If it does, remove it from the SMTP2GO suppression list and write "unsuppressed" in column B. If it is not in column D, skip it and write "not in active list" in column B.
Full kill chain: verify, unsuppress, and report gaps in one prompt
Take all addresses in column A. Normalize to lowercase and trim whitespace. Cross-reference against the confirmed opt-in list in column D — only process addresses that appear in both. Remove matching addresses from the SMTP2GO suppression list. Write "unsuppressed" in column B for successes, "not found on suppression list" in column B if not suppressed, and "not in opt-in list" for any address skipped in the cross-reference step. At the bottom of column B, write a summary: total processed, total unsuppressed, total skipped.
Combining the verification and the unsuppression means no address slips through that should not have been cleared.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet holding your confirmed re-opt-ins, then ask it to remove them from your SMTP2GO suppression list in one pass. For building out the other side of the same campaign — getting the suppression list into a sheet before the scrub — see the spoke on exporting the SMTP2GO suppression list for list hygiene.