Generate your first batch of PDFs
You have a template and a sheet with data. Here's how to push the button.
1. Open the sidebar
In your sheet: Extensions → Sheet to PDF → Open sidebar.
The sidebar reads your sheet's headers + row count automatically. If you don't see your columns appear, your row 1 might be empty or missing — see setting up sheet headers.
2. Pick your template
Click Template doc. A Drive picker opens — find your Google Doc template. You'll see its name displayed in the field once selected.
3. (Paid plans only) Pick a destination folder
Click Save PDFs to. Pick or create a Drive folder for your output. PDFs go here and a "PDF link" column gets auto-added to your sheet pointing to each file.
On the Free plan, you don't pick a folder — PDFs download directly to your computer instead.
4. (Optional) Customize filenames
By default, files are named {{firstHeader}}_{{rowNumber}}.pdf (e.g., Acme_2.pdf). Click Customize filename to change the pattern. Click any column chip below to insert it.
Examples:
Invoice_{{Client}}_{{Date}}→Invoice_Acme_2026-05-30.pdfCert_{{Recipient}}→Cert_Sarah_Chen.pdf
5. Click Generate
The button shows how many PDFs will be created based on your data: "Generate 247 PDFs". Click it. A spinner appears.
Each PDF takes 2–5 seconds to generate. For 247 rows, expect ~10 minutes. For 10 rows, ~30 seconds.
6. Check the results
When complete, the sidebar shows a list of each PDF:
- Free: each row has a download link. Click to save to your computer.
- Paid: each row shows the filename + Drive URL. Click Open destination folder to see all of them.
Hit a quota wall? You'll see a popup. Upgrade your plan or earn more free PDFs.