Google Sheets to PDF — the complete guide
There are 5 ways to turn a Google Sheet into a PDF. Each has its place. Here's when to use which.
Method 1: Export the whole sheet as a single PDF
Use when: you want the sheet itself as a PDF (financial report, dashboard).
How: File → Download → PDF (.pdf). Configure orientation, margins, scaling.
Limits: produces one PDF for the whole sheet. Not personalized.
Method 2: Manual PDF per row (copy-paste)
Use when: you have 3-5 rows max and need them as separate personalized documents.
How: build a Google Doc template, manually copy each row's values in, export as PDF, repeat.
Limits: doesn't scale. 50 rows = 4 hours.
Method 3: Apps Script (DIY)
Use when: you're a developer and want full control.
How: write a Google Apps Script that loops over rows, copies a template Doc, replaces placeholders, exports as PDF.
Limits: ~2 days to build, more to maintain. Error handling, quota tracking, retries are all on you.
Method 4: Autocrat (oldest add-on)
Use when: you've already invested in Autocrat's workflow.
How: install Autocrat, configure a job, run it.
Limits: dated UX, <> placeholder syntax instead of {{}}, no smart logic, awkward bulk email setup. See Sheet to PDF vs Autocrat for a deeper comparison.
Method 5: Sheet to PDF (modern)
Use when: you want it to "just work" without coding or compromises.
How:
- Install Sheet to PDF (10 seconds)
- Build a Google Doc with
{{ColumnName}}placeholders, or pick a ready-made template - Sidebar → pick template + folder → Generate
What you get:
- Modern
{{Variable}}syntax (familiar to anyone who's used Handlebars, Liquid, Jinja) - Smart templates with if/else, filters, loops
- Bulk email delivery built-in
- Public share links for recipients without Google accounts
- 10 PDFs/month free, no credit card
Decision matrix
| Need | Best method |
|---|---|
| Sheet exported as a single PDF | File → Download → PDF |
| Less than 10 PDFs ever | Manual copy-paste (faster than learning a tool) |
| 10-300 PDFs/month, personalized | Sheet to PDF (Free or Starter) |
| 300-15,000 PDFs/month + email | Sheet to PDF (Pro or Pro+) |
| 15,000+ PDFs/month, scale | Sheet to PDF (Premium) or custom backend |
| Conditional content, loops | Sheet to PDF Smart templates (Starter+) |
| Full programmatic control | Custom Apps Script |