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.
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.
Details of the add-on is described in the app's web page.
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.
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.
This work was inspired by Tutorial: Simple Mail Merge (Google Apps Script Tutorial).