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 –http://googleappsdeveloper.blogspot.com/2011/10/4-ways-to-do-mail-merge-using…
What are your favorite uses for this feature? Let me know in the comments!