Group Merge: Mail Merge for Gmail (English / 日本語)

An open-sourced Google Workspace Add-on to send personalized emails based on Gmail template to multiple recipients using Google Sheets. The Group Merge feature allows the sender to group the contents of two or more rows into one row for a single recipient.

Legacy Spreadsheet Version
The version 1 series, a legacy version preceding the current Google Workspace Add-on versions, is no longer maintained. It is available as a GitHub branch together with the sample spreadsheet.

Overview

Send personalized emails based on Gmail template to multiple recipients using Gmail and Google Sheets. The namesake Group Merge feature allows the sender to group the contents of two or more rows into one email for a single recipient.

Similar to the mail merge feature available in Microsoft Word, Group Merge allows Gmail/Google Workspace users to send personalized emails to the recipients listed in a Google Sheets spreadsheet. Some notable features are:

• Group Merge feature combines contents of two or more entries for the same recipient into a single email.
• Use Gmail drafts as template for mail merge. HTML styling, file attachments, CC & BCC recipients, and Gmail labels are preserved in the personalized emails.

How to Use

Details of the add-on is described in the app's web page.

Terms and Conditions

You must agree to the Terms and Conditions (TaC) to use this add-on. The disclosure on privacy and OAuth scopes constitutes part of this TaC.

Contribute

Contributions are welcome! Please see our Contributing Guideline for details on how to contribute to this project.

Attributes

The original icon of this add-on was made by Freepik from www.flaticon.com and its colors are modified to fit the theme color of the app.

Acknowledgements

This work was inspired by Tutorial: Simple Mail Merge (Google Apps Script Tutorial).