Automatically Create Google Docs & PDF files

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.

If you do not know how to merge to letters from Google Sheets using Mail Merge add-on, read this article .

Create or use an existing Google form.

Link Google form responses to 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.

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.

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.

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.

Click on Save to save the changes.