How to do mail merge with Yet Another Mail Merge (Gmail & a spreadsheet)

Use this link to install the add-on :

For more information and support, go to this webpage :
or simply email us:

With Yet Another Mail Merge, easily send personalized emails or newsletters to a list of recipients without the need to know how to write HTML for your templates.
Write your own template as a draft in Gmail or use the predesigned template that is available, send test emails and track the opened emails in real time thanks to a very simple user interface.

Yet Another Mail Merge works with Google Accounts (including Google Apps for Work, Google apps for Education and Google Apps for Government).
You can use it to improve your communication with students, parents and colleagues, with your customers or to reach a broader audience if you own a business, or simply to email your family and friends. As an email marketer, if you need to send newsletters or promotional emails, you can use the predesigned template we show in this video tutorial. Personalizing the subject line and email body can increase your open rate.

The add-on is really simple to use. You just need Gmail and a Google Spreadsheet.
In a Spreadsheet, create columns containing specific data you want to put in the emails (names, cities, different greetings for each recipient…, and of course the recipients’ email addresses).
In Gmail, write a draft that will become your template. Every time you need to insert specific data from the Spreadsheet, just copy the column header and paste it in the draft where it’s supposed to appear, using simple markers.
In the Spreadsheet, simply start the add-on. It will ask you to select the column with the email addresses, then select your draft, write how you want your name to appear as the sender, and start the mail merge!
All the markers will be replaced by the data in your spreadsheet, and recipients will receive a personalized email.


16 thoughts on “How to do mail merge with Yet Another Mail Merge (Gmail & a spreadsheet)”

  1. Hi, if I were to purchase the personal plan which cost 24$ per year that increases the limit to sending out 400 emails per day, and the information from google shows that the Gmail mail server itself has a send limit of approximately 100-150 emails per day when connected to the server from a remote email client.
    So the question is, purchasing the personal plan from the add on itself will allow me to send extra emails out per day, or I would have to pay more cost for Gmail server itself to do that.

  2. I have 2 question, pls explain to me:
    – if i send many emails, will gmail server bring my account to spam folder, because the spam filter system is very strong.
    – I tried with 3 emails, 1 is Gmail, the rest is others non-google acc, it only tracked Gmail, didn't work for the rest.

Leave a Comment

Your email address will not be published. Required fields are marked *