How to turn Google Form responses into PDFs automatically
By Jake Marsh · Updated
To turn Google Form responses into PDFs automatically, link the form to a Google Sheet, open Extensions > PickMerge > Open PickMerge on the responses tab, pick a Google Docs template with placeholders named after the form's questions, choose PDF files, and tick Automatic mode. Every new response then gets its own PDF within about a minute, and PickMerge can email it to the address in the response.
Before you start
- In Google Forms, open the Responses tab and click Link to Sheets, so answers land in a spreadsheet. Each question becomes a column header.
- A Google Doc template. The placeholders are the question titles: a question called "Full name" becomes
{{Full name}}. - Google Forms can show a summary of answers and lets you print responses, but it doesn't fill a document of your own design for each response.
Steps
- Open the linked spreadsheet and go to the form responses tab.
- Open Extensions > PickMerge > Open PickMerge. The sidebar reads the question headers from row 1 and lists them as placeholders you can click to copy.
- Click Pick a template Doc and choose your template, or click Make one from my columns to start from a Doc with every question in it.
- Choose PDF files and set a File name like
{{Full name}} {{Timestamp}}. - Click Check and preview to see the first files from the responses already in the sheet.
- Click Generate once to make PDFs for the responses you already have.
- Tick Automatic mode ("Generate a document for each new Google Form response on this tab"). The sidebar shows it's on. New responses get a document within about a minute, even when nobody has the sheet open.
To send each person their PDF, tick Email each document to an address in the row and choose the email question as the column. Confirm the recipients in the preview before you turn Automatic mode on.
Forms that work well
| Form | What the PDF is |
|---|---|
| Course or training sign-off | A completion certificate with the name and date |
| Order or request form | A receipt or order summary |
| Field inspection | A signed-off inspection report |
| Job application | A one-page applicant summary for the hiring team |
| Event registration | A confirmation with the session and time |
What it costs
PickMerge's free trial covers your first 50 documents or 14 days, whichever comes first, with no card needed. Previews never count. After that it's $8.99 a month or $99 a year per Google account for unlimited documents. Install it from the PickMerge page.
PickMerge: Docs & PDFs from Sheets and Forms
Docs and PDFs from Sheets rows and Form responses, without full Drive access $8.99 a month or $99 a year per Google account.
Questions
Does PickMerge need access to my Google Forms?
No. It works from the response sheet. Automatic mode uses a spreadsheet trigger that runs when a form response arrives, so PickMerge never asks for a Forms permission.
How do I stop the automatic PDFs?
Untick Automatic mode in the sidebar. It stops at once, and the documents already made stay in Drive.
Can I make PDFs only for some answers?
Yes. Set Only rows where to a condition, such as "Course equals First aid". Responses that don't match are left alone.
Will a response get two PDFs if I also press Generate?
No. Each row is claimed before it's merged and marked Done afterwards, so a manual run and the automatic one never both make the same document.
More PickMerge guides
More Google guides
- How to export more than 1,000 rows from Search Console (Queryledger)
- How to print 5160 address labels from Google Sheets (Labelyard)
- How to create barcodes in Google Sheets (Rowcode)
- How to make a Google Sheets spreadsheet accessible (Includewell)