{"id":833,"date":"2017-02-21T19:49:37","date_gmt":"2017-02-21T19:49:37","guid":{"rendered":"http:\/\/www.gmass.co\/blog\/?p=833"},"modified":"2025-04-23T17:57:34","modified_gmt":"2025-04-23T17:57:34","slug":"use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list","status":"publish","type":"post","link":"https:\/\/www.gmass.co\/blog\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\/","title":{"rendered":"How to use a Google Sheets spreadsheet as a dynamic email suppression list"},"content":{"rendered":"
Note: The technique in this article is now deprecated. There’s a MUCH easier way to do this using GMass’s dynamic lists<\/a>.<\/div>\n

When sending mail merge campaigns in Gmail<\/a> 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.<\/a> Additionally, if you’re using the GMass unsubscribe link<\/a>, then GMass is already suppressing anyone on your Unsubscribe List.<\/p>\n

You may, however, want to use a Google Sheets spreadsheet as the source<\/strong> 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\u00a0on the spreadsheet.<\/p>\n

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<\/a>, the recurring campaigns feature<\/a>, and the option to “Just create Drafts”.<\/p>\n

Step-by-step guide:<\/strong><\/h3>\n
    \n
  1. Create your suppression spreadsheet<\/strong> in Google Sheets<\/strong>. You really only need one column. In this example, the column is simply “email”.
    \n    \"The<\/a><\/li>\n
  2. Use GMass to connect to the spreadsheet.
    \n    \"Connect<\/a><\/li>\n
  3. After the Compose<\/strong> window appears, set the Subject<\/strong> to something like “Dynamic Suppression List”. In the GMass Settings<\/strong> in the Compose<\/strong> window, set the campaign schedule to Repeat hourly<\/strong> and set it to\u00a0Create Drafts<\/strong>. That will ensure that no emails are actually sent. Click the GMass<\/strong><\/span> button to start the creation of your dynamic suppression campaign.
    \n    \"Create<\/a><\/li>\n<\/ol>\n

    Now, every hour, 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<\/strong> will be created, which you can delete if you want to keep your Gmail account clean.<\/p>\n

    You can then use this campaign as the Suppression List<\/strong> for your future email campaigns, by selecting it in the Suppress<\/strong> option under Advanced area of the GMass Settings<\/strong>.<\/p>\n

    \"Now<\/a><\/h3>\n

    Important note about timing:<\/h3>\n

    The suppression campaign will only be updated once hour, 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<\/strong>, it may not suppress addresses that were added to the spreadsheet in the last 60 minutes<\/em>. The odds are low, but it could happen. So if you do update your dynamic suppression Google Sheet, go for a quick walk before you use it as a suppression list in a campaign.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Note: The technique in this article is now deprecated. There’s a MUCH easier way to do this using GMass’s dynamic lists. When sending mail merge campaigns in Gmail\u2026<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[8,4261],"tags":[],"class_list":["post-833","post","type-post","status-publish","format-standard","hentry","category-email-marketing","category-google-sheets"],"acf":[],"yoast_head":"\r\nHow to use a Google Sheets spreadsheet as a dynamic email suppression list<\/title>\r\n<meta name=\"description\" content=\"How to create a Google Sheet to serve as a running suppression list you can use to exclude addresses from selected future campaigns.\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.gmass.co\/blog\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"How to use a Google Sheets spreadsheet as a dynamic email suppression list\" \/>\r\n<meta property=\"og:description\" content=\"How to create a Google Sheet to serve as a running suppression list you can use to exclude addresses from selected future campaigns.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.gmass.co\/blog\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\/\" \/>\r\n<meta property=\"og:site_name\" content=\"GMass Blog\" \/>\r\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/GmailMailMerge\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2017-02-21T19:49:37+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2025-04-23T17:57:34+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2017\/02\/suppression-addressessheet-tinified.png\" \/>\r\n<meta name=\"author\" content=\"Ajay Goel\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@PartTimeSnob\" \/>\r\n<meta name=\"twitter:site\" content=\"@GMassForGmail\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ajay Goel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\\\/\"},\"author\":{\"name\":\"Ajay Goel\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#\\\/schema\\\/person\\\/b5fa74f8765b860701158fd77162fff8\"},\"headline\":\"How to use a Google Sheets spreadsheet as a dynamic email suppression list\",\"datePublished\":\"2017-02-21T19:49:37+00:00\",\"dateModified\":\"2025-04-23T17:57:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\\\/\"},\"wordCount\":460,\"commentCount\":37,\"image\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/suppression-addressessheet-tinified.png\",\"articleSection\":[\"Email Marketing\",\"Google Sheets\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.gmass.co\\\/blog\\\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\\\/\",\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\\\/\",\"name\":\"How to use a Google Sheets spreadsheet as a dynamic email suppression list\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/suppression-addressessheet-tinified.png\",\"datePublished\":\"2017-02-21T19:49:37+00:00\",\"dateModified\":\"2025-04-23T17:57:34+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#\\\/schema\\\/person\\\/b5fa74f8765b860701158fd77162fff8\"},\"description\":\"How to create a Google Sheet to serve as a running suppression list you can use to exclude addresses from selected future campaigns.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.gmass.co\\\/blog\\\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/suppression-addressessheet-tinified.png\",\"contentUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/suppression-addressessheet-tinified.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to use a Google Sheets spreadsheet as a dynamic email suppression list\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/\",\"name\":\"GMass Blog\",\"description\":\"Tips and tricks for sending mail merge and mass email campaigns directly from Gmail\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#\\\/schema\\\/person\\\/b5fa74f8765b860701158fd77162fff8\",\"name\":\"Ajay Goel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g\",\"caption\":\"Ajay Goel\"},\"description\":\"Ajay is the founder of GMass and has been developing email sending software for 20 years.\",\"sameAs\":[\"https:\\\/\\\/twitter.com\\\/PartTimeSnob\",\"https:\\\/\\\/x.com\\\/PartTimeSnob\"],\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/author\\\/ajay-goel\\\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to use a Google Sheets spreadsheet as a dynamic email suppression list","description":"How to create a Google Sheet to serve as a running suppression list you can use to exclude addresses from selected future campaigns.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.gmass.co\/blog\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\/","og_locale":"en_US","og_type":"article","og_title":"How to use a Google Sheets spreadsheet as a dynamic email suppression list","og_description":"How to create a Google Sheet to serve as a running suppression list you can use to exclude addresses from selected future campaigns.","og_url":"https:\/\/www.gmass.co\/blog\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\/","og_site_name":"GMass Blog","article_publisher":"https:\/\/www.facebook.com\/GmailMailMerge\/","article_published_time":"2017-02-21T19:49:37+00:00","article_modified_time":"2025-04-23T17:57:34+00:00","og_image":[{"url":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2017\/02\/suppression-addressessheet-tinified.png","type":"","width":"","height":""}],"author":"Ajay Goel","twitter_card":"summary_large_image","twitter_creator":"@PartTimeSnob","twitter_site":"@GMassForGmail","twitter_misc":{"Written by":"Ajay Goel","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.gmass.co\/blog\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\/#article","isPartOf":{"@id":"https:\/\/www.gmass.co\/blog\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\/"},"author":{"name":"Ajay Goel","@id":"https:\/\/www.gmass.co\/blog\/#\/schema\/person\/b5fa74f8765b860701158fd77162fff8"},"headline":"How to use a Google Sheets spreadsheet as a dynamic email suppression list","datePublished":"2017-02-21T19:49:37+00:00","dateModified":"2025-04-23T17:57:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.gmass.co\/blog\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\/"},"wordCount":460,"commentCount":37,"image":{"@id":"https:\/\/www.gmass.co\/blog\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\/#primaryimage"},"thumbnailUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2017\/02\/suppression-addressessheet-tinified.png","articleSection":["Email Marketing","Google Sheets"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.gmass.co\/blog\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.gmass.co\/blog\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\/","url":"https:\/\/www.gmass.co\/blog\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\/","name":"How to use a Google Sheets spreadsheet as a dynamic email suppression list","isPartOf":{"@id":"https:\/\/www.gmass.co\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.gmass.co\/blog\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\/#primaryimage"},"image":{"@id":"https:\/\/www.gmass.co\/blog\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\/#primaryimage"},"thumbnailUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2017\/02\/suppression-addressessheet-tinified.png","datePublished":"2017-02-21T19:49:37+00:00","dateModified":"2025-04-23T17:57:34+00:00","author":{"@id":"https:\/\/www.gmass.co\/blog\/#\/schema\/person\/b5fa74f8765b860701158fd77162fff8"},"description":"How to create a Google Sheet to serve as a running suppression list you can use to exclude addresses from selected future campaigns.","breadcrumb":{"@id":"https:\/\/www.gmass.co\/blog\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.gmass.co\/blog\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.gmass.co\/blog\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\/#primaryimage","url":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2017\/02\/suppression-addressessheet-tinified.png","contentUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2017\/02\/suppression-addressessheet-tinified.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.gmass.co\/blog\/use-a-google-sheets-spreadsheet-as-a-dynamic-email-suppression-list\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.gmass.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to use a Google Sheets spreadsheet as a dynamic email suppression list"}]},{"@type":"WebSite","@id":"https:\/\/www.gmass.co\/blog\/#website","url":"https:\/\/www.gmass.co\/blog\/","name":"GMass Blog","description":"Tips and tricks for sending mail merge and mass email campaigns directly from Gmail","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.gmass.co\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.gmass.co\/blog\/#\/schema\/person\/b5fa74f8765b860701158fd77162fff8","name":"Ajay Goel","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g","caption":"Ajay Goel"},"description":"Ajay is the founder of GMass and has been developing email sending software for 20 years.","sameAs":["https:\/\/twitter.com\/PartTimeSnob","https:\/\/x.com\/PartTimeSnob"],"url":"https:\/\/www.gmass.co\/blog\/author\/ajay-goel\/"}]}},"_links":{"self":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts\/833","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/comments?post=833"}],"version-history":[{"count":12,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts\/833\/revisions"}],"predecessor-version":[{"id":25261,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts\/833\/revisions\/25261"}],"wp:attachment":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/media?parent=833"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/categories?post=833"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/tags?post=833"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}