How to create a PDF for each row in Google Sheets
By Jake Marsh · Updated
To create a PDF for each row in Google Sheets, make a Google Docs template with placeholders like {{Name}}, then open Extensions > PickMerge > Open PickMerge in the sheet, click Pick a template Doc, choose PDF files as the output and set a file name such as {{Name}} receipt. Click Check and preview, then Generate. Each row becomes one PDF in your chosen Drive folder, with its link in a new column.
Before you start
- A tab with column headers in row 1 and one record per row.
- A Google Doc laid out the way the PDF should look. Placeholders must match a header, in double braces.
{{Amount Due}}matches a column called "Amount Due". - Google Sheets' File > Download > PDF saves the whole sheet as one PDF. It can't make a separate PDF per row from a document layout, which is the part PickMerge does.
Steps
- Build the template. Write the document once, with your logo, tables and footer. Put placeholders where each value goes. If you're starting from nothing, open PickMerge and click Make one from my columns.
- Open Extensions > PickMerge > Open PickMerge on the tab with your rows.
- Click Pick a template Doc and choose your Doc in Google's file picker.
- Choose PDF files as the output. Pick Google Docs and PDFs if you also want an editable copy.
- Set the File name with placeholders, for example
{{Invoice #}} {{Client}}. Names must be different per row, or the files will be hard to tell apart in Drive. - Choose folder for the PDFs, or leave it and PickMerge creates one.
- Click Check and preview. Fix anything it flags. "Not matching any column" means a placeholder is spelled differently from the header; the preview suggests the likely match.
- Click Generate. A progress bar runs through the rows. Links appear in the PickMerge PDF column and the result in PickMerge Status.
Emailing each PDF to the person in the row
- Tick Email each document to an address in the row.
- Under Send to the address in column, pick the email column. Add a CC (optional), a Subject and a Message; placeholders work in all of them.
- Leave Attach the PDF ticked.
- Click Check and preview, read the recipients, and tick the box that says Send N emails from my account to: ... before Generate is enabled.
Emails go out from your Google account, so they appear in your Sent folder and follow your account's daily sending limit.
Only some rows
| You want | Set |
|---|---|
| Rows marked for sending | Only rows where Send? equals Yes |
| Rows without a PDF yet | Leave Regenerate rows already marked Done unticked |
| A test on a few rows | Row numbers (optional): 2-4 |
| Rows with an email address | Only rows where Email is not empty |
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
Can the PDF names come from my columns?
Yes. The File name field takes placeholders, such as {{Last name}}, {{First name}} contract. Names can be up to 200 characters.
Do formatting and images in the template survive?
Yes. PickMerge copies your Doc and replaces the placeholders in place, so fonts, colors, tables, headers, footers, images and document tabs stay as you made them.
What if a row fails?
Its PickMerge Status cell says why in plain words, such as a template that can't be found. The other rows keep going. Fix the problem and press Generate again; finished rows are skipped.
Where do the PDFs go?
Into the Drive folder you chose, or a folder PickMerge creates. Each row's PDF link is written in the PickMerge PDF column next to it.
More PickMerge guides
- How to turn Google Form responses into PDFs automatically
- How to generate invoices from Google Sheets
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)