**Stop writing the same document 150 times.**

SmartMerge AI is an AI-powered mail merge and document automation tool for Google Sheets™. It takes your spreadsheet data, merges it with a Google Doc™ template, and uses Gemini™ 2.0 Flash to generate unique, personalized content for every row. Teachers use it as a report card generator. Consultants use it for client proposals. HR teams use it for offer letters. If you're looking for a modern Autocrat alternative with AI, pre-flight validation, and PDF export — this is it. The 5-step wizard takes under 5 minutes from install to first merge.

The only tool with SmartPrompt — AI that reads your template and writes the prompt for you. Zero prompt engineering. Zero setup. A built-in AI usage tracker shows exactly how many personalized documents you've used each month — no surprise costs.


The Problem

If you've used document merge tools before, these might sound familiar:

"Why did my merge job just stop working?" — Legacy tools fail silently, leaving you scrambling to figure out what went wrong and which rows were affected.

"I spent 4 hours manually fixing broken tags" — Dated interfaces with manual tag-to-column mapping waste time you don't have. One mismatched tag, one empty field, and your entire batch produces garbage.

"IT blocked it because it wants full access to my entire Drive" — Overly broad OAuth permissions create security concerns that get add-ons blocked at the organizational level. Some merge tools request access to all your Docs, Sheets, Drive, and Contacts.

SmartMerge AI was built from the ground up to solve all three problems: pre-flight tag matching and empty field detection catch errors before they happen, smart mapping eliminates manual tag work, and the narrow drive.file scope means we never access more of your Drive than the files you select.


How It Works — A Guided 5-Step Wizard

SmartMerge AI walks you through every merge with a clean, step-by-step wizard. First-time users complete their first merge in under 5 minutes.

Step 1 — Pick a Template
Choose any Google Doc™ as your template using the built-in Google Picker™. SmartMerge handles the complete Google Sheets™ to Google Docs™ merge pipeline — use tags like {{First Name}} or {{Company}} in your template to mark where spreadsheet data should appear. Your templates stay in your Google Drive™ — SmartMerge only accesses the files you explicitly select.

Step 2 — Map Your Fields
SmartMerge's smart mapping engine automatically detects every tag in your template and matches it to the corresponding column in your spreadsheet. Smart suggestions in seconds — not hours of manual configuration.

Step 3 — Add AI Personalization (Optional)
Enable AI and SmartMerge uses your template structure to auto-generate an optimized prompt — a feature called SmartPrompt. Where other tools require 10-15 minutes of prompt setup, SmartMerge writes the prompt for you in 0 minutes. A real-time prompt quality analyzer scores it (0-100) and suggests improvements.

Preview AI-generated content for your first row before committing to the full batch. See exactly what the AI will produce — and approve it — before a single document is created.

AI personalization is entirely optional. Standard merges send no data to any AI service.

Step 4 — Pre-Flight Validation (SmartCheck)
Before a single document is created, SmartCheck validates your entire setup:
- Template accessibility — is the file still reachable?
- Tag matching — does every {{tag}} in your template map to a valid column?
- Empty field detection — does every row have the data it needs, or are critical fields blank?

Errors are flagged with specific row numbers and clear explanations. No more discovering a typo on row 87 after you've already merged 150 documents.

Step 5 — Merge and Export
Hit merge and watch your documents appear with real-time progress tracking. Each row processes independently — one bad row never takes down the entire batch:
- Google Docs™ output with all your data and AI content merged in
- PDF export for ready-to-share documents (Pro plan and above)
- PDF password protection for sensitive documents (Premium+)
- Automatic batch organization — merges of 50+ documents sorted into subfolders
- ZIP download for large batches
- Retry failed rows without re-running the entire merge


Key Features

SmartPrompt — Zero-Setup AI
SmartMerge reads your template, identifies each section, infers the intent behind it, and writes an optimized AI prompt automatically. You spend zero minutes on prompt engineering. Other tools with AI require custom syntax or manual prompts. SmartMerge just works.

Row-Level AI Preview Before You Commit
Preview AI-generated content for your first row before committing to the full batch. See exactly what your recipients will receive. Approve or adjust before any documents are created — the human-in-the-loop checkpoint that gives you full control over AI output.

SmartCheck Pre-Flight Validation
Comprehensive checks catch every issue before your merge starts. Template accessibility, column mapping completeness, and data integrity are validated row by row. Specific error messages tied to specific rows — not vague warnings after the fact.

Template-Aware Multi-Section AI
SmartMerge detects the sections in your template (Summary, Recommendations, Comments, Performance Review) and generates contextually appropriate content for each section independently — using the data from each row. Not one blob of AI text, but structured, section-specific writing.

Smart Column Mapping
Template tags are automatically matched to your spreadsheet columns. SmartMerge detects {{tags}} in your Google Doc™ and maps them to the right headers. No manual configuration needed for standard setups.

Batch Processing and Auto-Organization
SmartMerge is a bulk document creator for Google Sheets™ — generate hundreds of personalized files from a single spreadsheet in one operation. Large batches (50+ documents) are automatically organized into subfolders. Download everything as a ZIP file. Processing 150 documents takes under 5 minutes.

PDF Export and Password Protection
Generate PDFs directly from merged documents. Protect exported PDFs with a password before sharing — recipients need the password to open each file. Available on Pro (PDF) and Premium (password) plans.

Real-Time Progress Tracking
Watch your merge happen row by row with a live progress bar and visual estimator. See which rows succeed, which fail, and why — as it happens. No silent failures.

Estimated Time Savings
Each AI-personalized document saves 8-12 minutes of manual writing. With 100 documents per month, that's 15+ hours back. SmartMerge shows your total time savings after each merge.


Use Cases — Who Uses SmartMerge AI?

Educators and School Administrators
Create personalized student progress reports, parent communication letters, certificates, and recommendation letters. A teacher with 30 students and 12 data columns (grades, conduct, strengths, growth areas) generates 30 unique, data-driven report cards in under 10 minutes. Each comment references the student's actual performance. AI writes personalized narrative feedback that reads like the teacher wrote it individually. Because SmartMerge uses the narrow drive.file scope and requires no access to Gmail or student email, it passes the permission review that blocks most add-ons at the IT approval stage.

Small Businesses and Consultants
Generate personalized proposals, client reports, invoices, and outreach documents at scale. A marketing agency producing 20 client proposals per month saves 4+ hours by merging client data with a branded template. AI tailors the executive summary, recommendations, and pricing justification to each client's industry and budget.

HR and People Operations
Produce offer letters, onboarding packets, performance review summaries, and compliance documents from employee data. Merge 50 offer letters with role-specific compensation details, benefits summaries, and start dates — each one accurate to the row.

Nonprofits and Community Organizations
Create personalized donor acknowledgment letters, volunteer recognition certificates, grant reports, and fundraising appeals. Personalization at scale helps build stronger relationships with supporters. A nonprofit sending 200 year-end donor letters saves an entire day of manual writing.

Real Estate Professionals
Generate property summaries, client-specific market reports, and listing presentations from spreadsheet data. Merge property details, comparable sales, and neighborhood stats into polished client-ready documents.

Legal and Compliance Teams
Produce client engagement letters, case summaries, and compliance reports from structured data. Each document is populated with case-specific details while maintaining consistent formatting and required language.

Healthcare Administration
Create patient communication letters, appointment summaries, and administrative correspondence. Merge patient data with approved templates while maintaining HIPAA-conscious data handling — AI is optional and no data is stored.

Certificates and Awards
Generate personalized certificates, diplomas, awards, and recognition letters for any occasion — academic honors, employee milestones, volunteer service, training completion. Merge recipient names, achievements, and dates from a spreadsheet into a designed template.


Frequently Asked Questions

Q: Can SmartMerge AI generate personalized report cards from Google Sheets™?
A: Yes. SmartMerge is widely used as a report card generator. Connect your grades spreadsheet to a Google Doc™ template with section headers, and AI generates unique narrative comments for each student based on their individual performance data. A class of 30 students takes under 10 minutes.

Q: Do I need to know prompt engineering to use the AI features?
A: No. SmartPrompt reads your template structure and auto-generates an optimized prompt. You can customize it or use it as-is. A real-time quality analyzer scores the prompt 0-100 and suggests improvements. Zero prompt engineering required.

Q: Can I use SmartMerge without AI — as a standard mail merge tool?
A: Yes. AI personalization is entirely optional. The Free plan ($0/month) includes smart column mapping, pre-flight validation, and the full 5-step wizard for standard data-to-document merges. No data is sent to any AI service unless you explicitly enable it.

Q: Does SmartMerge support PDF export and password protection?
A: PDF export is available on Trial, Pro ($8.99/month), Premium, and Team plans. PDF password protection is available on Premium ($19.99/month) and Team plans. Recipients need the password you set to open each PDF.

Q: How does SmartMerge handle large batches of documents?
A: SmartMerge processes hundreds of documents in a single operation. Batches of 50+ are automatically organized into subfolders. 150 documents with AI personalization complete in under 5 minutes. Failed rows can be retried individually without re-running the entire batch.

Q: How is SmartMerge AI different from Autocrat?
A: Autocrat is a free document merge tool with no AI, no pre-flight validation, and no real-time progress tracking. SmartMerge adds AI-powered content generation via SmartPrompt, pre-flight tag validation that catches errors before a single document is created, row-level progress reporting, PDF export, and a modern 5-step wizard. SmartMerge also uses the narrow drive.file scope rather than requesting broad Drive access.

Q: Is SmartMerge AI suitable for schools and districts with strict IT policies?
A: Yes. SmartMerge uses the restricted drive.file scope — it can only access files you explicitly select. It cannot read your email, browse your Drive, or access other users' files. Schools and districts approve SmartMerge where they block tools requesting broader permissions. Works in Google Workspace™ for Education and Chromebook environments.


Switching From Another Merge Tool?

Coming from a legacy merge tool with no AI?
SmartMerge AI gives you everything you're used to — Google Sheets™-to-Google Docs™ merge, batch processing — plus AI personalization, PDF export (Pro+), PDF password protection (Premium+), pre-flight validation that catches errors before they happen, and a modern wizard interface. No more silent failures.

Coming from a tool that charges $4+ per AI credit?
SmartMerge AI lets you personalize up to 30 documents with AI for $3.99/month. That's the full Starter plan — not a per-credit surcharge.

Coming from Autocrat or another free merge tool with no pricing page?
SmartMerge AI is transparent about what every plan includes and costs. A 7-day free trial gives you full access — including AI, PDF export, and batch processing — before you commit. No surprise charges, no feature gates you discover mid-merge.

Coming from a $49/month document automation platform?
SmartMerge AI delivers AI-powered document generation starting at $3.99/month. Purpose-built for spreadsheet-to-document merge without the complexity of a full workflow platform — and built AI-first, not a legacy tool with AI bolted on.


Security and Privacy

Narrow OAuth Scope (drive.file)
SmartMerge uses the restricted drive.file scope, which means it can only access Google Drive™ files you explicitly select through the file picker. It cannot browse, read, or modify any other files in your Google Drive™. Most competing merge tools request broad access to all your Docs, Sheets, Drive, and even Contacts — SmartMerge does not. This makes SmartMerge suitable for schools, districts, and organizations with strict IT policies.

AI Data Handling
AI personalization uses Google's Gemini™ 2.0 Flash model. Your spreadsheet data is sent to the Gemini™ API only during active merge operations when AI is enabled. No data is permanently stored by the add-on beyond your active session settings. AI personalization is entirely optional — standard merges send no data to any AI service. SmartMerge does not build user profiles or share data with third parties — practices aligned with FERPA requirements for school vendors.

Per-Spreadsheet Isolation
Merge settings are stored per-spreadsheet — opening SmartMerge in a different spreadsheet starts a clean configuration.

Privacy Policy: https://getsmartmerge.com/privacy
Terms of Service: https://getsmartmerge.com/terms


Pricing

Start with a free 7-day trial — full access to every feature, including up to 30 AI-personalized documents. No credit card required.

Free — $0/month
Basic mail merge without AI. Smart mapping, pre-flight validation, and the full 5-step wizard included.

Starter — $3.99/month ($39.99/year)
Personalize up to 30 documents with AI each month. Google Docs™ output.

Pro — $8.99/month ($89.99/year)
Personalize up to 100 documents with AI each month. PDF export + full batch processing.

Premium — $19.99/month ($199.99/year)
Personalize up to 300 documents with AI each month. PDF password protection included.

Team — $49.99/month ($499.99/year)
Personalize up to 1,000 documents with AI each month.

Annual billing saves 17% on every plan.


Getting Started

1. Install SmartMerge AI from the Google Workspace™ Marketplace
2. Open any Google Sheets™ spreadsheet with your data
3. Go to Extensions > SmartMerge AI > Open
4. Follow the 5-step wizard to create your first merge

New to mail merge? SmartMerge includes sample data generators — install the add-on, create a sample spreadsheet and template with one click, and run your first merge in under two minutes.

Questions? https://getsmartmerge.com/support

Google Sheets™, Google Docs™, Google Drive™, Google Workspace™, Google Picker™, and Gemini™ are trademarks of Google LLC.