Automatically Create Google Docs & PDF files
How to automatically create Google Docs and PDF files after Google form responses?
When new Google Forms responses are submitted, new Google Docs and PDF files can be automatically created. These files can be saved to a specific folder in your Google Drive or Shared drives.
Video tutorial
Watch this quick tutorial or follow the step-by-step instructions below to find out how to automatically generate Google Docs and PDF files, when new Google Forms responses are submitted.
Merge to letters
If you do not know how to merge to letters from Google Sheets using Mail Merge add-on, read this article .
Step 1: Create or use existing Google form
Create or use an existing Google form.
Step 2: Link Google form to Google Sheets
Link Google form responses to Google Sheets.
Step 3: Start Mail Merge add-on in Google Sheets
Start Mail Merge add-on in Google Sheets by clicking on Extensions > Mail Merge > Start to open the Mail Merge dialog box. A new column called Filter Rows to Merge is created automatically.
Step 4: Create mail merge template
Click on the To Letters tab, and then either:
Click on Select From Drive to select your saved Google Docs mail merge template.
Click on Create Sample to create a new Google Docs mail merge template.
The Google Docs mail merge template serves as the basis for your merged Google Docs and PDF files.
Below is an example of a Google Docs mail merge template.
Step 5: Select Google form responses
When a Google Form response is submitted, you have the following responses to select from:
Automatically Create a new Google Docs file.
Automatically Create a new Google Docs & PDF file.
Automatically Send new file as a PDF Attachment to email. This option is described in more detail in this article.
Step 6: Select name and choose location
Select the name of your merged document/s and the location where the document/s are saved:
Select the name of the merged document from the Merged Document Name drop-down menu (e.g., the name can be merged from a field or (Row Number) can be selected so that the row number is used as the name for your file).
Choose a location where the files are saved. The default location is My Drive. In My Drive, it is possible to select a specific folder within your Google Drive or Shared drives.
Step 7: Save changes
Click on Save to save the changes.
Below is an example of automatically generated Google Docs and PDF files, after a Google form response is submitted.
