Sheet to PDF
Help · Get started · Install & set up

Install & set up your first sheet

5 min read Updated May 2026

This guide walks you from "I just heard about Sheet to PDF" to "I just generated my first batch of PDFs." Total time: about 5 minutes.

What you'll do

1. Install from the Marketplace

Click Install on the Google Workspace Marketplace listing. Choose the Google account you want to install for. Authorize the requested permissions — we use the least-privilege drive.file scope, so we can only see files you explicitly select.

💡 Tip: install it on your work account if you're going to use it for work, and on your personal account if it's for personal use. Each account has its own quota.

2. Prepare your Google Sheet

Open any Google Sheet. The first row must contain your column headers — these become the variable names you'll reference in your template.

For example, for invoices:

| Client    | Email           | Amount | Date       |
| Acme      | [email protected]     | 1250   | 2026-05-30 |
| Globex    | [email protected]   | 890    | 2026-05-30 |
| Initech   | [email protected] | 1500   | 2026-05-30 |

Each row below the header becomes one PDF.

⚠️ Heads up: header names are case-sensitive. Client won't match {{client}} in your template. Pick one convention and stick with it.

3. Prepare your Google Doc template

Create a new Google Doc. Write your content as you normally would, but wherever you want a value from the sheet to appear, use {{ColumnName}} — double curly braces around the exact header name.

Hi {{Client}},

Please find your invoice attached. Total due: {{Amount}}€ by {{Date}}.

Best,
Your team

That's it. The Doc can have any formatting — fonts, colors, images, tables, headers, footers. The placeholders are just plain text that gets replaced when each PDF is generated.

💡 Tip: skip this step if you want — pick a ready-made template from Templates in the sidebar. There are 3 free templates (Invoice EU, NDA, Certificate) plus more on paid plans.

4. Generate your first batch

In your Sheet, open Extensions → Sheet to PDF → Open sidebar.

  1. Click Template doc → pick your Doc
  2. (Paid plans) Click Save PDFs to → pick a Drive folder for the output
  3. Click Generate N PDFs

Wait a few seconds. Each row generates one PDF. On the Free plan, PDFs download directly to your computer with a "Made with Sheet to PDF" footer. On paid plans, they save to your chosen Drive folder, and a "PDF link" column is auto-added to your sheet.

What's next

You did it. Now explore: