Batch Merge is the fastest way to generate personalized documents from your Google Sheets™ data.
Use Google Docs™ or Google Slides™ templates with {{tag}} placeholders, and Batch Merge replaces them with data from each row — creating one document per row, automatically.
HOW IT WORKS
1. Open the sidebar from any Google Sheets™ spreadsheet
2. Select or create a template with {{tags}} like {{Name}}, {{Date}}, {{Amount}}
3. Choose your output format (PDF, DOCX, PPTX, Google Docs™, or Google Slides™)
4. Click Run Merge — done
FEATURES
• Google Docs™ and Google Slides™ template support
• Output as PDF, DOCX, PPTX, or keep as native Google format
• Dynamic file naming with {{tag}} patterns
• Per-row email delivery — email each document to a recipient column
• Batch notification emails with summary and file links
• Automatic scheduling — hourly, daily, weekly, or monthly merges
• Status column tracking to skip already-processed rows
• Merge Log sheet for full audit trail
• Built-in template library with starter templates for invoices, certificates, contracts, offer letters, NDAs, and reports
• Dry run mode to preview before creating files
• Per-sheet configuration — each tab stores its own settings
USE CASES
• Invoices and receipts from order data
• Certificates of completion for students or employees
• Personalized contracts and agreements
• Offer letters and HR documents
• NDAs and legal templates
• Reports and summaries from spreadsheet metrics
• Sales proposals and pitch decks from Google Slides™
PLANS
Free — 25 merges per month, Google Docs™ templates, PDF/DOCX export
Pro ($6.99/mo) — Unlimited merges, Google Slides™ support, email delivery, scheduling, batch notifications, all export formats. Includes a 14-day free trial.
SUPPORT
Visit https://batchmerge.com for documentation and support.