Mail merge add-on to create and send personalized emails. No daily quota. You can use the add-on free of charge and send up to 1500 emails a day from your business account.
Listing updated:September 19, 2023
Works with:
29K+
Overview
With AnyMerge Mail, you can merge spreadsheet data into Gmail messages as text values, images, or QR codes. You can also add multiple attachments.

There is no daily sending limit! Plus, take advantage of two-phase merge, where you can literally create thousands of Gmail drafts first and then send them out later.

A few highlights of the add-on:
- built from the ground up for heavy-duty work
- merges text values, links, QR codes and images into Gmail messages
- add multiple Google Drive files as attachments
- automatically converts Google files (Docs, Sheets and Slides) to PDF
- supports two-phase merge
- automatically saves and restores merge configuration; configure a merge job once, then just run it

Release Notes
November 25, 2020 - Version 1.2
Added predefined templates for ID cards, membership cards, loyalty cards and event tickets. Select a predefined template and the add-on will configure everything for you. 

MOTIVATION
My motivation was to build a suite of add-ons that excel in one thing: reliability. My background is system integration and I built these add-ons from the ground up to be as reliable as possible. There is a lot of logic under the hood to make sure they deliver results as promised. AnyMerge add-ons are meant for heavy-duty work, whether you want to send hundreds of personalized emails with the AnyMerge Mail add-on, or generate hundreds of Google Documents with the AnyMerge Docs add-on.

NEW KID ON THE BLOCK
The AnyMerge Mail add-on for Google Spreadsheets is the new kid on the block. There are plenty of other mail merge add-ons, yet AnyMerge Mail stands out and offers features that other add-ons do not have.

NO DAILY SENDING LIMIT
While other mail merge add-ons let you send just a fraction of your daily quota allowed by Google for free, AnyMerge Mail add-on does not have a daily sending limit at all. Your only limit is the type of Gmail account you use. With a Gmail business account, you can send up to 1 500 personalized emails per day from the add-on and reach your audience with ease.

USE IT FOR FREE
You can use the add-on absolutely free of charge. Well, there is a small catch when using the add-on for free — the add-on appends a link to each message you send. I am more than happy to see people using the add-on for free but spread the word. I put a lot of effort into developing this tool.

MERGE QR CODES AND IMAGES INTO GMAIL MESSAGES
AnyMerge Mail does not just do simple text merge. You can use it for pretty complex operations like merging multiple QR codes, or images as well as attachments into Gmail messages.

ADD MULTIPLE ATTACHMENTS
Furthermore, the add-on allows you to take multiple attachments from your Google Drive and include them in Gmail messages, so you can further automate your daily workflows. You can use the AnyMerge Docs add-on to generate Google Documents, then send them as attachments with the AnyMerge Mail add-on.

For example, you can generate a bunch of invoices first with the AnyMerge Docs add-on, then send them with the AnyMerge Mail add-on. You can streamline the entire process and move from your manual, error-prone method to a smooth, automated workflow.

TWO-PHASE MERGE
One of the unique features of the add-on is the so-called two-phase merge. The add-on can merge spreadsheet data into Gmail drafts, and you can send the drafts later. Why would this be useful?

The two-phase merge is particularly handy for long-running tasks where you would like to process hundreds of emails with a very complex setup. Doing a simple merge of text values into Gmail messages is fast. Once you start adding more complex things like QR codes or multiple attachments, processing times will increase, and you can easily end up with processing times over one minute for a single message.

With two-phase merge, you can let the add-on create drafts only first (phase one). Depending on how many emails you would like to process, it might take several hours to complete. Just make sure your workstation will not go to sleep and keep an eye on the process. Or run the merge job overnight. Once the merge job is over and all those drafts are sitting in your drafts folder. you can send them (phase two). Sending pre-made drafts is much faster.

Another great advantage is that there is no daily quota on how many drafts you can create. You can create literally thousands of drafts per day and send them later in smaller batches.

Take advantage of two-phase merge when your merge setup is complex and takes a long time to finish. Generate drafts first and send them later.

NO EMAIL TRACKING
The add-on does lack some features that other add-ons provide. Most prominent is email tracking. If this is the top feature you are looking for, do not waste your time and look for other solutions. I am not going to implement this feature in the foreseeable future.

PRIVACY MATTERS
Once any add-on has access to your Gmail, it can access your Gmail messages and there is a possibility of leaking private data. The AnyMerge Mail add-on cannot make external requests, meaning that there is no way the add-on can send your data to a third party. At installation, you need to grant permission and authorize the add-on. For a detailed explanation of what the add-on does, please read the privacy policy before you install the add-on.


Happy merging!
Additional information
PricingNot available
Developer
Privacy policy
Terms of service
AnyMerge Mail will ask for the permissions shown below. Learn more
AnyMerge Mail will need access to your Google account
This will allow AnyMerge Mail to :
See and download all your Google Drive files
View and manage spreadsheets that this application has been installed in
See and edit your email labels
Read, compose, and send emails from your Gmail account
Display and run third-party web content in prompts and sidebars inside Google applications
Send email as you
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
PEI Trail Riders
May 24, 2021
This is a great Add-On, very useful for managing our club newsletters, membership cards, emails, etc. It took me a while to get things working properly for the card (more to do with my lack of techno skillz than with the program itself), but the developer was EXTREMELY responsive when it came to helping me figure things out. Would highly recommend.
Is this review helpful?
Yes
No
Profile Picture
Edith Oyosoro
June 3, 2021
The add on tab doesn't appear on all my Google spreadsheets but it works well on the sheets where it appears. I'd like to explore this add-on and would require support. For example, does the paid subscription allow for personalized templates?
Is this review helpful?
Yes
No
Profile Picture
Studios Booking
May 13, 2021
I really like AnyMerge Mail, it makes my job as a studio coordinator easier because this helps me with my email confirmations. It helps me save time and thus gives me more time to work on more important manual efforts for my job. I really appreciate this tool. Thank you for creating it!
Is this review helpful?
Yes
No
Profile Picture
Allison Higgins
February 6, 2021
amazing- easy to use. bug free and a huge time saver
Is this review helpful?
Yes
No
Profile Picture
Peter Olliver
September 8, 2022
Says it is installed, but I cannot find it in sheets or gmail- have spent 4 hours trying to get it started. Frustrated beyond belief
Is this review helpful?
Yes
No
Profile Picture
Admin SKID
February 25, 2021
easy to use. i use to send ID Card to all student in school via email... very helpful.
Is this review helpful?
Yes
No
Profile Picture
Christian Severa
February 7, 2021
Easy to use
Is this review helpful?
Yes
No
Profile Picture
Jukebox Nation
July 14, 2021
I am having problems with the sample sheet importing incorrect data from the original sheet. Any suggestions?
Is this review helpful?
Yes
No
Profile Picture
Cosburn Bowls
May 23, 2021
Easy to use, does what it’s supposed to
Is this review helpful?
Yes
No
Profile Picture
Ron Coach
February 9, 2021
Easy and simple to use ... I recommend...
Is this review helpful?
Yes
No
1-10 of 12
Search
Clear search
Close search
Google apps
Main menu