Mail Merge & Variables
Use Mail Merge & Variables when you want to turn spreadsheet rows into finished Google Docs™ or Google Slides™ files.
The feature is available in Google Docs™, Google Slides™, and Google Sheets™. You can choose a source spreadsheet, analyze template tags, preview one result before the full run, save reusable workflows, and add Smart Variables for reusable content that does not come directly from a source column.
What You Can Do
Section titled “What You Can Do”- Generate one document or presentation per spreadsheet row.
- Use the current Doc or Slides file as the template, or choose another template.
- Start from Sheets when your data already lives in the active spreadsheet.
- Preview one output with Create single document before you run Create all documents.
- Save, reload, and delete workflows for repeat jobs.
- Add calculated tags for derived values such as totals or balances.
- Add Smart Variables for fixed text, dates, dropdown choices, yes or no clauses, images, and AI-generated report text.
Where to Open It
Section titled “Where to Open It”- Sidebar: Document Tools -> Merge -> Mail Merge & Variables
- Extensions menu:
Extensions>Text To Table Converter>Document Tools>Mail Merge & Variables...
Host Behavior
Section titled “Host Behavior”- Docs: the current document is the default template.
- Slides: the current presentation is the default template.
- Sheets: the current spreadsheet is the default data source, and you choose a Docs or Slides template.
Explore This Feature
Section titled “Explore This Feature” Mail Merge Follow the full setup flow for choosing a source, analyzing tags, previewing output, and running a saved workflow.
Smart Variables Learn when to use Smart Variables, which variable types are available, and how apply and copy actions work.
Related Links
Section titled “Related Links” Merge Document Tabs Create a new Google Docs™ file from selected tabs in one source document.
Merge Documents Combine content from multiple Google Docs™ files into one new document.