Open-sourced mail merge add-on using Gmail™ and Google Sheets. Free for all.
Listing updated:July 1, 2022
Works with:
5K+
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.  OPEN-SOURCED and FREE!

Like 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 the template for mail merge. HTML styling, file attachments, CC & BCC recipients, and Gmail labels are preserved in the personalized emails.

Please visit the website for more details!
https://www.scriptable-assets.page/add-ons/group-merge/

Source code is available at:
https://github.com/ttsukagoshi/mail-merge-for-gmail

Attributes:
The original icon of this add-on was made by Freepik (https://www.freepik.com/) from www.flaticon.com (https://www.flaticon.com/) and its colors are modified to fit the theme color of the app.
Additional information
PricingFree of charge
Developer
Privacy policy
Terms of service
Group Merge: Mail Merge for Gmail™ will ask for the permissions shown below. Learn more
Group Merge: Mail Merge for Gmail™ will need access to your Google account
This will allow Group Merge: Mail Merge for Gmail™ to :
See, edit, create, and delete all your Google Sheets spreadsheets
Run as a Gmail add-on
Manage drafts and send emails
Read, compose, and send emails from your Gmail account
Allow this application to run when you are not present
Send email as you
View your country, language, and timezone
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Timo Müller
June 7, 2023
Works great and since it allows bcc you can easily integrate it with a CRM like Hubspot. Thanks for your work and keeping it free and open source!
Is this review helpful?
Yes
No
Profile Picture
PPatel 24769
May 12, 2022
won't work
Is this review helpful?
Yes
No
Profile Picture
Danny Bale
December 15, 2021
Can't get it to work. :-( Unexpected Error: TypeError: Cannot read property 'groups' of undefined at src/mailMerge:483:93 at Array.reduce () at mailMerge (src/mailMerge:482:48) at sendEmails (src/mailMerge:348:28) at __GS_INTERNAL_top_function_call__.gs:1:8
Is this review helpful?
Yes
No
Profile Picture
Hiroko
July 11, 2021
このようなアラートが出まして、先にすすめません。。。 Unexpected Error: Exception: Invalid email: NA at mailMerge (src/mailMerge:533:28) at createDraftEmails (src/mailMerge:285:28) at __GS_INTERNAL_top_function_call__.gs:1:8
Is this review helpful?
Yes
No
1-4 of 4
Search
Clear search
Close search
Google apps
Main menu