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

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

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

I am an author, digital educator and content marketer. I record, edit, and publish content for AnsonAlex.com, provide technical and business services to clients and am an avid self-learner. I have also authored several digital marketing and business courses for LinkedIn Learning (previously Lynda.com).

View all posts