Create customized files upon form submission with Form Publisher (Google Forms)
Channel: Romain Vialard
Date: 07/08/2015

Form Publisher generates customized documents and notifies recipients upon form submissions.
The principle of the add-on is clever and simple: upon each form submission, Form Publisher retrieves a template that you created (either a Google Doc or a Google Spreadsheet) and replaces specific markers in the template by the answers that were submitted within the Google Form.
This way, the answers will appear in a document customized to your liking. The generated files can be Google Docs, Google Spreadsheets and PDFs.
You can also automatically notify and send the generated files to any recipient you want, giving them different permissions if needed.

For more information and support, go to this webpage : 
https://sites.google.com/site/scriptsexamples/available-web-apps/form-publisher

Use this link to install the add-on : http://goo.gl/9HXcOv

Form Publisher is really easy to set up. Just 4 steps and it is configured:
In step 1, choose the template type you want to use (document or spreadsheet). If you haven’t created one already, Form Publisher can create one for you.

In step 2, Form Publisher checks if the markers in the template match the form fields.

In step 3, choose the folder you want the generated files to be saved into. If there is no existing folder, Form Publisher will create one for you. Then, you can choose how to name the generated files. Form Publisher helps you sort the files by adding by default an incremented number at the end of each file.

In step 4, configure the notification rules if needed. Recipients will get an automatic email notification upon each form submission with a link to the generated file, and permissions for editing, viewing or commenting the file. You can also have Form Publisher send a PDF file.

Form Publisher is designed to help you with your workflow:
It can be useful in schools and other public structures for registration forms or any kind of surveys and lets you manage confidentiality permissions. It can be used in a business environment to give a professional layout to documents before presentations, or to create contract agreements or a workflow combining Google Forms and invoice templates, like in our example.
The possibilities are endless!