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

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:
# 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
# Posted By Justin | 8/29/17 3:53 AM
Adidas UK's Gravatar's-day-2018_26162.html's_9961.html's_3511.html's-classic-cortez_9908.html's-ultra-boost-running-shoes_2420.html
# Posted By Adidas UK | 3/15/19 11:49 AM
yolo's Gravatar" target="_blank">
# Posted By yolo | 3/20/19 5:12 AM
Goyard Handbags's Gravatar
# Posted By Goyard Handbags | 3/21/19 3:16 PM
Nike Outlet's Gravatar
# Posted By Nike Outlet | 3/21/19 8:00 PM
Jorden's Gravatar Google doc is one of the important element in corporate life. Earlier we used to save our documents in the hard disk. Then we have started to use a portable hard disk. Now we use online cloud storage for data storage. It's faster and really helpful. As you can access the file anytime and anywhere from the world. It saves your time and works both.
# Posted By Jorden | 4/4/19 5:41 AM
Essay writing Services's Gravatar Excellent and nice post. It will beneficial for everyone. Thanks for sharing such a wonderful post. Avail No 1 Essay writing services UK from certified PhD writers. It is extremely helpful for me. You can email us at or Phone Number - 020 8144 9988
# Posted By Essay writing Services | 4/10/19 7:27 AM
Max Rusel's Gravatar Thank you for bestowing this information which will enlighten many of us. It’s really helpful for me and the one who wants to know more about mobile app development company.
# Posted By Max Rusel | 4/18/19 3:39 AM
Nike Outlet's Gravatar's-nike-free-rn-flyknit-2019-running-shoes_13472.html's_11442.html's_14947.html
# Posted By Nike Outlet | 5/1/19 4:59 PM
Nike Store's Gravatar's_10615.html's-lite-racer-w-casual-sneaker_17721.html's-gel-cumulus-18_15170.html's_17981.html's-lebron-15_8984.html's_12360.html's-adidas-originals-superstar-shoes_17375.html's_10145.html's_4706.html's_2562.html's-running-shoe_15467.html's-nmd-shoes_14552.html's-nike-free-rn-2018-running-shoes_8985.html
# Posted By Nike Store | 5/7/19 6:03 AM
Pandora's Gravatar
# Posted By Pandora | 5/18/19 11:08 PM
Air Max 270's Gravatar
# Posted By Air Max 270 | 5/19/19 7:19 AM
Adidas Superstar's Gravatar
# Posted By Adidas Superstar | 6/12/19 7:05 AM
Amrita's Gravatar Thank you for sharing your knowledge and experience with me." target="_blank">" target="_blank">
# Posted By Amrita | 6/17/19 3:24 AM
physiotherapy in Hanoi's Gravatar Vedic Wellness offers best natural treatment for pain relief. We have Natural massage and solutions for Headaches, joint pain, shoulder pain and backaches. We also offer Physiotherapy, Ayurveda herbal massage therapies and Degeneration treatment in Hanoi.
# Posted By physiotherapy in Hanoi | 6/20/19 6:03 AM
Adidas Store's Gravatar's-day_715.html
# Posted By Adidas Store | 6/20/19 8:05 AM
avis montre komono's Gravatar <a href=""... montre komono</a> «HAPPY»
# Posted By avis montre komono | 6/25/19 12:20 PM
avis montre komono's Gravatar <a href=""... montre komono</a> «HAPPY»
# Posted By avis montre komono | 6/25/19 12:21 PM
Elision's Gravatar Thank you for the detailed information..
# Posted By Elision | 6/29/19 2:19 AM
Nike Outlet Store's Gravatar's-free-rn-flyknit-2019_4449.html's-running-shoes_9609.html
# Posted By Nike Outlet Store | 7/8/19 10:50 PM
Deepti's Gravatar Thanks for the post. It was very interesting.
# Posted By Deepti | 7/10/19 8:50 AM
vedic wellness's Gravatar how to increase concenteration & Focus

We at Vedic wellness firmly believe in breathing techniques to tackle stress. Questions like how to increase concentration and focus must have been on your mind. Look no further as we guide you with meditation techniques, so you can use them at home to get rid of stress and increase concentration levels. Not only this, but we have great range of beauty therapies for you. We believe that a relaxed body and mind maximizes the potential of an individual.Give a call to us at +84 363804492, or you can email at
# Posted By vedic wellness | 7/11/19 5:04 AM
# Posted By montres 24-heures slow | 7/11/19 4:27 PM
Arjun Singh's Gravatar Thanks for this valuable post. Thanks for sharing this.
# Posted By Arjun Singh | 7/15/19 6:19 AM
Geetanjali's Gravatar Thanks for share...
# Posted By Geetanjali | 7/19/19 7:54 AM
BlogCFC was created by Raymond Camden. This blog is running version 5.9.002. Contact Blog Owner