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.

Coming soon

Merge to letters

If you do not know how to merge to letters from Google Sheets using Mail Merge add-on, first 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 2: 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 3: Create mail merge template 

Click on the To Letters tab, and then either:

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 4: Select Google form responses

When a Google Form response is submitted, you have the following actions to select from:

Step 5: Select name and choose location

Select the name of your merged document/s and the location where the document/s are saved:

Click on Save to save the changes. 

Below shows an example of automatically created Google Docs and PDF files, after a Google form response is submitted.