Mail merge that makes documents, not emails
Generate personalized Google Docs, Slides, and PDFs from a Sheets data source (letters, certificates, invoices) without leaving the editor and without sending a single email.
Works in Docs, Slides & Sheets · Your files stay in your Drive
From spreadsheet to finished documents in three steps
Prepare your Sheet
One row per recipient or record, one column per field: names, dates, amounts, anything.
Tag your template
Write a normal Google Doc or Slides deck and drop in variable tags where the data should go.
Preview, then generate
Check a resolved preview first, then generate one document per row, optionally converted to PDF.
Most mail merge add-ons send bulk email. This one doesn’t.
Popular mail merge tools are built around blasting Gmail campaigns. If what you actually need is the documents (files you can print, archive, attach, or share), an email tool leaves you halfway. Here, the generated Docs, Slides, and PDFs are the product.
Built for documents
- One personalized Google Doc or Slides deck per spreadsheet row
- Optional PDF conversion of every generated file
- Outputs are saved to your Drive. Only AI-powered variables send data to AI, and only when you use them.
- Works with the template you already have; no proprietary format
Control before you commit
- Preview generation: inspect a resolved example before the full run
- Saved workflows you can rerun next week or next semester
- Built-in examples to start from
- Smart Variables: dates, fixed text and images, dropdown choices, AI report paragraphs
Made for recurring document runs
Certificates & report cards
Generate a personalized certificate or report per student from your grade sheet, ready to print or hand out.
Invoices & quotations
Turn a billing sheet into individual invoice PDFs with client names, line references, and dates filled in.
Letters & notices
Produce personalized letters, contracts, or notices at scale while every output stays an editable Google file.
Slides templates work too: generate personalized decks, or follow the step-by-step Docs tutorial.
Frequently asked questions
Does this mail merge send emails?
No, and that is the point. It generates documents: one personalized Google Doc, Slides deck, or PDF per spreadsheet row. You keep the files in Drive and decide how to share, print, or send them.
Do I need to install anything besides the add-on?
No. Mail Merge & Variables runs in the sidebar of Google Docs, Slides, and Sheets. Your template stays a normal Google file and the generated output lands in your Drive.
Can I check the output before generating all files?
Yes. The workflow supports preview generation, so you can inspect a resolved example before running the full merge, and save the workflow to reuse it later.
What are Smart Variables?
Values that do not come from a spreadsheet column: fixed text or images, the current or a calculated date, dropdown choices, yes/no clauses, and AI-generated report paragraphs based on selected sheet columns.
Is it free?
The add-on installs free with no credit card. Mail merge is part of the free plan; AI-powered variables and some premium tools draw on the free plan’s monthly allowances, and Pro removes those limits.
Get the Add-On - Free
Text To Table Converter
Install once, then run Mail Merge & Variables from the sidebar in Docs, Slides, and Sheets. Free plan included.