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
- Open the form and click the Responses tab.
- Click Individual and use the arrows to find the response you want.
- 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
- In the responses spreadsheet, open Extensions > Audeza Doc Merge > Open and click New merge job.
- Pick the "Form Responses 1" tab, your template, and a Drive folder for the PDFs.
- Set the file name, for example
Confirmation - <<Full name>>. Without tags, every file would have the same name. - Check the tag list. Green tags match a column. A red one means its text doesn't match any header.
- 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
- The date prints with the time. The Timestamp column holds both. Format the column in the sheet (Format > Number > Date) and the PDF shows the date only, because values come out the way the sheet displays them.
- Checkbox answers come out as one line. A checkbox question with several ticks lands in one cell, separated by commas, and prints that way.
- File upload answers print as links. The sheet stores a Drive link for each uploaded file. Doc Merge doesn't place images from a column yet, so the PDF shows the link.
- A renamed question breaks its tag. If you change a question title after building the template, check the column header in the sheet and update the tag to match. The job editor flags tags with no matching column.
- Some responses shouldn't get a PDF. Under Only some rows, set a condition such as "Attending is Yes". Rows that don't match are skipped until they do.
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.