Help & Support
Send Feedback
Magic Mail Merge
Create emails including data from your Google Sheet columns. Mail Merge and send these personalised emails with no MMM limits!
7,028 users
Works with
Welcome to Magic Mail Merge! 

Magic Mail Merge is mainly designed for teachers to use with their students allowing them to email data from their class tracker as personalised mail merged emails. This add-on can of course be used by anyone to create a mail merged email to anyone recipient of their choice. 

Users can create as many tracking sheets as they require and produce as many different email templates to merge the data to. You can store as many different email templates as you like.

As long as you place your email template in the correct cell on the worksheet you can send whatever emails you like. You can always send a test email to check your mail merge is working correctly before you send it. 

Unlike other add-ons available Magic Mail Merge has no set limits (other than Google's own limits) and will not charge you for this feature. 


If you are a personal Gmail user then you are limited to 100 emails per day

HTML Email Template
Add fields to the Subject of your emails
You can add multiple email addresses to the ‘Email Address’ field by separating each one by a comma
CC & BCC columns - add columns titled CC and BCC in order to add extra email addresses
Customise the sender name for your emails

ReplyTo columns - add column titled ReplyTo in order to customise who the default reply to will be. 
Add PDF attachments from any Google Drive file - add column titles attachment and put the Google Drive file ID in order to attach them to the email as PDFs. Docs, Sheets, Slides and PDFs will be sent as PDFs. Image files will be sent as images in their original format. 
You can also add multiple attachments in this way, just separate by a comma and no space
A User of Magic Mail Merge
February 27, 2018
Brilliant addon and works like a charm. You have to edit the email in Google Sheets which adds an extra step, but its super easy and flexible, plus the developer is brilliant at helping with problems/improvements.
Submit reply
A User of Magic Mail Merge
February 16, 2018
Great App. I used to spend an hour sending a email to each employee, now I can send 150 emails with one click. Also the creator of the app was very helpful when I encountered some issues. Highly recommended.
Submit reply
1-2 of 2
Additional information
Clear search
Close search
Google apps
Main menu