Skip to content

Group Merge: Mail Merge for Gmail. 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.

License

Notifications You must be signed in to change notification settings

ttsukagoshi/mail-merge-for-gmail

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

Get this add-on from Google Workspace Marketplace clasp code style: prettier
Accessibility-alt-text-bot CodeQL Deploy Labeler Super-Linter

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

Group Merge icon
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).

About

Group Merge: Mail Merge for Gmail. 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.

Topics

Resources

License

Code of conduct

Security policy

Stars

Watchers

Forks