Automatically Create PDF's from Google form Responses

Automatically Create PDF's from Google form Responses

This is a Step by Step tutorial on Automatically how to automatically create and mail pdf's to the users mail entered during filling of form

STEP 1:

1. Create a simple google form requesting Name, Email address and What so ever you need
2. Now go to responses and click on options and create a new Google sheet for storing responses
3. Then create a New Template using google docs and fill it with what ever message you wish to send in the PDF to the filler of google form
4. now go to google sheet you have created earlier to store responses
5. Go to Add-ons Section and search for add-on namely "Document Studio".
6. Add it to your google sheets by allowing the permissions
7. Now refresh the Google sheet page and refresh it.
8. Now go to add-on section and open Document studio add-on
9. Now you will be seeing a couple of Options.

STEP 2:

1. Select the first option namely "Document Merge".
2. Now select the "Google Document" and select the Template you have done using Google Docs
3. Then in the Merged File name use {{ the phrase you have used to collect the name}}.             For Eg: {{FULL NAME}} 

STEP 3:

1. Now select the Second Option in Document Studio namely "Mail Merge & Google Forms"
2. Turn on Send Emails Option and select Use a Visual Editor option
3. This will open a Email Template Designer.
4. In the send email box go to Drop down menu and select email address
5. In Senders Full Name Fill the that you want to be in the mail
6. Fill Email subject with whatever subject you need
7. Coming to email message body. This is the message going to be present in the body of the Email the Google Form filler will be receiving.
8. If you ant to add the Filler's name in the message then go to insert Merge Option and select the appropriate field. 
9. Then Click Save once you are done.

STEP 4:

1. Go to Google Drive and Create a folder to store all the PDF Files that are created.
2. Then Open "Upload to google drive " option in Document studio.
3. Select folder created as Parent folder.

STEP 5:

1. Go to finish and merge option in Document studio and select "Merge on Form Submit" option 
2. Now save the settings

STEP 6:

1. Open the Google Docs and  fill it with message you wish it to be in the PDF sent in mail
2. Use the {{FULL NAME}} to add the Fillers name into PDF.
3. Use  {{Timestamp}} to add the date and time of filling the form in the PDF

Reference:

Feel free to check the links below for proper understanding

Google Doc         Google Form