MergeDoc › Google Sheets to PDF: one PDF per row
Google Sheets to PDF: one PDF per row
Google Sheets' "Download as PDF" prints the whole table into one file. When you need one well-designed PDF per row — invoices, payslips, report cards — use MergeDoc: data in Google Sheets, layout in a Google Docs template, one PDF per row.
Free for 50 files a month, no card needed. Pro $5/month or $39/year, unlimited.
How to do it in 4 steps
- Keep your data in Google Sheets as usual, one record per row.
- Design the PDF page in Google Docs with {{Column name}} tags.
- In MergeDoc, pick the sheet, the template and PDF output.
- Click Run: one PDF per row in your Drive folder, with the link next to each row.
Example
Spreadsheet
| Invoice # | Customer | Item | Amount |
|---|---|---|---|
| INV-001 | Bright Cafe | Logo design | $120 |
| INV-002 | North Studio | Website | $900 |
Google Docs template
Customer: {{Customer}}
Item: {{Item}}
Amount due: {{Amount}}
Result: INV-001 - Invoice.pdf · INV-002 - Invoice.pdf
FAQ
Can file names come from my columns?
Yes, e.g. {{Invoice #}} - Invoice. MergeDoc suggests a name when you pick the template.
Is there a row limit?
Free: 50 files a month. Pro: unlimited (Google daily limits still apply).
Will running again create duplicates?
No. Finished rows are marked and skipped; only new or failed rows are created.
Do I need to install anything?
No. MergeDoc runs in your browser: Chrome, Safari, Edge, Firefox.
Use MergeDoc for other documents
- Bulk certificate generator from Google Sheets
- Mail merge with Google Sheets and Google Docs
- Generate contracts in bulk from Google Sheets
Home · Help · Privacy · Terms · support@getmergedoc.com
Google Sheets, Google Docs and Google Drive are trademarks of Google LLC. MergeDoc is not affiliated with Google.