Watch this quick tutorial or follow the step-by-step instructions below to find out how to automatically generate a PDF email attachment, when a new Google Forms response is 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.
Below is an example of a Google Docs mail merge template.
From the On a Google Form Submit drop-down menu, select Send new file as a PDF Attachment to email.
Select a name for the PDF file attachment from the Merged Document Name drop-down menu. In this example, Email Address is selected as the name of the PDF file attachment.
Click on the To Emails tab, and then configure the email settings (read this article for more details).
Click on New, create the email body template using the merge fields, and then click on Save to save the changes.
Click on Save to save all the changes in both tabs (To Emails and To Letters).
Below is an example of an email generated with an attached PDF file, after a Google form is submitted.