---
title: "Adding an unsubscribe link to the Google Workspace Solution Gallery ‘Mail merge using Gmail and Google Sheets’"
author: "Martin Hawksey"
date: 2021-02-24T15:51:29+00:00
modified: 2021-02-24T15:53:00+00:00
canonical_url: https://pulse.appsscript.info/p/2021/02/adding-an-unsubscribe-link-to-the-google-workspace-solution-gallery-mail-merge-using-gmail-and-google-sheets/
markdown_url: https://pulse.appsscript.info/p/2021/02/adding-an-unsubscribe-link-to-the-google-workspace-solution-gallery-mail-merge-using-gmail-and-google-sheets.md
categories:
  - "Gmail"
  - "Intermediate"
  - "New IDE"
  - "Sheets"
  - "Solutions"
  - "V8"
  - "Web App"
tags:
  - "hawksey.info"
featured_image: https://pulse.appsscript.info/files/2021/02/null-2.png
description: "Recently I came across a nice post from Ravgeet Dhillon, which looked at how to Add Unsubscribe link in emails using Google Apps Script. Having recently updated my ‘Create a mail merge using Gmail and Google Sheets’ in the Google Workspace Solution Gallery to handle inline images I thought it would be useful to show how this example can be extended to include a variation on Ravgeet’s post."
---

# Adding an unsubscribe link to the Google Workspace Solution Gallery ‘Mail merge using Gmail and Google Sheets’

![Adding an unsubscribe link to the Google Workspace Solution Gallery ‘Mail merge using Gmail and Google Sheets’](https://pulse.appsscript.info/files/2021/02/null-2.png)

> [https://hawksey.info/blog/2021/02/adding-an-unsubscribe-link-to-the-google-workspace-solution-gallery-mail-merge-using-gmail-and-google-sheets/](https://hawksey.info/blog/2021/02/adding-an-unsubscribe-link-to-the-google-workspace-solution-gallery-mail-merge-using-gmail-and-google-sheets/)
> Recently I came across a nice post from Ravgeet Dhillon, which looked at how to Add Unsubscribe link in emails using Google Apps Script. The solution uses a Google Sheet and a Google Apps Script web app to add an unsubscribe link to emails. As I noted when shared via AppsScriptPulse this is a useful addition if your mailing needs comply with PECR or similar electronic communications regulation compliance.
> Having recently updated my ‘Create a mail merge using Gmail and Google Sheets’ in the Google Workspace Solution Gallery to handle inline images I thought it would be useful to show how this example can be extended to include a variation on Ravgeet’s post.

Source: [Adding an unsubscribe link to the Google Workspace Solution Gallery ‘Mail merge using Gmail and Google Sheets’**](https://hawksey.info/blog/2021/02/adding-an-unsubscribe-link-to-the-google-workspace-solution-gallery-mail-merge-using-gmail-and-google-sheets/)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2021/02/adding-an-unsubscribe-link-to-the-google-workspace-solution-gallery-mail-merge-using-gmail-and-google-sheets/](https://pulse.appsscript.info/p/2021/02/adding-an-unsubscribe-link-to-the-google-workspace-solution-gallery-mail-merge-using-gmail-and-google-sheets/)*