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

  1. 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.
  2. Open Extensions > PickMerge > Open PickMerge on the tab with your rows.
  3. Click Pick a template Doc and choose your Doc in Google's file picker.
  4. Choose PDF files as the output. Pick Google Docs and PDFs if you also want an editable copy.
  5. 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.
  6. Choose folder for the PDFs, or leave it and PickMerge creates one.
  7. 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.
  8. 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

  1. Tick Email each document to an address in the row.
  2. 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.
  3. Leave Attach the PDF ticked.
  4. 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 wantSet
Rows marked for sendingOnly rows where Send? equals Yes
Rows without a PDF yetLeave Regenerate rows already marked Done unticked
A test on a few rowsRow numbers (optional): 2-4
Rows with an email addressOnly 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


More Google guides