6 mail merge add-ons for Gmail & Google Drive

**UPDATED June 2019 with a sixth add-on!**

Mail merge is one of those great time-saving features that people love. That’s probably why we get heaps of questions about the best way to do it in Gmail and Google Drive. In this blog post we’ll share six mail merge add-ons available in G Suite and help you choose the best one for your situation.

The very first thing you need to consider is what type of merge do you need? ‘Mail merge’ tends to mean different things to different people, so you need to be clear on what you’re trying to achieve before you can choose the right add-on.

Do you want to:

  • Send a personalised email?
  • Send a personal email with a generic attachment?
  • Send a personalised email with a personalised attachment?
  • Send a personalised email with a generic attachment and a personalised attachment?
  • Create personalised documents for storing/sharing in Google Drive?
  • Create personalised documents for printing (including letters, certificates etc.)?
  • Create mailing labels or name tags for printing (i.e. multiple merges onto the same page)?
Need to do a mail merge in G Suite? Decide what type then pick one of these 6 add-ons Click To Tweet

 

The top 6 add-ons

As you may know, G Suite does not have native mail or document merge functionality. However, there are a range of add-ons that you can use for this purpose. They function from within Google Sheets or Google Docs. For all of them, your source data for a merge needs to be stored in Google Sheets (e.g. names, addresses and other data you will use to personalise emails and documents).

We’ve taken a look at many mail merge add-ons and come up with the following top six (in no particular order).

Here is a feature-by-feature comparison of the 6 top mail-merge add-ons for #Gmail & #Google Drive Click To Tweet

 

Picking the right add-on for your needs

Once you have decided what type of merge you need to perform, use the table below to identify a suitable add-on. If you need more information to make your decision, we’ve also put together a feature-by-feature comparison of each of the six add-ons. You can view it here.

Table comparing mail merge tools

Getting started with your chosen add-on

Each of these add-ons have documentation and videos to help you get started. Check out the resources below.

Need more help? Contact us to design a custom mail merge workshop for your team.


Skills Checklist Will Help You Find Out.

Download Free Guide

Latest Blog Posts, New Tips And Tricks

Sign Up Now

Letter merge email

How to mail merge letters in Google Docs

In a recent post, we shared the top five add-ons you can use to perform a mail merge in Google Drive. In this post, we’ll show you how to use one of those tools, autoCrat, to perform a mail merge in Google Docs that creates and emails personalised letters. This same technique can also be used to personalise any other type of document that is based in Google Docs.

VIEW POST

Customise your Chrome Omnibox for efficient searching

Don’t you just love being able to search Google straight from in the Chrome Omnibox? But did you know you can customise this to make searching in your Inbox, YouTube or Google Drive super easy? Actually, anywhere that you can search can be turned into a search engine right there in your Omnibox, and it’s a fast and easy process to set it up.

VIEW POST
Monopoly

Why school is like Monopoly

By utilising the wisdom and experience of staff and creating blended learning environments, students should be able to operate in their preferred modality of learning whilst controlling certain aspects of their learning pathway.
Some of our kids are stuck in a game of educational Monopoly, losing motivation and having nowhere to go as it is raining outside. It is our responsibility to maybe pack away the Monopoly board and introduce a new paradigm to them.

VIEW POST

UTB Newsletter 2020 – Issue 10

October – wow! How did that even happen? Our team continues to be blown away by the dedication and hard work of educators all around the world, working in a multitude of ways to support their learners whether they are online or face to face. The capacity and willingness of so many teachers to throw themselves out of their comfort zone and not only learn, but put into practice new skills, is a credit to the education community.

VIEW POST

Here’s What
Our Clients Say

PR Industrya

Client

In 2018, Using Technology Better designed and delivered a two phase post-migration training program for this New Zealand based graphic design firm. The initial goal of the training program was to reduce frustration with G Suite, with the long term aim of facilitating a change in culture and collaboration that can lead to transformative practices

VIEW FULL CASE STUDY

FREE PDF DOWNLOAD

Are you at a beginner, intermediate, or advanced level? This skills checklist will help you find out.

×

FREE PDF DOWNLOAD

Are you at a beginner, intermediate, or advanced level? This skills checklist will help you find out.

We will only send you awesome stuff!

×

Download your skills checklist to see how you score...