Skip to content
Mail Merge & Variables

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

How it works

From spreadsheet to finished documents in three steps

Step 1

Prepare your Sheet

One row per recipient or record, one column per field — names, dates, amounts, anything.

Step 2

Tag your template

Write a normal Google Doc or Slides deck and drop in variable tags where the data should go.

Step 3

Preview, then generate

Check a resolved preview first, then generate one document per row — optionally converted to PDF.

Documents first

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 saved to your Drive — nothing leaves your account
  • 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
Use cases

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.

FAQ

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.

Text To Table Converter

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.

Install free