How to Generate PDF files from Google Form Responses

Published in: Document Studio - PDF - Google Forms

With Document Studio, you can easily generate PDF files, or document of any other file type, when someone submits your Google Form. The generated documents are stored in Google Drive, you can email them to the form respondent, share the file with team members or even print the documents via Google Cloud Print.

This step by step tutorial explains how to generate a PDF file from Google Form submissions.

Step 1: Create the Google Form

Go to and create a Google Form. We’ll build a Contact Us form that asks for the respondent’s name, email, postal address and comments.


Go to the Response Tab, click the 3-dot vertical menu and select the response destination. The Google Form should be storing the responses in a Google Spreadsheet for the document merge add-on to work.


Step 3: Create the Document Template

Build a new template using either Google Docs, Spreadsheet or Google Slide. We’ll create a one-page slide presentation with template {{markers}} corresponding to the various questions in our Google Form.


Please ensure that the template markers in the document template are correctly mapped and that the marker name should be same as your form question. For instance, if you have a question in Google Forms that is titled “Your postal address?”, the marker name in the document template should read {{Your postal address?}}.

Step 4: Configure Document Studio

Open the Google Forms responses spreadsheet, go to the add-ons menu and choose Document Studio.

4a. Configure Document Template

Go to the Document Merge section and select the template you created in the previous step. You can also personalize the file name to include form answers.

4b. Configure Email Template

Open the Google Forms Merge section and design your email template. You can use can column header in the email subject and body using the {{marker}} notation. The merged document will be added to the email as an attachment. You can also choose the email field in the “Send Email” drop-down and the email will be sent to the form respondent.


Tip: If you would like to include all the form answers in the email, use the {{All Answers}} marker anywhere in the message body and it will be replaced with an HTML table containing all the form answers.

4c. Configure Google Drive

Your generated documents will be stored in Google Drive. Expand the “Upload to Google Drive” section and select the folder in Drive where the documents would be saved.  You can also customize the subfolder path with form answers so the form response files are stored in separate folders.


Step 5: Merge on Form Submit

The configuration is complete and we are ready to run the form submit trigger that will automatically merge documents and send the emails as soon as a new form is submitted.


Go to the Save Configuration section, check the “Merge on Form Submit” option and click the Save Settings button. Now submit a test form entry and it should create the documents and send the emails.

📮  Subscribe to our Email Newsletter for Google tips and tutorials!
Published in: Document Studio - PDF - Google Forms

Looking for something? Find here!

Meet the Author

Web Geek, Google Developer Expert
Amit Agarwal

Amit Agarwal is a Google Developer Expert in Google Workspace and Google Apps Script. He holds an engineering degree in Computer Science (I.I.T.) and is the first professional blogger in India. He is the developer of Mail Merge for Gmail and Document Studio. Read more on Lifehacker and YourStory

Get in touch

Google Add-ons

Do more with your Gmail and GSuite account

We build bespoke solutions that use the capabilities and the features of Google Workspace for automating business processes and driving work productivity.

  1. Mail Merge with Attachments
    Send personalized email to your Google Contact with a Google Sheet and Gmail
  2. Save Emails and Attachments
    Download email messages and file attachments from Gmail to your Google Drive
  3. Google Forms Email Notifications
    Send email notifications to multiple people when a new Google Form is submitted
  4. Document Studio
    Create beautiful pixel perfect documents merging data from Google Sheets and Google Forms
  5. Creator Studio for Google Slides
    Turn your Google Slides presentations into animated GIFs and videos for uploading to YouTube