Audeza Doc Merge

How to turn Google Form responses into PDFs

Google Forms™ can print responses, but it can't make a separate PDF for each response on its own. For one or two responses, printing is enough. For a PDF per person in your own layout, you need a template and something that fills it in. Here are all three ways, starting with the free built-in ones.

Save one response as a PDF

  1. Open the form and click the Responses tab.
  2. Click Individual and use the arrows to find the response you want.
  3. Click the printer icon. In the print dialog, set the destination to Save as PDF.

The PDF looks like the form: every question, with that person's answers filled in. You can't change the layout, add your logo or leave questions out. It's fine for a record. It's not something you'd send to the person as a confirmation.

Save all responses in one PDF

In the Responses tab, click the three-dot menu and choose Print all responses, then Save as PDF. You get one long file with every response, one after another. That works for an archive or a printed pile for a meeting. If each person needs their own file, you'd be splitting the PDF by hand.

Make a separate PDF for every response

For a confirmation, receipt or certificate per person, the usual setup is a template: a Google Docs™ file with placeholders where the answers go. Each new response fills in a copy, and the copy is saved as a PDF. You can write that yourself in Apps Script (there's a working script in our Sheets guide), or use an add-on. Here's the setup with Audeza Doc Merge, which runs in the form's responses spreadsheet.

1. Link the form to a spreadsheet

In the form, click Responses > Link to Sheets. Every question becomes a column, and the column header is the question title. If you want to email each PDF, turn on Settings > Responses > Collect email addresses too, so the address is a checked field.

2. Write the template

Make a Google Doc for letters and confirmations, or a Google Slides™ file for anything landscape, like a certificate or a badge. Type a tag wherever an answer should go, using the column header between double angle brackets: <<Full name>>, <<Which workshop?>>, <<Timestamp>>. Case and extra spaces don't matter. Everything else on the page stays as you designed it.

3. Create the merge job

  1. In the responses spreadsheet, open Extensions > Audeza Doc Merge > Open and click New merge job.
  2. Pick the "Form Responses 1" tab, your template, and a Drive folder for the PDFs.
  3. Set the file name, for example Confirmation - <<Full name>>. Without tags, every file would have the same name.
  4. Check the tag list. Green tags match a column. A red one means its text doesn't match any header.
  5. Click Test with first row, open the test PDF, then click Save.

4. What happens after that

Each new response becomes a PDF in your folder, usually within a minute of being submitted. Responses you already had don't wait: click Merge now in the sidebar and they're done in one go, with a progress bar. Every row gets a status, "Merged" with the time and a link to the file, so you can see which responses have a PDF.

Things that trip people up

Emailing the PDF to the person

Turn on Email each document in the job and send it to <<Email Address>>. The subject and message can use tags too, like Your registration, <<Full name>>. The PDF is attached, and the email goes out from your own Google account, so replies come to you. Google caps how many people an account can email a day: about 100 on a free Gmail™ account and 1,500 on Google Workspace. Past that, the remaining rows wait and go out after the limit resets.

Which way to pick

A handful of responses, nobody else needs to see them: print from the Individual tab. An archive of everything: Print all responses. A PDF per person, in your layout, without anyone clicking anything: a template and a merge. Doc Merge is free for 50 PDFs a month, and Pro is $49 a year for unlimited.

Making certificates? There's a step-by-step certificate guide.