Google Sheets Integration

Generate PDFs from Google Sheets

Transform your Google Sheets data into professional PDFs with our powerful add-on. Generate invoices, reports, certificates, and more from your spreadsheet data.

How it works

Get started with Google Sheets to PDF generation in just a few simple steps.

1. Install Add-on

Install the SwishDocs add-on from the Google Workspace Marketplace. It integrates seamlessly with Google Sheets.

2. Configure API Key

Paste your SwishDocs API key into the add-on settings. Select your Google Docs template from your drive.

3. Generate PDFs

Generate PDFs per row or in bulk. Data from your spreadsheet automatically fills your template placeholders.

Powerful features

Bulk Generation

Generate hundreds of PDFs at once. Perfect for invoices, certificates, or any document that needs personalization at scale.

  • Process entire spreadsheet
  • Selected rows only
  • Progress tracking

Smart Mapping

Automatically maps your spreadsheet columns to template placeholders. Use column headers that match your template variables.

  • Auto-detect columns
  • Manual mapping options
  • Preview before generation

Quick setup guide

Step 1: Prepare your Google Docs template

Create a Google Docs template with placeholders that match your spreadsheet column headers:

Dear {{name}},

Your invoice amount is {{amount}}.
Due date: {{due_date}}

Step 2: Set up your spreadsheet

Make sure your Google Sheets has column headers that match your template placeholders:

nameamountdue_date
John Doe$1,250.002024-01-15
Jane Smith$2,100.002024-01-20

Step 3: Install and configure

  1. Install the SwishDocs add-on from Google Workspace Marketplace
  2. Open the add-on from Extensions → SwishDocs → Generate PDFs
  3. Paste your SwishDocs API key (get it from your dashboard)
  4. Select your Google Docs template
  5. Map columns to template variables (usually automatic)
  6. Choose to generate per row or in bulk
  7. Click "Generate PDFs" and watch the magic happen!

Ready to automate your Google Sheets workflow?

Start your 7-day free trial and transform your spreadsheet data into professional PDFs.

Start Free Trial