Performing a Mail Merge with Google Docs (To Create Documents or Emails)

Google Docs is wonderful in many ways, however, there are a couple of areas where it has limited functionality that were issues for me recently and this is the second of a two-part series of blog posts (see the first part here) on what I did to work around those limitations.

A Google Docs mail merge is not a native capability of Google Docs. Said another way, Google Docs does not natively offer the ability to do a mail merge (that is, it does not offer the ability to use a template document with special data placeholders and create a set of documents from a set of data where the data is used to populate the values for the special data placeholders in the template document). Fortunately, Google Docs does natively offer the ability to use 3rd party extensions and the excellent DocumentMerge by PandaDoc extension will allow you to do mail merges.

The instructions for how to use DocumentMerge by PandaDoc to perform a mail merge using a Google Sheet as the data source for a template Google Doc can be found at https://www.pandadoc.com/google-docs-document-merge. I won't belabor things by repeating the instructions here; the reason I'm writing this post is that for me, the DocumentMerge by PandaDoc extension wasn't easy to find when searching for a way to do a mail merge with Google Docs and I'm hoping that this blog post will bubble up in search results in the future, making it easier for others to find the extension (if this blog post is helpful to you, please take a moment to leave a comment if you're willing). To be more specific, what I was looking for was the ability to do a mail merge that produced printable documents but all I was able to find was info on how to do mail merges to create emails (which the DocumentMerge by PandaDoc extension will do as well so if that's what you're looking for, it's good for that too).

Anyway, it's a great extension for doing a mail merge with Google Docs (though for some reason it's fairly slow). You'll see that it creates a Google Doc as the output of your mail merge and from there, that document is just like any other Google Doc (meaning you can download it, print it, whatever you need to do). In addition, DocumentMerge by PandaDoc has another capability as well: if you want to email out each of the merged documents as a PDF attached to an email, you can do that directly with DocumentMerge by PandDoc which is a great feature (albeit one I haven't used since in my case I just needed to print the merged documents).

Comments
sarah's Gravatar Very sad to see that DocumentMerge is no longer being supported. I'm autocrat doesn't exactly do what I need it to do.
# Posted By sarah | 5/5/15 7:10 PM
Kate's Gravatar Panda website says: We are no longer offering Google Docs Document Merge add-on. Sorry for any inconvenience this may have caused.
# Posted By Kate | 5/28/15 12:09 AM
Josh Adams's Gravatar That's a real bummer that DocumentMerge by PandaDoc been taken down; thanks for letting me know, Sarah and Kate. I don't have a need for this functionality now but the next time I need it, if I can't find a suitable replacement, I may not have any choice but to go back to using Microsoft Word.
# Posted By Josh Adams | 5/28/15 12:33 AM
Josh Adams's Gravatar @Sarah: so sorry to hear that autoCrat doesn't suit your needs. I just needed to do a mail merge and for me, autoCrat worked great! Really, autoCrat is better for me than DocumentMerge was anyway.
# Posted By Josh Adams | 11/22/15 10:34 PM
Andrew Dimech's Gravatar There is now a new Google Doc Add-on which can help you Mail Merge to emails or letters. You can view/install it from the chrome store:

https://chrome.google.com/webstore/detail/mail-mer...
# Posted By Andrew Dimech | 12/15/15 3:05 PM
Sarah's Gravatar I'm surprised there wouldn't be an add on for this popular task. I too used Panda Docs and can't find anything as easy or simple. Looks like autocrat may be gone too? At least, I can't find it when searching add ons. I tried the one suggested by Andrew Dimech but it has a limited number of fields, and I want ones currently in my spreadsheet.
# Posted By Sarah | 3/15/16 1:33 PM
Justin's Gravatar Why not create a app that uses Google APIs to merage mails. Here is how it can be done https://www.zozuk.com/google-app-maker/
# Posted By Justin | 8/29/17 3:53 AM
sv's Gravatar The launch of the http://www.bestukwatches.co.uk new timepiece series undoubtedly symbolizes the http://www.replicawatches0.co.uk history of the brand, and the classic http://www.replicawatchesshop.co.uk design explains the mission of the http://www.replicawatchess.uk.com brand's precision watchmaking.
# Posted By sv | 7/17/18 9:45 PM
petterson's Gravatar This is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value of providing a quality resource for free.
https://www.affordable-dissertation.co.uk/disserta...
# Posted By petterson | 7/21/18 6:45 AM
assignment writing help's Gravatar There are various features of google we can use for different works. i did not have knowledge about ll of them. but this article guides me for it.
# Posted By assignment writing help | 7/21/18 7:00 AM
Packers and Movers in Pune's Gravatar As we know about the new place everything for them so it is hard to manage to get adjust to the new place. So, you need to share about the shifting reason with their kids in appropriate way. A kid needs special attention right at that moment of shifting and for many days after shifting as well. More info visit: https://assuremoving.in/packers-and-movers-pune/
# Posted By Packers and Movers in Pune | 7/24/18 2:35 AM
Packers and Movers Mumbai's Gravatar See youngsters when you internal after shifting. Ask them about the shifting new place, if they are comfortable with the shifting. Involve with them in the operation of shifting so that they enjoy with you and they will not feel bad about it. Let them label their toys, books and clothes for the packers and movers to go. More info visit: https://assuremoving.in/packers-and-movers-mumbai/...
# Posted By Packers and Movers Mumbai | 7/24/18 2:36 AM
Movers and Packers in Hyderabad's Gravatar Assign them small tasks, enjoyable execute that they can that comes with happiness. Along with all this, you need to be more complicated with kids that keep counselling with them about the new place, school and new neighbours and making new friends so that they are well prepared when they actually face it. More info visit: https://assuremoving.in/packers-and-movers-hyderab...
# Posted By Movers and Packers in Hyderabad | 7/24/18 2:36 AM
Movers and Packers Bangalore's Gravatar It is very necessary to understand the mind-set of kids to have a relaxed shifting. Home shifting costs are not fixed in Native Indian. Its depend on the requirement of customer and products because everyone have different types of house keep products so several types of shifting costs apply here. More info visit: https://assuremoving.in/packers-and-movers-bangalo...
# Posted By Movers and Packers Bangalore | 7/24/18 2:37 AM
Packers and Movers in Chennai's Gravatar Sometimes it’s depending on the customer needs. Getting a using several types of consignments at their residence, each products needs different types of appearance during appearance and shifting one place to another. So the shifting cost simply varies for every person. More info visit: https://assuremoving.in/packers-and-movers-chennai...
# Posted By Packers and Movers in Chennai | 7/24/18 2:37 AM
Taniya sharma's Gravatar <a href="http://www.onlinegedichten.nl/"" target="_blank">http://www.onlinegedichten.nl/";>Check Support</a>
[URL=http://www.onlinegedichten.nl/]Check Support[/URL]
[url=http://www.onlinegedichten.nl/]Check Support[/url]
[URL="http://www.onlinegedichten.nl/"" target="_blank">http://www.onlinegedichten.nl/";]Check Support[/URL]
[url="http://www.onlinegedichten.nl/"" target="_blank">http://www.onlinegedichten.nl/";]Check Support[/url]

http://www.onlinegedichten.nl/
# Posted By Taniya sharma | 7/24/18 5:33 AM
Quickbooks Support Number's Gravatar Although there are all of the each and every problem which you might information it with the help of QuickBooks technical support group team variety where you will discover out the qualified professionals who will help you in each and every technical hiccups which you cope with in it.
http://www.accountingpre.com/phone-number/quickboo...
# Posted By Quickbooks Support Number | 7/24/18 5:39 AM
Quicken Support Number's Gravatar Through experts help, you can maintain cost-effective program easily. You will also get immediate up-dates on your hard earned cash through this method. Of course, you may even see some eventual growth in the cash place.
http://www.accountingpre.com/phone-number/quicken/...
# Posted By Quicken Support Number | 7/24/18 5:47 AM
Sage Support Number's Gravatar This will redirect you to a conversation box where you need out there yes or no. Hit the yes key allowing allowing the changes. Your AVG details information information file will be began.
Looking at the upper right position, choose you’re developing language and hit the set up weblink for ongoing along with the regular developing.
http://www.accountingpre.com/phone-number/sage/
# Posted By Sage Support Number | 7/24/18 5:52 AM
AOL support number's Gravatar Hi, this is nice articale...
Looking for AOL support number, visit on:
AOL support number
# Posted By AOL support number | 8/11/18 3:56 AM
used pool tables's Gravatar I remeber that day when i created my first email before that i thought only those with money can created a email. I had a pool table manufacturing business back then and i need something to contact my clients so email was the best solution after i create them it increased my pool tables sales to maximum.
https://brunswickbilliards.hatenablog.com/entry/20...
# Posted By used pool tables | 8/13/18 2:38 AM
# Posted By ronw1309 | 8/19/18 7:23 AM
AOL support number's Gravatar Hi, this is nice articale...
Looking for AOL support number, visit on:
AOL support number
# Posted By AOL support number | 8/28/18 7:26 AM
Technical Support's Gravatar http://tech.contact-support-phone-number.com/
http://tech.contact-support-phone-number.com/apple-support/
http://tech.contact-support-phone-number.com/mac-support/
http://tech.contact-support-phone-number.com/iphone-support/
http://tech.contact-support-phone-number.com/dell-support/
http://tech.contact-support-phone-number.com/epson-support/
http://tech.contact-support-phone-number.com/hp-support/
http://tech.contact-support-phone-number.com/microsoft-support/
http://tech.contact-support-phone-number.com/microsoft-support/
http://tech.contact-support-phone-number.com/quickbooks-support/
http://tech.contact-support-phone-number.com/mcafee-support/
http://tech.contact-support-phone-number.com/quicken-support/
http://tech.contact-support-phone-number.com/toshiba-support/
http://tech.contact-support-phone-number.com/asus-support/
http://tech.contact-support-phone-number.com/windows-support/
http://tech.contact-support-phone-number.com/outlook-support/
http://tech.contact-support-phone-number.com/netgear-support/
http://tech.contact-support-phone-number.com/linksys-support/
http://tech.contact-support-phone-number.com/hotmail-support/
http://tech.contact-support-phone-number.com/avast-support/" target="_blank">http://tech.contact-support-phone-number.com/avast...
http://tech.contact-support-phone-number.com/avg-support/
http://tech.contact-support-phone-number.com/microsoft-office-support/
http://tech.contact-support-phone-number.com/trend-micro-support/
http://tech.contact-support-phone-number.com/adobe-support/
http://tech.contact-support-phone-number.com/nuance-dragon-support/
http://tech.contact-support-phone-number.com/bitdefender-support/
http://tech.contact-support-phone-number.com/hewlett-packard-support/
http://tech.contact-support-phone-number.com/lenovo-support/" target="_blank">http://tech.contact-support-phone-number.com/lenov...
http://tech.contact-support-phone-number.com/google-chrome-support/
http://tech.contact-support-phone-number.com/charter-support/
http://tech.contact-support-phone-number.com/dropbox-support/" target="_blank">http://tech.contact-support-phone-number.com/dropb...
http://tech.contact-support-phone-number.com/dlink-support/
http://tech.contact-support-phone-number.com/verizon-support/
http://tech.contact-support-phone-number.com/cisco-support/
http://tech.contact-support-phone-number.com/pogo-support/
http://tech.contact-support-phone-number.com/yahoo-support/
http://tech.contact-support-phone-number.com/webroot-support/
http://tech.contact-support-phone-number.com/lexmark-support/
http://tech.contact-support-phone-number.com/kaspersky-support/" target="_blank">http://tech.contact-support-phone-number.com/kaspe...
http://tech.contact-support-phone-number.com/gmail-support/" target="_blank">http://tech.contact-support-phone-number.com/gmail...
http://tech.contact-support-phone-number.com/canon-support/" target="_blank">http://tech.contact-support-phone-number.com/canon...
http://tech.contact-support-phone-number.com/brother-support/
http://tech.contact-support-phone-number.com/belkin-support/
http://tech.contact-support-phone-number.com/acer-support/
http://tech.contact-support-phone-number.com/aol-support/
# Posted By Technical Support | 8/28/18 7:28 AM
yellow teeth's Gravatar i need a doctor who can transform me into a super human because cracking dentist exam is really hard i need to follow this website http://goodentists.net for sure.
# Posted By yellow teeth | 9/20/18 7:26 AM
BlogCFC was created by Raymond Camden. This blog is running version 5.9.002. Contact Blog Owner