How do i create downloadable pdf in google forms

Many organizations nowadays are using Google Forms to create important request forms like leave request, purchase request, employee onboarding, and more… These forms can be filled entirely online and the form owner can easily track all responses via Google spreadsheet. Google Forms inherently includes a feature that allow you to print all responses at once.

To begin, open your Form, then switch from Questions to Responses section:. Responses section includes all the response data submitted to your Form. Here you can choose Destination to determine how and where the PDF file is generated, e. Other than that, there are also several optional choices you can setup, but they are not mandatory.

Similar to how you manually print all responses from Google Form to PDF, you also start by opening your wanted Form and switch from Questions to Responses section:. But instead of what we did previously, this time click on Individual part below:. The Individual part is where you can check each response, including all the answers. Afterwards, it will open the same Print window before but this time is to print individual response. Here you can simply follow the same steps from printing all responses method:.

Before we get into the implementation details, please try the live workflow so you have a better idea of what we are building. First, fill-in this Google Form and submit. To get started, create a new Google Form and choose a destination Google Spreadsheet where the responses would get saved. In your template, the variable fields should be enclosed inside double curly braces and the field name should exactly match the question title in your Google Form. Next, install Document Studio for Google Sheets and authorize the add-on.

Now open the Google Spreadsheet that is storing your Google Form responses, go to the Add-ons menu, choose Document Studio and open the sidebar to build the workflow. First, expand the Document Merge section and choose the document template from Google Drive that you have created in the previous step. Choose a file name of the exported file - it can be a fixed name - like event. For instance, if your Google Form question is Full Name, you can add a new column in the Google Sheet for First Name and use the following formula to automatically get the first name from Google Form submissions that can be used in the email and document template.

Click Save to turn the workflow and submit a test entry in your Google Form. You should find a personalized email with the merged document as a PDF attachment in your Gmail sent items.

If you are stuck, please watch the video tutorial download for a visual walkthrough. He holds an engineering degree in Computer Science I. Read more on Lifehacker and YourStory. We build bespoke solutions that use the capabilities and the features of Google Workspace for automating business processes and driving work productivity.

Share on:. Looking for something? Find here!