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#
Get the Add-On - Free
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.
Did this solve your problem?