1) Google Form will populate a spreadsheet with fields
2) Google Sheet will execute a script
3) Script will populate fields into a Google Doc template file and create a new file with these fields from the existing template
4) Populated Template File will be unique and be created in a designated Google Folder
You will not need to write the script. You will be using the script here:
Please review the .swf video provided to get a good idea of what is needed. Please place the word "Marco" at the beginning of your bid to ensure you have read all of the details and have watched the video. You can view the video at http://www.screencast.com/t/KEhjo97K2.