Automatically Create PDF Documents from Google Form Responses

Google Types are the most effective instrument for creating on-line polls, surveys, quizzes, and questionnaires. The shape submissions are mechanically saved in Google Spreadsheets, making it simpler so that you can analyse the submissions, and your kinds can obtain an infinite variety of responses.

When a consumer submits your Google Type, a row is added to the vacation spot Google Sheet with all of the solutions. The tutorial explains how one can save your Google Type responses in a custom-made PDF file in Google Drive and have it emailed mechanically to a number of recipients through Gmail.

For this instance, we’re constructing an occasion registration kind with Google Types. The attendees fill the shape, choose the session(s) they want to attend and an e-mail affirmation is distributed to them immediately. A PDF doc is connected and it incorporates the shape solutions and likewise a dynamic QR Code that may be scanned on the occasion venue.

Create PDFs with Google Types – DEMO

Earlier than we get into the implementation particulars, please strive the stay workflow so you might have a greater thought of what we’re constructing.

First, fill-in this Google Type and submit. Your kind response is saved on this Google Sheet and, inside a couple of seconds, you’ll obtain a customized e-mail with a PDF attachment. It incorporates a QR code and a singular registration ID that’s generated mechanically with the =QRCODE() formulation.

Internally, the workflow is utilizing this Google Doc to merge the Google Types information right into a PDF file. We picked PDF for this instance however you possibly can generate paperwork in any format together with Phrase paperwork, Excel Spreadsheets, PowerPoint Slides, ePub and extra.

The right way to Create PDF Paperwork with Google Type Responses

To get began, create a brand new Google Type and select a vacation spot Google Spreadsheet the place the responses would get saved.

Subsequent, create a template in both Google Docs, Google Slides or Google Sheets. In your template, the variable fields ought to be enclosed inside double curly braces and the sector title ought to precisely match the query title in your Google Type.

Google Forms Merge Document

For instance, in case your Google Type query is “Full Title”, the marker in your doc template can be and will probably be mechanically changed with the reply submitted by the shape submitter.

Set up Doc Studio

Subsequent, set up Doc Studio for Google Sheets and authorize the add-on. Now open the Google Spreadsheet that’s storing your Google Type responses, go to the Add-ons menu, select Doc Studio and open the sidebar to construct the workflow.

First, increase the Doc Merge part and select the doc template from Google Drive that you’ve created within the earlier step. Select a file title of the exported file – it may be a hard and fast title – like occasion.pdf – or a dynamic title like .pdf the place the file title is custom-made based mostly on file solutions.

Subsequent, increase the Mail Merge part in Doc Studio’s sidebar, activate the “Ship Emails” possibility and create an e-mail template utilizing the built-in WYSIWYG editor.

HTML Email Template - Google Forms

You possibly can customise the template by including variable placeholders, like , within the e-mail topic and message physique for personalised emails. Select the sector the place you asking for the submitter’s e-mail deal with to ship them an e-mail once they submit the shape. You possibly can add extra emails (comma-separated) within the “Electronic mail Particular Folks” to inform extra individuals when kinds are submitted.

If you want so as to add markers to the merged doc that aren’t current within the Google Type, you need to use the assistance of Google Sheets array formulation.

carbon.png

As an example, in case your Google Type query is Full Title, you possibly can add a brand new column within the Google Sheet for First Title and use the next formulation to mechanically get the primary title from Google Type submissions that can be utilized within the e-mail and doc template.

Additionally see: The right way to Ship Customized Emails with Gmail

Lastly, increase the “End and Merge” part and verify the choice Merge on Type Submit. Click on Save to show the workflow and submit a check entry in your Google Type.

merged-pdf-document.png

You must discover a personalised e-mail with the merged doc as a PDF attachment in your Gmail despatched objects. A replica of the PDF file is saved in your Google Drive that you need to use to mechanically print the Google Type response through Google Cloud Print.

If you’re caught, please watch the video tutorial (obtain) for a visible walkthrough.