How to Create a Mail Merge Using Google Apps Script and Google Forms

The Ultimate Guide for
G Suite Admins

Here’s my quick guide on creating a simple mail merge using Google Apps Script and Google Forms. Certainly a lot of use-cases for this one! Just imagine what you can do.

While there’s a big difference in replicating this video and actually understanding how the Google Apps Script piece of the equation works, it’s not too hard to simply copy the spreadsheet template┬áprovided and mess around a little bit. Don’t forget to change the maxRows value when you add new fields to your form!

Here’s the blog post I refer to in the video –…

What are your favorite uses for this feature? Let me know in the comments!

Get the best tips and tricks in your inbox daily