JotForm & Google Docs Mail Merge

A fully automated custom mail merge using Jotform, Google Docs and Google App Script.

On a Jotform submission, a Google App Script creates copies of the required documents based on the selected course(s), populates them with the correct student info, converts them to PDFs, attaches them in a mail and then removes the files after the mail is sent.

This has fully automated a previously very slow manual process of creating and sending course material and certificates to students.