Turn spreadsheet rows into polished PDFs, DOCX files, Google Docs, and Slides using simple {{tag}} templates. Automate merges, email delivery, and scheduling.
No complex setup. No code required. Design a template, connect your data, and let Batch Merge handle the rest.
Create a Google Doc and add {{tag}} placeholders wherever you want dynamic data — body text, headers, footers, and tables.
Open Batch Merge from the Extensions menu, select your source sheet and template. Tags are automatically matched to column headers.
Click Run Merge or set an automatic schedule. Documents appear in your Drive folder, and optionally get emailed to each recipient.
Write your template once with simple tags. Batch Merge replaces them with real data from every row in your sheet.
Powerful enough for enterprise workflows. Simple enough to start in minutes.
Use {{Column Header}} placeholders anywhere in your Google Doc — body, headers, footers, and table cells.
Export as PDF, Microsoft Word (DOCX), or native Google Doc. Choose the format that fits your workflow.
Automatically email each merged document to its recipient. Attach the file, share a Drive link, or both.
Set it and forget it. Run merges automatically on hourly, daily, weekly, or monthly schedules.
Mark rows as processed with a status column. Re-run safely — Batch Merge skips completed rows automatically.
Use tags in your file names like {{Name}} - Invoice to generate uniquely named documents for every row.
Receive summary emails after each merge with stats, file links, and error reports.
Every merge is logged with timestamp, file name, Drive URL, and status. A built-in audit trail.
Test before committing. Dry Run shows exactly how many rows will be processed without creating any files.
Access {{_ROW_NUM}}, {{_TIMESTAMP}}, and {{_SHEET_NAME}} automatically in any template.
Each sheet tab maintains its own template, output folder, schedule, and email settings.
Create personalized presentations from spreadsheet data using Google Slides templates with tag placeholders.
Whether you need one document or one thousand, Batch Merge handles your document generation workflow.
Generate onboarding packets, employment contracts, and personalized offer letters at scale.
Create and send invoices, proposals, and quotes directly from your spreadsheet data.
Produce certificates, report cards, and permission slips for every student in your roster.
Draft NDAs, service agreements, and compliance letters with consistent formatting.
Start free. Upgrade when you need more power.
See why teams choose Batch Merge over other Google Sheets document merge tools.
| Feature | Batch Merge | Document Studio | Autocrat |
|---|---|---|---|
| Google Docs templates | |||
| PDF output | |||
| DOCX output | |||
| Per-row email delivery | |||
| Scheduled merges | |||
| Status column tracking | |||
| Batch notifications | |||
| Dedicated merge log sheet | |||
| Per-sheet configurations | |||
| Dry run preview | |||
| Free tier | |||
| Modern, clean UI | |||
| Setup time | ~2 min |
Everything you need to know about Batch Merge. Can't find an answer? Contact us.
Batch Merge
{{tag}} placeholders, connect it to your sheet, and Batch Merge produces a unique document for every row — exported as PDF, DOCX, or Google Doc. It handles email delivery, scheduling, and status tracking automatically.{{tag}} placeholders anywhere — body text, headers, footers, and table cells. Tags are automatically detected and matched to your sheet's column headers.Free to install. No credit card required. No complex setup.
Coming Soon!