PDF Creator – Email form submission in a PDF

This script automatically emails the submission from a Google Form as a PDF. The PDF is created by populating a Google Doc template from the values in the Google responses spreadsheet.

It is another variation on the basic PDF Creator script.

The script takes the fields from the form submission row and using a Google Doc template (identified by TEMPLATE_ID) creates a PDF doc with these fields replacing the place-holders in the template. The place-holders are identified by having a % either side, for example %Name%.

As well as being automatically triggered by a form submission it can also be invoked using the “Create PDF” custom menu in the responses spreadsheet.

You can optionally specify a name for the PDF file by providing a field called “File Name”.

Take a look at the Form Publisher add-on if you want an off the shelf solution.

Get in touch now if you need any help with this or any other GAS scripts or have a look through some other free scripts and snippets.

Setting up the script

The easiest way to get going is to take a copy of the demo GSheet (File > Make a copy…). This contains the script and creates a new GForm for you to customise. You then need to create the “on form submission” trigger”, create a Google Doc template and link it to the script.

 

  • Open the script editor (Tools > Script editor…)

 

Open script editor

 

  • Open the trigger’s (Resources > Current project’s triggers)

 

Display triggers

 

  • Trigger createPdf() “on form submission”

 

screenshot-2016-11-09-at-14-56-41

 

  • On clicking Save “Allow” the permissions the trigger requests

 

Review permissions

Allow permissions

 

  • Create your own Google Doc template for the PDF using place-holders of the form %[field name]%. For example %Name%This is an example GDoc.

 

  • In the script editor add the template doc ID (https://docs.google.com/document/d/ID NUMBER HERE/edit)

 

 

Complete TEMPLATE_ID

 

  • Add you own EMAIL_SUBJECT and EMAIL_BODY in the script

 

Update email subject and body

 

You can now open the Google Form (probably called “Copy of PDF Creator – Email on form submit” at this point) and do a test submission to your own email address.

If you have already created the form you can copy the script below into your own responses sheet.

Here is the Gist of the scipt.