Create emails including data from your Google Sheet columns. Mail Merge and send these personalised emails with no MMM limits!
Listing updated:November 5, 2023
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
Additional information
PricingFree of charge
Privacy policy
Terms of service
Magic Mail Merge will ask for the permissions shown below. Learn more
Magic Mail Merge will need access to your Google account
This will allow Magic Mail Merge to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Allow this application to run when you are not present
Send email as you
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Clear search
Close search
Google apps
Main menu