Mail Merge Guide
One Google Doc, Many Personalized Letters, PDFs and Emails
Google Docs has no native merge button. Here are the three routes that turn a single document into personalized output for every recipient.
1
Doc template
3
Merge routes
PDF
Letter or email out
Isabella Torresby Isabella Torres · Last updated: 2026-10-08

Google Docs Mail Merge: Personalized Letters, PDFs, and Emails from One Doc

Google Docs has no built-in mail merge, so you pair a Doc template with another tool. Three routes work: a Google Workspace Marketplace add-on for printed letters and labels, Google Sheets plus Gmail for bulk email, or a mail merge platform that turns one Doc into a personalized PDF for every recipient.

Which route you pick depends on the output you actually need. A school sending award certificates has a different job than a sales team firing off 300 personalized quotes, and neither looks like a nonprofit mailing year-end receipts. This guide walks all three so you can match the method to the task without trial and error.

New here? Start with our primer on Email Marketing Fundamentals for the fundamentals, then come back to this guide.

Quick context: Mailsoftly offers transparent pricing, free hands-on migration, and human support. 500 contacts and 2,000 emails per month, no credit card.
Start free with Mailsoftly →

Key Takeaways

  • Google Docs cannot merge a document on its own. You always add either a Marketplace add-on, a Sheets plus Gmail workflow, or a dedicated mail merge platform.
  • Use an add-on when the output is printed: letters, labels, and certificates that each become a separate Doc or PDF.
  • Use Sheets plus Gmail when the output is a plain email and your volume stays inside Gmail’s daily sending limits.
  • Use a mail merge platform when you want a personalized PDF attached to every email and deliverability that scales past a personal mailbox.

Can Google Docs do a mail merge natively?

No. Google Docs has no native mail merge feature. There is no menu item that reads a contact list and spits out one personalized copy per row. To merge a Doc you combine it with a second tool that supplies the data and does the substitution.

That is the one fact that trips up most people searching for a merge button. The Doc is only ever the template. The merge engine lives somewhere else: a Workspace add-on, an Apps Script tied to a Sheet, or an outside platform. Microsoft Word bundles merge into the app itself, which is why the habit carries over, but the Google stack splits the two jobs. Once you accept that the Doc is just the layout and the formatting, picking a route gets simple. The rest of this guide covers the three that are worth your time, starting with the one built for printed output.

Read enough? Try Mailsoftly free with 500 contacts and 2,000 emails per month, no credit card.Start free with Mailsoftly →

Option 1: How do you mail merge letters with a Google Docs add-on?

Install an add-on from the Google Workspace Marketplace, point it at a Sheet of recipients, and let it clone your Doc once per row with the fields filled in. This is the route for printed output: letters on headed paper, mailing labels, name badges, and certificates.

Named add-ons you can verify in the Marketplace today include Autocrat, Avery Label Merge, and Quicklution’s Mail Merge. The workflow is similar across all of them. You write the template in Docs using placeholder tags such as a name token or an address token, keep the matching columns in a linked Sheet, and run the add-on. Each row produces a merged Doc, and most tools can also save every copy as a separate PDF or drop them into a Drive folder. Pricing and quotas change often, so read the current numbers on each add-on’s own Marketplace or vendor page before you commit. If your data already lives in a spreadsheet, it is worth knowing the broader set of mail merge add-ons that use Google Sheets as the data source, since several overlap with the Docs route.

Add-on route in four steps
1
Write the Doc template with placeholder tags for each field.
2
Keep a linked Sheet with one column per tag and one row per recipient.
3
Run the add-on to generate one merged Doc or PDF per row.
4
Print the batch, or save every file to a Drive folder for records.

The strength here is fidelity. What you format in the Doc is what prints, down to margins and fonts. The limit is reach: add-ons produce files, not a reliable send at scale. If your real goal is to email each person, the next two routes handle that better.

Option 2: How do you email a merged Doc with Sheets and Gmail?

Move your copy into a Google Sheet, add a mail merge add-on or a short Apps Script, and send through your own Gmail mailbox. The Doc becomes the draft you paste in, and the Sheet drives personalization token by token. This suits a plain-text or lightly styled email to a modest list.

The catch is volume and format. Gmail enforces daily sending limits that differ between free consumer accounts and paid Workspace accounts, so always confirm the current cap in Google’s own support documentation before a large run. A merge of a few dozen rows is fine. A merge of thousands will hit the ceiling and may trip spam signals. There is also a design cost: a Google Doc is a print layout, not an email layout, and pasting it into Gmail rarely survives intact. For the full consumer-mailbox walkthrough, see how to run a mail merge in Gmail. If your list is already growing beyond a personal inbox, dedicated email marketing software removes the daily cap entirely and keeps your main address out of the sending reputation equation.

Option 3: How do you turn one Doc into a personalized PDF per recipient?

Use a mail merge platform that takes your document content, merges each contact’s fields, and sends an email with a personalized PDF attached to every recipient. This is the route when the document itself is the deliverable: an invoice, a quote, a certificate, a receipt, or a signed letter that each person needs as a file.

Mailsoftly is built for exactly this. You can run a mail merge from an uploaded list or an Excel file, set per-contact merge fields, and attach personalized PDFs so every email carries a document addressed to that single person. For sensitive files you can send secure document links instead of raw attachments. Sending happens from your own mailbox with Google Workspace or Microsoft 365 sign-in, and you can wire the whole flow into other systems through Zapier or the REST API. That lets you turn one document into a personalized PDF for every recipient without touching an add-on quota or a Gmail daily limit.

What the platform route gives you
Merge from an uploaded list or an Excel file, with per-contact merge fields.
A personalized PDF attached to each recipient, not one shared file.
Secure document links for files you do not want sent as open attachments.
Sending from your own Google Workspace or Microsoft 365 mailbox.
Automation through Zapier and a REST API for recurring merges.

On cost, Mailsoftly pricing is public (as of 2026-09-07). The Free plan covers 500 contacts and 2,000 emails per month with no credit card. Starter is $15 per month billed annually for 1,000 contacts and 10,000 emails, and Basic is $39 per month billed annually for 5,000 contacts and 40,000 emails. Higher tiers and a custom Enterprise plan scale from there. Full details sit on the Mailsoftly pricing page so you can match a plan to your list size before you start.

What breaks when a Doc becomes an email?

Plenty, and it is the single most common reason a merge looks wrong. A Google Doc is designed for paper, with page margins, exact fonts, and fixed widths. Email clients ignore most of that, so copying a Doc straight into a message rarely survives the trip.

The clean fix is to stop treating the Doc as the email body. Keep the Doc as the attached document when the file is the point, and write the email itself as a short, plain message in the sending tool. That keeps the formatted PDF pristine while the email stays readable in every inbox.

Which mail merge route fits which job?

Match the method to the output, not the other way around. Add-ons win for print, Sheets plus Gmail wins for small plain-email sends, and a platform wins when the document is the deliverable and volume is real. The table lays out the trade-offs.

RouteBest outputGood volumeMain limit
Docs add-onPrinted letters, labels, certificatesAny size for filesNot built to send at scale
Sheets plus GmailPlain personalized emailDozens per dayGmail daily sending limits
Mail merge platformEmail plus personalized PDF per personHundreds to thousandsNeeds a contact list set up first

Read the table top to bottom by your deliverable. If recipients need paper or a file in hand, start with the add-on. If they need a quick note and you have a short list, Sheets plus Gmail is enough. If each person needs their own document in their inbox and you plan to do this more than once, the platform route pays for itself fast.

For the broader picture on this topic, see our complete Email Marketing Fundamentals guide, which covers strategy, fundamentals, and advanced playbooks.

Google Docs Mail Merge: Personalized Letters, PDFs, and Emails from One Doc visual 1
Google Docs Mail Merge: Personalized Letters, PDFs, and Emails from One Doc visual 2

Frequently Asked Questions

Can Google Docs do a mail merge natively?

No. Google Docs has no built-in mail merge feature. You must add a tool: a Google Workspace Marketplace add-on, a Google Sheets plus Gmail workflow, or an outside mail merge platform. In every case the Doc is only the template, and the merge engine lives in the second tool.

How do I mail merge Google Docs to PDF?

Use a Marketplace add-on such as Autocrat to clone your Doc once per row of a linked Sheet and export each copy as a PDF to Drive, which is ideal for print and archives. If you also need to email each PDF to its recipient, a mail merge platform like Mailsoftly attaches a personalized PDF to every message in one send.

How do I email a merged Google Doc to each person?

For a small list, move the content into a Sheet, use a Gmail merge add-on or Apps Script, and send from your mailbox within Gmail’s daily limits. For larger or recurring sends, use a platform that merges from an uploaded list, sends from your own Workspace or Microsoft 365 mailbox, and attaches a personalized file to each recipient.

Should the template be a Doc or a Sheet?

Use a Doc when layout matters, meaning letters, certificates, and anything that becomes a printed page or PDF. Use a Sheet as the data source that feeds the merge, never as the template itself. The Doc holds the design and the Sheet holds the fields, and the merge tool joins the two.

Turn one document into a personalized PDF for everyoneStart free with Mailsoftly →
500 contacts, 2,000 emails per month. Free hands-on migration. No credit card.

Isabella Torres
Isabella Torres
Growth Marketing Specialist at Mailsoftly
Isabella is a Growth Marketing Specialist at Mailsoftly with expertise in list building, subscriber retention, and subject line optimization. She writes actionable guides for marketers who want measurable results from email.