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.
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.