How to Create a Mail Merge with Gmail and Google Drive / Docs

Mail Merge Google Drive Docs Spreadsheet

How can I create a mail merge using Gmail and Google Drive / Docs?

This is one of the more common questions I’ve been asked lately related to Google Drive – especially for people and organizations that have recently migrated over to Google Apps from Outlook or a similar system.

See Also: Google Docs and Google Drive Video Tutorial 2013

Is it possible to do a mail merge with Gmail and Google Drive?


The video tutorial below shows you how to create a mail merge in Gmail / Google Drive from start to finish but it is as simple as creating an email draft and then a spreadsheet containing all of yours users’ data.

In order to successfully complete a mail merge using these two integrated systems, a script must be applied to the Google Spreadsheet that you would like perform a mail merge with.

Many Google Drive mail merge scripts are available but the one that I prefer is called “Yet Another Mail Merge.”

Once your mail merge email draft is written using the associated Google Spreadsheet column headings – $%ColumnHeading% (as shown in the video), your data is completely filled out in the GSheet and the script is installed, you are ready to perform your mail merge!

Take a look at the video below for detailed instructions on creating a mail merge with Gmail and Google Drive!

If you would like to learn more about using Google Drive / Google Docs, please take a look at my 4 part video tutorial on using Google Drive in 2013.

If you have any questions regarding mail merges, Gmail or Google Drive, let me know in the comments section below or on the comments section on YouTube.

As always, if you find the video below helpful, I would really appreciate a thumbs up and you may also want to think about subscribing to my YouTube channel.

Anson Alexander

About Anson Alexander

Anson has been publishing to since early 2011 and has recently opened an headquarters office to focus on the brand full time.

Anson specializes in providing software and technology tutorials in both print and video format. With hundreds of tutorials published on, Anson has also authored and recorded 7+ courses for as well as other media companies.

Anson has a degree in International Business and Information Systems from the University of Tampa and also enjoys enjoys traveling and gaming.

Please send business inquires to

Also connect with Anson on Google+.

Weekly Email Updates

Archive 2011-2016 All Rights Reserved. [How to Create a Mail Merge with Gmail and Google Drive / Docs]