SheetMergySheetMergy
Back to Blog
AutomationHow To

Mail Merge in Google Docs: The Complete Guide 2026 (Free + Paid Tools)

OgtayOgtay

Google Docs is one of the best platforms for creating document templates — but it doesn't have a built-in mail merge feature. To generate multiple personalized documents from a Google Docs template, you need to connect it to a data source and use a merge tool.

This guide covers everything you need to know about mail merge in Google Docs: how it works, which tools to use, and a complete step-by-step walkthrough. If you've been using Autocrat and it keeps breaking — or you've outgrown basic mail merge — there's a better option covered below.

What Is a Google Docs Mail Merge?

A Google Docs mail merge takes a template document and replaces placeholder tags with real data from a spreadsheet — generating a unique document for each row.

Example: You have a Google Doc invoice template with {{Client Name}}, {{Invoice Number}}, and {{Amount Due}}. Your Google Sheet has 50 rows of client data. A mail merge generates 50 individual invoices, each with the correct client details — saved as PDFs in Google Drive.

Works for any document type:

  • Invoices and billing statements
  • Certificates and diplomas
  • Offer letters and employment contracts
  • Personalized reports
  • Event confirmations

Best Tools for Mail Merge in Google Docs — Quick Comparison

Before diving into the step-by-step, here's how the main options stack up. Most people start with Autocrat because it's free — but quickly hit its limits.

FeatureSheetMergyAutocratApps Script

Multi-tab data sources

✅

❌

Manual coding

Data joins across tabs

✅

❌

Manual coding

Advanced filtering

✅

Limited

Manual coding

Grouping and aggregates

✅

❌

Manual coding

Email delivery with PDF

✅

❌

Manual coding

Scheduled automation

✅

Limited

Manual coding

DOCX / Word template support

✅

❌

❌

Run history and logs

✅

❌

❌

Single document mode

✅

❌

Manual coding

Excel / CSV data source

✅

❌

Manual coding

Free plan

✅ 100 docs/month

✅ Fully free

✅ Fully free

Autocrat works for very basic one-tab use cases but breaks frequently, has no run history, and hasn't kept up with modern workflows. If you've outgrown it or it's stopped working reliably, SheetMergy (sheetmergy.com) handles everything Autocrat can't.

How to Do a Mail Merge from Google Sheets to Google Docs

Step 1 — Set Up Your Google Sheet

Create a spreadsheet with column headers in row 1 — these become your merge tags.

First NameLast NameCompanyInvoice #Amount

John

Smith

Acme Inc

INV-001

$1,200

Sara

Lee

Beta Corp

INV-002

$850

You can use multiple tabs from the same sheet in a single job. SheetMergy also lets you choose which row is the header in each tab — useful when your sheet has a summary row above the actual headers.

Step 2 — Create Your Google Docs Template

Open Google Docs and write your document. Use double curly braces for merge tags matching your column headers exactly:

INVOICE
Client: {{First Name}} {{Last Name}}
Company: {{Company}}
Invoice #: {{Invoice #}}
Amount Due: {{Amount}}

Tags are case-sensitive and must match your column headers exactly, including spaces.

Tool Option 1: SheetMergy (Recommended)

SheetMergy is the most capable tool for Google Sheets to Google Docs mail merge. It handles the full workflow — merge, generate, save to Drive, email to recipients — from one place. Free plan includes 100 documents per month, no credit card required.

How to Use SheetMergy

  • Sign in at sheetmergy.com with your Google account — or open the Google Workspace Add-on inside Google Sheets
  • Click New Job and select your Google Sheet as the data source
  • Select your Google Docs template — or upload a DOCX file if you're working in Word format
  • SheetMergy auto-detects all {{tags}} and maps them to your columns automatically
  • Set optional filters — for example, only rows where Status = "Approved"
  • Choose output mode: one document per row or single document mode for tables and reports
  • Choose output format: PDF or Google Doc
  • Set your output folder in Google Drive
  • Click Generate Now or set a scheduled run

https://youtu.be/zIFTa00D_44

Email Delivery

After generating, SheetMergy can automatically email each document to the recipient in that row:

  • To: any email column in your sheet
  • Subject: personalized with {{tags}}
  • Body: full HTML email support
  • CC / BCC: fixed or dynamic
  • Attachment: generated PDF attached automatically

Data Joins

If your document needs data from multiple tabs — for example, client details from one tab and order data from another — SheetMergy's data joins link them via a common key column. No VLOOKUP needed.

Grouping and Aggregates

Need one document per client listing all their orders? Use SheetMergy's grouping to group rows by a field value or by month. Inside the grouped document use:

  • {{_sum}} — total of a numeric column across the group
  • {{_count}} — number of rows in the group
  • {{_avg}} — average value

Scheduling

Set the job to run hourly, daily, weekly, or monthly. SheetMergy stores a full run history and logs so you can track every execution and rerun jobs anytime. This is the feature most Autocrat users miss most after switching — knowing exactly what ran, when, and what failed.

Tool Option 2: Autocrat Add-On (Free, Basic)

Autocrat is a free Google Sheets add-on for basic Google Docs mail merge. It works for simple one-tab use cases but has significant limitations that affect reliability in real workflows.

How to use it

  • In Google Sheets, go to Extensions → Add-ons → Get add-ons
  • Search "AutoCrat" and install
  • Go to Extensions → AutoCrat → Open
  • Click New Job and select your Google Docs template
  • Map template tags to sheet columns
  • Choose PDF or Google Doc output
  • Click Run

Autocrat is free and works for straightforward use cases. It lacks data joins, grouping, filtering logic, DOCX support, email delivery, and reliable scheduling. Jobs frequently break after Google Workspace updates with no clear error message. If you're hitting these issues, see our full Autocrat alternative guide at sheetmergy.com/vs/alternatives-autocrat.

Tool Option 3: Google Apps Script (Free, Technical)

Apps Script gives you full control but requires coding. There's no UI, no scheduling, no filtering, no grouping, and no run history. It's a reasonable option if you're a developer building a custom workflow — but for most business users it's significantly more work than using a dedicated tool.

Common Use Cases

Bulk Invoice Generation

Generate individual PDF invoices for every client in your sheet. SheetMergy saves each to Drive, names them automatically, and emails them to each client in the same job.

Certificates and Diplomas

One certificate template in Google Docs plus a sheet of names equals hundreds of personalized certificates generated in seconds. Output as PDF for a professional final format.

Offer Letters

HR teams fill in candidate name, role, salary, and start date from a sheet into a standard offer letter template — eliminating manual editing and copy-paste errors across every hire.

Consolidated Invoices

Group all orders for one client into a single invoice document, with a line-item table and a {{_sum}} total at the bottom. One document per client, not one per order.

Monthly Reports

Schedule SheetMergy to generate per-person performance reports from your Google Sheet every month, delivered automatically to each recipient's inbox.

Tips for Better Results

  • Match tags exactly. {{First Name}} in your template must match the column header First Name in your sheet — spaces, capitalization, and punctuation all matter.
  • Test on one row first. Run a single-row test before processing the full list to confirm output looks right.
  • Use PDF for final documents. Invoices, certificates, and contracts should be PDFs — they're non-editable and look professional.
  • Use Single Document Mode for tables. If your document contains a data table with one row per item, use Single Document Mode to combine all sheet rows into one document.
  • Use filters to skip rows. Instead of manually deleting rows before each run, set filter conditions so SheetMergy only processes the rows you need.

Frequently Asked Questions

Does Google Docs have a built-in mail merge feature?

No. Google Docs does not have native mail merge functionality. You need a third-party tool or add-on. SheetMergy is the most complete option — it handles merge, PDF generation, email delivery, and scheduling in one place.

What is the best free Google Docs mail merge tool?

Autocrat is fully free and works for simple use cases. SheetMergy has a free plan with 100 documents per month and no credit card required — and it supports features Autocrat doesn't, including email delivery, multi-tab data, grouping, and run history.

Can I use a Word or DOCX file as my template?

Yes — SheetMergy accepts both Google Docs templates and uploaded DOCX files. Autocrat only supports Google Docs templates.

Can I output merged documents as PDF?

Yes. SheetMergy and Autocrat both support PDF output. PDF is recommended for invoices, certificates, and contracts — it's non-editable and renders consistently across devices.

Can I merge data from multiple Google Sheets tabs?

Yes — SheetMergy supports multi-tab data sources and data joins using a common key column. Autocrat does not support this. Apps Script can handle it but requires custom coding.

Can I generate one document for multiple rows?

Yes — SheetMergy's grouping feature groups rows by a field and generates one document per group, with aggregated totals using {{_sum}}, {{_count}}, and {{_avg}}. Autocrat and Apps Script require significant custom workarounds for this.

How do I send merged documents by email automatically?

Enable email delivery in SheetMergy. It emails each generated document to the address in the corresponding row, with a custom subject line, HTML body, and PDF attachment. No third-party email tool required.

Is Autocrat still working in 2026?

Autocrat still works for basic use cases but has become increasingly unreliable following Google Workspace updates. Jobs break without clear error messages and there's no run history to debug failures. If you're experiencing issues, our Autocrat alternative guide at sheetmergy.com/vs/alternatives-autocrat covers the switch to SheetMergy step by step.

Can I mail merge from Excel to Google Docs?

Yes — SheetMergy supports Excel files as a data source alongside Google Sheets. Upload your XLSX file, map the columns to your Google Docs template tags, and generate documents the same way.

Start Your Google Docs Mail Merge Today

The easiest way to get started is SheetMergy's free plan at sheetmergy.com. Connect your Google Sheet, choose your Google Docs template, and generate your first batch of documents in under 5 minutes. No credit card required. 100 documents free every month.

Get Started Free → sheetmergy.com