How to Mail Merge Google Docs™ from Google Sheets™
Create personalised Google Docs from spreadsheet rows, preview one result first, then generate a complete batch and export it to PDF.
Travis
Published
A Google Docs mail merge starts with one template and one Google Sheet: each column is a field, each row is a record, and the result is one personalised document per row. Always preview one document before generating a whole batch.
This pattern is useful for invoices, quotations, certificates, report cards, letters, and any document you would otherwise duplicate and edit repeatedly.
Prepare the Sheet and Template
Put a clear field name in every header cell and keep one record per row. In your Google Docs template, add placeholders that correspond to those fields. Use a real sample row before running a full batch.
Run Mail Merge in Google Docs
- Open the template in Google Docs.
- Choose Extensions > Text To Table Converter > Document Tools > Mail Merge & Variables....
- Choose the Google Sheets data source and analyse the template tags.
- Check the field mappings.
- Select Create single document to inspect one finished result.
- When that preview is correct, select Create all documents.
The preview lets you verify values, formatting, line items, and page breaks before a batch creates many files.
Convert the Batch to PDF
Use Convert all to PDF when the result needs to be sent, archived, or printed. Keep the editable Docs copies when someone may need to revise a record later.
Proven Starting Examples
- Bulk Generate PDF Sales Invoices
- Bulk Generate PDF Sales Quotations
- Bulk Generate PDF Student Report Cards
- Bulk Generate PDF Training Certificates
Get the Add-On
免費取得外掛程式
Text To Table Converter
Create personalised documents from a Google Sheet: Install Text To Table Converter to map template fields, preview one result, generate a batch, and convert it to PDF.
Related Reading
- Mail Merge & Variables - Full setup and mapping guide.