How to create a mail merge using Gmail and a Google Drive / Docs spreadsheet to send custom emails to a list of recipients.

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

Anson Alexander is a blogger, author, SEO expert, teacher, and tech geek. As the founder of, Anson works full time writing, editing, and producing content for his site and providing technical and business services to clients. He has a BS in international business and information systems from the University of Tampa. In his free time, Anson plays video games, enjoys nature, spends time at the beach, and loves to travel.

View all posts