How to use a Google Sheets spreadsheet as a dynamic email suppression list

When sending mail merge campaigns in Gmail with GMass, you can already suppress a list of addresses that belong to a prior campaign. Here is a detailed guide on using Suppression Lists in GMass. Additionally, if you’re using the GMass unsubscribe link, then GMass is already suppressing anyone on your Unsubscribe List.

You may, however, want to use a Google Sheets spreadsheet as the source of a suppression list, such that you can add new email addresses to just the spreadsheet, and have all of your future mail merge campaigns automatically suppress any email address that is on the spreadsheet.

To accomplish this, you have to set up a spreadsheet to hold the email addresses, and then create a container email campaign that will continuously update itself with the email addresses in the spreadsheet. You can do this with a combination of our mail merge and Google Sheets integration, the recurring campaigns feature, and the option to “Just create Drafts”.

Step-by-step guide:

  1. Create your suppression spreadsheet in Google Sheets. You really only need one column. In this example, the column is simply “email”.
  2. Use GMass to connect to the spreadsheet.
  3. After the Compose window appears, set the Subject to something like “Dynamic Suppression List”. In the GMass Settings in the Compose window, set the campaign to Repeat daily and set it to Just create Drafts. That will ensure that no emails are actually sent. Click the GMass button to start the creation of your dynamic suppression campaign.

Now, every day, the campaign that you just created, called “Dynamic Suppression List” will be updated with any new addresses from your Google Sheets spreadsheet. No emails will actually be sent, but Drafts will be created, which you can delete if you want to keep your Gmail account clean.

You can then use this campaign as the Suppression List for your future email campaigns, by selecting it in the Suppress option under Settings.

Important note about timing:

The suppression campaign will only be updated once every 24 hours, since that’s how often the campaign will run and pick up new addresses added to the spreadsheet. Therefore it is possible that if you send a campaign and use that campaign as a Suppression List, it may not suppress addresses that were added to the spreadsheet in the last 24 hours. In the future, GMass will be enhancing the recurring campaigns feature to be able to run hourly, in addition to daily, at which point any Suppression Lists connected dynamically to a spreadsheet in this fashion will update every hour.

7 Replies to “How to use a Google Sheets spreadsheet as a dynamic email suppression list”

  1. John

    Thanks for creating such a great tool!

    I created and set up a suppression list according to this guide and when I tried to associate this list with a new campaign, I am not seeing the option to utilize the new list. I’m only seeing subject lines of previously sent emails. Is this an error on my end and is this step necessary to prevent campaign emails from being sent to people on the suppression list?

  2. Marvin Quinsaat

    Hi John,

    When you create your new campaign, just select your suppression list you created under the suppression field and GMass will suppress emails from being sent to those in that list.

  3. Scoutz

    Is there a way to bulk export bounced emails to a google spreadsheet or set an auto job to populate to a google spreadsheet similar to this?

Leave a Reply

Your email address will not be published. Required fields are marked *