Mail MergeGoogle DocsSales InvoicePDFTemplates

Bulk Generate PDF Sales Invoices in Google Docs™

Learn how to use Mail Merge & Variables in Google Docs™ with the built-in Sales Invoice example, generate all invoice documents, and convert the full batch to PDF.

Maikki

Maikki

Need to create many invoices without editing the same Google Docs™ file again and again? Use Mail Merge & Variables to generate invoice documents from spreadsheet rows, then convert the finished batch to PDF.

The fastest way to learn the workflow is Load Sales Invoice Example in Google Docs™. It loads a ready-made invoice template and source sheet into the current mail merge session.

What You Need

  • A Google Docs™ file
  • The Text To Table Converter add-on
  • A few minutes to test the sample workflow

Note: Load Sales Invoice Example is available in Google Docs™. It loads a copied invoice template and a copied Google Sheets™ source into the current mail merge session.

How to Create an Invoice Batch

  1. Open any Google Docs™ file.
  2. Open Extensions > Text To Table Converter > Document Tools > Mail Merge & Variables....
  3. In the setup area, click Load Sales Invoice Example.
  4. Wait while the add-on loads the copied invoice template and copied spreadsheet.
  5. Click Analyze Tags.
  6. Review how the invoice placeholders map to the spreadsheet columns.
  7. Click Create single document to preview one invoice first.
  8. Open the preview and check the customer details, invoice number, line items, totals, and formatting.
  9. If the preview looks correct, click Create all documents.

Tip: You can also open the same tool from the sidebar under Document Tools → Merge → Mail Merge & Variables.

Screenshot placeholder: Mail Merge setup with the Load Sales Invoice Example button and the Analyze Tags action visible.

Convert the Full Invoice Batch to PDF

After Create all documents finishes, the results area switches from preview mode to batch results.

  1. Wait for the invoice batch to finish generating.
  2. In the completed results area, click Convert all to PDF.
  3. Let the add-on convert the generated invoice documents.
  4. Open the saved PDFs from Google Drive when the conversion finishes.

That button converts all generated documents to PDF and saves them to Google Drive. This is useful when you need invoice PDFs ready for email or record keeping.

Screenshot placeholder: Completed mail merge batch results with the Convert all to PDF button visible.

What You Can Do After the Batch Finishes

  • Use the left and right arrows to browse the generated invoice documents.
  • Open one generated invoice to review it again.
  • Delete a generated document if you need to rerun the batch.
  • Use Convert to PDF for one generated document, or Convert all to PDF for the full set.

Best Way to Replace the Example with Your Own Invoice Template

Start by keeping the sample invoice template and changing only the spreadsheet. That makes it easier to check whether your column headers map correctly.

After your source sheet works, replace the template with your own invoice layout. Always test with Create single document before running the full batch again.

Tip: Keep your source headers stable once the mappings are working. Changing header names later can break the detected matches.

Get the Add-On

Create invoice documents and convert the finished batch to PDF without building each invoice by hand.

Text To Table Converter

Get the Add-On - Free

Text To Table Converter

Use Mail Merge for Invoices in Google Docs™: Install Text To Table Converter to generate invoice documents from spreadsheet data and convert the result to PDF.

Install free

Related Guides

  • Mail Merge - Learn the full Mail Merge workflow, including source setup, mappings, Smart Variables, and saved workflows.
  • Save as PDF - See more ways to export Google Docs™ files as PDF with the add-on.