Home Email Marketing Gmail Mail Merge: How to Send Bulk Email with Gmail & YAMM

Gmail Mail Merge: How to Send Bulk Email with Gmail & YAMM

How to Send Bulk Email with Gmail & YAMM

There are a lot of reasons why you’d need to send personalized mass emails with Gmail.

The most popular ones include:

The ability to send cold personalized emails in bulk, that also is tailor-made for the tip user (e.g.: victimization their name, victimization nice templates, and then on);

Not having to use BCC or CC;

Not having to plan to Associate in Nursing email promoting platform if you simply need to transport easy plain text reach emails – or maybe email newsletters.

In this tutorial, I will show you how to easily send bulk outreach personalized messages using Gmail – so let’s get going.

First, here is the high-level overview of what this procedure covers:

The goal: to line up a system which will enable you to send bulk reach emails directly from your Gmail account.

The ideal outcome: You will easily send customized emails to multiple addresses, which you won’t have to write manually every time.

The prerequisites: you wish a Gmail inbox and also the ability to assemble all of your data in a very Google Sheet.

Also, you wish a Google Sheets add-on as well—which you’ll install throughout the method, following the steps described in this blog post.

The importance of this action: Outreach emails are very important for a number of different reasons. You can do this for business development, for example. Also, if you’re not using an email service provider (like MailChimp or ActiveCampaign), you can manually keep your emails in one place and then send them out to your users (I don’t recommend this, but it can work for businesses that are just starting out their email list).

Where this can be done: this can be drained Gmail and Google Sheets.

Just as a side note, in general, using Google Drive and G Suite is one of the best options for your business – it’s free, it’s easy to use, and there’s a Google App for all of your basic business needs (Google Docs, Sheets, Slides, and so on).

Plus, you get the prospect to use adjacent free tools which may be extraordinarily useful –like within the case of running a Gmail mail merge campaign, for example.

When this can be done: Anytime you wish to transport bulk reach emails.

Who does this: Anyone on your team who needs to do bulk outreach.

This could be you, your VA, somebody doing backlink reach on the SEO team, or even a sales team reaching bent on potential leads.

Before you begin: set up your environment
There are a couple of things you will need for this:
A Gmail account. You can set up one here if you haven’t done it already.

Install the Google Sheets add-on known as one more Mail Merge.

Create your Gmail Bulk Outreach Database Sheet

Once you’re ready up, you will have to create a database with all of your Google contacts’ information.

However you get these email addresses, you should put them in a Google sheet.

So, here are the steps to follow for this:

Create a replacement Google sheet mistreatment your Google account;

Name it (in my case, this was “Gmail Bulk Outreach Database”);

Set the columns for your database of email recipients:
First Name;
Last Name;

Another Piece of knowledge (something you’ll use to modify your emails).

Keep in mind: other than the “First Name” and therefore the “Email” column, all of the opposite columns are optional—you will use the maximum amount information here as you’d like.

However, it is best for you to gather as much information as you can about the contact group you are sending your outreach emails to—it will help you personalize the emails and increase the response rate.

How to Send Bulk Email with Gmail & YAMM
  • Populate the sheet: it can consist of current customers or information you gathered using a LinkedIn scraping tool, for example.
How to Send Bulk Email with Gmail & YAMM

Enable the “Canned Response” feature in Gmail

Enabling the “Canned Response” feature in Gmail will allow you to create an email message template to use with your outreach campaign, so you don’t have to type them every single time.

Here’s how to do this:

  1. Open Gmail;
  2. Click on the little gear icon → settings;
How to Send Bulk Email with Gmail & YAMM
  • Click on the “Labs” tab;
How to Send Bulk Email with Gmail & YAMM
  • Type “canned responses” into the search bar;
How to Send Bulk Email with Gmail & YAMM
  • Click on “Enable”;
  • Click on “Save changes”.
How to Send Bulk Email with Gmail & YAMM

Write the Email Templates Using Canned Response

Once you have enabled canned responses, you can start writing your mass email templates.

So, here’s how I write canned responses:

  1. Open Gmail.
  2. Start writing an email draft just as you would normally, according to the purpose of your outreach email campaign.
  3. In my case, I pretended this was a sales email and I’m selling widgets, trying to find the best person to talk to at the company to reach out to and talk about my products. So, my first draft email template was this:
How to Send Bulk Email with Gmail & YAMM

Once you have drafted your email template, you have to replace the variables in it (e.g. the First Name, the Company Name, etc.). To do it, follow these steps:
a) Go to your Gmail Bulk Outreach Database.

b) Copy column header for the contact’s forename, in my case: “First Name”.

c) Paste it to switch the particular forename in your email.

d) Add double curly brackets at the beginning and end of “First Name”.

e) Repeat this with all the variables in your email example.

Keep in mind, these variables are case sensitive. For instance, in my Google Sheet column, “First” and “Name” are both capitalized, so I need to use them the same way in my canned response as well (if I typed it in lower case, this wouldn’t work).
Your “Another Piece of Data” can be anything that makes the email more personal.

For instance, I added “like dogs” to my first entry in the Google Sheet, under the “Another Piece of Data” column.

So, at the end of the email template, I added “By the way, I heard you }”.

This is however my email taken care of replacement all the variables:

How to Send Bulk Email with Gmail & YAMM
  • Click on the little arrow next to the trash bin in your email.
How to Send Bulk Email with Gmail & YAMM
  • Click on “Canned Responses” → “New canned response…”.
5.	Click on “Canned Responses” → “New canned response…”.
  • Enter the name of your new canned response. In my case, this was “Quick Question For You” (the subject line I used for the email template).
How to Send Bulk Email with Gmail & YAMM
  • Click “OK”.
  • Check to see if your canned response was correctly added. Open a new email, go to “Canned Responses”, and see if your newly added one is there. Once you click it, the email body should be automatically filled out with your email template text.
How to Send Bulk Email with Gmail & YAMM

Be very, very particular about the email outreach and data privacy laws in your country. These laws change all the time, so it’s always best to talk to a professional in the field about it. For example:
In the United States, there are a couple of things you need to think about before sending out an email outreach campaign:
You need to be honest about your email outreach. Do NOT be deceptive about it, do not make the subject of the emails something entirely different than whatever you’re doing.

Include an unsubscribe link to give users a way to opt out easily if they don’t want you to contact them again.

You can simply do that with “Yet Another Mail Merge”:

Write your “unsubscribe here” text (e.g. “Click here to unsubscribe from these emails”). You can add this at the bottom of your email, for example;
Highlight this text;
Add a hyperlink to it, linking to “https://yet-another-mail-merge.com/unsubscribe”.

In my case, I superimposed this at the tip of the message body, right once my signature.

How to Send Bulk Email with Gmail & YAMM

Put your actual address within the footer of the e-mail.

You can simply kind this out at rock bottom of your email, as a signature, perhaps with a smaller font, and put it aside to all or any of your canned emails.

In the EU, these laws are even more specific, so it is VERY important to check them out and make sure your outreach emails comply with the current legislation.

How to Send Bulk Email with Gmail & YAMM

Install Yet Another Mail Merge Add-on

Now that you have your database set up, your merge template email done, and your canned responses are enabled, you should install the actual Google Sheets add-on that helps you send out the outreach emails.

To add it to your Google Sheets, follow these steps:

  1. Go to the sheet you previously created.

Go to Add-ons → “Get add-ons”.

  • Search for “Yet Another Mail Merge”.
How to Send Bulk Email with Gmail & YAMM
  • Click the “+Free” blue button.
How to Send Bulk Email with Gmail & YAMM
  • You will get a pop-up on the screen and you will be asked to authenticate with your email address. Go ahead and do that.
How to Send Bulk Email with Gmail & YAMM
  • Click on the blue button saying “Allow” to give the add-on the necessary permissions.
How to Send Bulk Email with Gmail & YAMM

Merge the Canned Response Email Template and the Outreach Database

You’re all set up now—all that’s left is to do the actual merge:

  1. Go to your Gmail Bulk Outreach Database sheet;
  2. Click on “Add-ons” in the menu;
  3. Click on “Yet Another Mail Merge”;
  4. Click on “Start Mail Merge”;

The free version of “Yet Another Mail” merge can permit you to send up to fifty emails on a daily basis for complimentary.

If you pay for it, they will allow you a little bit more. And if you’re using a non-Gmail address (i.e. Google Enterprise), you will be allowed to send even more emails (because you are more trustworthy as a Google Enterprise user).

How to Send Bulk Email with Gmail & YAMM
  • Leave the “Sender Name” field as it is;
  • Click the drop-down under “Email Template” and select the template that you wrote;
How to Send Bulk Email with Gmail & YAMM
  • Leave “Track emails opened, clicked or bounced” checked.
How to Send Bulk Email with Gmail & YAMM
  • (Optional) Click on “Alias, filters, personalized attachments”. This is where you can change the reply-to address, check if the email unsubscribe link is detected by the add-on, and so on. Once you’re done with all of these, click “Back”.
How to Send Bulk Email with Gmail & YAMM
  • Click “Receive a test email” to check in a different if everything is in order.
9.	Click “Receive a test email” to check in a different if everything is in order.
  1. Once you checked and made all the necessary edits, you can hit send.
  2. You can also delay the sending of the email by clicking on “Delay delivery” and setting this up.
How to Send Bulk Email with Gmail & YAMM
How to Send Bulk Email with Gmail & YAMM
  1. Click “OK” on the pop-up that will appear on the screen.
  1. A new column will appear in your Google spreadsheet (“Merge status”), as well as a sidebar that will show you basic information about the emails you have just sent out (e.g. how many opened, how many receivers replied, and so on).
How to Send Bulk Email with Gmail & YAMM

Even More Resources

If you’re JUST getting started with digital marketing, take a look at our digital marketing strategy guide, as well as our email marketing strategy guide.

You may also want to check out our “What is Email Marketing?” walkthrough, as well as the ClickMinded Email Marketing Training Course.

Read More


  1. Thanks for another informative blog. The place else could I get that kind of information written in such a perfect means? I’ve a project that I’m simply now working on, and I’ve been on the glance out for such info.


Please enter your comment!
Please enter your name here

Must Read

DON’T Use Paid Ads My Organic Marketing Strategy

Best Organic Marketing Strategy Google generates over 100 billion dollars through paid advertising, per year.

How to Build Backlinks Without Paying for Them

If you want to rank on Google you need backlinks. We all know...

Top 6 Best E-Mail marketing Tools

Finding a Contact Promoting Service Which Matches your Requirements And prerequisites is not overly challenging.

How to Use Twitter SMO for Make A Successful Business In 2019

SMO Twitter Twitter Marketing Tips Utilization...

Google algorithm updates: Top 8 Google algorithm updates, explained

Consistently, Google acquaints changes with its positioning calculation. Some are little changes; others genuinely shake up the...