Generate PDFs from
Google Sheets & Excel

Turn your spreadsheet data into professional PDFs automatically. Create invoices, reports, and documents from Google Sheets or Excel.

Spreadsheet
Automation
TemplateFox
PDF

Three ways to connect

Choose the method that best fits your workflow and technical comfort level.

Make

Via Make.com

Native Google Sheets and Excel modules with visual workflow builder. Best for complex automations with multiple steps.

Make.com integration guide
Zapier

Via Zapier

Simple trigger-action workflows. Connect Google Sheets directly to TemplateFox with our native Zapier integration.

Zapier integration guide

Via REST API

Use Google Apps Script or Power Automate to call our API directly. Full control for custom integrations.

REST API documentation
Looks great
PDF template example - Packing Slip
1
2
3
4

Built for real-world documents

Everything you need to create professional business documents, from invoices to packing slips.

1

Headers & footers that just work

Define once, repeat on every page automatically. Perfect for logos, page numbers, and legal mentions.

2

Dynamic data binding

Inject any data into your templates. Names, addresses, prices, etc. — everything updates automatically.

3

Tables that grow with your data

Rows grow automatically with your data. 3 items or 300, the table adapts and spans multiple pages if needed.

4

Built-in QR codes & barcodes

Generated on the fly from your data. Supports Code128, EAN-13, QR codes and more — all scanner-ready.

Try it free

60 free PDFs/month

Easy to use

Documents that adapt to your data

Go beyond simple placeholders. Use expressions to format, calculate, and control your content.

1

Use system variables

Access page numbers, total pages, and current date and more automatically with {{sys.page_number}} and friends.

2

Customize every component

Fine-tune content, borders, colors, sizes, positions, and more. Each element has its own properties panel.

3

Built-in functions

Format dates, calculate totals, round numbers, and more. Use 100+ built-in functions or create your own.

Start building

No credit card required

Template editor with expressions
1
2
3
Cloud storage

Built-in S3 Integration

Save your generated PDFs directly to Amazon S3 or any S3-compatible storage (Cloudflare R2, MinIO, DigitalOcean Spaces). Store PDFs in your own infrastructure instead of temporary URLs.

Learn how to bring your own storage

When to use spreadsheets

Google Sheets and Excel are great for simple tabular data. Here's how to decide.

Recommended

Use Spreadsheets if you need:

  • Spreadsheet-based data management
  • Familiar interface for non-technical users
  • Simple tabular data structures
  • Google Workspace or Microsoft 365 users

Or consider:

Airtable
Airtable
  • Relational data with linked records
  • Built-in automation triggers
REST API
  • Direct backend integration
  • Custom application development

Coming soon: Direct PDF generation

We're working on adding direct PDF generation from Google Sheets to our Chrome extension, plus ready-to-use Google Apps Scripts. Request this feature to help us prioritize!

Frequently asked questions

How do I generate PDFs from Google Sheets?

There are three ways: (1) Use Make.com with the native Google Sheets module to watch for new rows or changes, then send data to TemplateFox. (2) Use Zapier with a Google Sheets trigger. (3) Use Google Apps Script to call our REST API directly from your spreadsheet.

How do I generate PDFs from Excel?

For Excel files in OneDrive or SharePoint, use Make.com or Zapier with their Microsoft Excel modules. For local Excel files, export your data as JSON and use our REST API. Power Automate can also connect Excel to our API via HTTP requests.

Do I need coding experience?

No! Make.com and Zapier provide visual, no-code interfaces. Just connect your Google Sheets or Excel, map columns to template variables, and you're done. For advanced use cases, Google Apps Script or Power Automate offer more flexibility with minimal coding.

Can I generate PDFs automatically when a new row is added?

Yes! Both Make.com and Zapier support triggers that fire when a new row is added to your spreadsheet. Set up your automation once, and every new row automatically generates a PDF with that row's data.

How do I map spreadsheet columns to my template?

In your template, use variables like {{column_name}}. When setting up your automation, map each column from your spreadsheet to the corresponding template variable. Column headers become your variable names.

Can I generate multiple PDFs from multiple rows?

Yes! Make.com supports iteration, allowing you to loop through multiple rows and generate a PDF for each. This is perfect for batch invoicing, bulk certificate generation, or creating reports for each customer in your spreadsheet.

What about line items in invoices?

For invoices with multiple line items, structure your data with one row per invoice (not per line item). Use a JSON column or multiple columns for line items, then use our template's repeating sections feature. Alternatively, use Airtable for more complex relational data.

Can I store generated PDFs back in Google Drive?

Absolutely! After TemplateFox generates your PDF, add a Google Drive action in Make or Zapier to upload the file. You can organize PDFs into folders, name them dynamically based on spreadsheet data, and even add the Drive link back to your spreadsheet.

How fast is PDF generation?

Most PDFs generate in under 2 seconds. Your automation continues immediately with the PDF URL, so you can chain additional actions like emailing the PDF or storing it in cloud storage without delays.

Automate your PDF generation

Complete documentation, no-code integrations, and a powerful API to help you generate PDFs at scale. Let us handle the boring stuff.