Mail merge from Google Sheets,
for documents that get sent.
Generate personalized PDFs, Word docs, and Excel files from your Google Sheets. Think certificates, invoices, contracts, and reports. Email them straight to recipients when you're done, or download the batch as a zip.
- Connects to Google Sheets in two clicks
- PDF, Word, or Excel output from one template
- Email each document or download the batch
Google Sheets add-on
Works right inside Google Sheets
Install it once and MailMergic appears in the Extensions menu of every spreadsheet. Check your rows, run your saved template and get your documents without leaving the sheet.
Install from the Marketplace
One click on the Google Workspace Marketplace. Free, with any Google account.
Open it in your spreadsheet
Choose Extensions, then MailMergic. The sidebar flags bad email addresses and empty cells.
Run your mail merge
Choose a template and get one document per row, all in one ZIP.
Free on the Google Workspace Marketplace. Works only with the spreadsheet it is open in.
Three steps
From a Google Sheet to a folder of personalized documents
Connect your Google Sheet
Authorize MailMergic to read your Sheet. Works with Sheets you own and Sheets shared with you. Pick which tab and which rows to merge.
Upload your template & map columns
Drop in your PDF, Word, or Excel template with placeholders like {{name}} or {{course}}. MailMergic auto-matches Sheet columns to placeholders; drag to fix anything off.
Generate and deliver
One click. One document per row, named automatically. Download as a zip, or email each document to its recipient with a personalized subject and body.
Connect a Sheet and try it.
Try for freeWhat people generate from Google Sheets
Three workflows that fit Google Sheets data perfectly
Bring your own Sheet and your own template. MailMergic does the merge and (optionally) the delivery.
Certificates from Google Sheets
Generate course completion, training, or event attendance certificates personalized for each attendee. Pull names, dates, and credit hours from your Sheet. Get a folder of branded PDF certificates, or email each one directly to its recipient with a personalized note.
- Course completion, attendance, CME, CEU certificates
- Branded PDF output preserves layout, fonts, and signature blocks
- Email each certificate to its recipient with a personalized subject and body
Invoices and statements from Google Sheets
Generate monthly client invoices, recurring billing statements, or project receipts straight from your finance Sheet. Email each PDF to the right client with a cover note, or download the full batch for your records.
- Per-client invoices, statements, and receipts
- Word, PDF, or Excel output from the same template
- Automatic per-row file naming (e.g. invoice-{{client}}-{{month}}.pdf)
Contracts and agreements from Google Sheets
Generate NDAs, engagement letters, service agreements, or vendor contracts at scale. Pull party names, dates, scope, and terms from your deal-pipeline Sheet. Send for signature via email or download for review.
- NDAs, engagement letters, service agreements, vendor contracts
- Word output stays editable; PDF output is print-ready
- Optional email delivery, or download for legal review first
Try it yourself, no signup required.
Try for freeMail merge tools for Google Sheets
Document-first, not email-first
Google Sheets users have many mail merge tools. Most are built for sending mass personalized emails like newsletters, outreach campaigns, and follow-ups. MailMergic takes the opposite approach: we focus on generating polished documents, then delivering them by email or download. If your output is the email itself, use YAMM or GMass. If your output is a document that needs to look professional, use MailMergic.
Primary output
YAMM, GMass, MailmeteorEmail body, personalized
MailMergicBranded, polished document (PDF, Word, Excel)
Attachments
YAMM, GMass, MailmeteorPlain or limited
MailMergicFull template merge: layout, images, formulas, tables
Email delivery
YAMM, GMass, MailmeteorGmail only, within Gmail's daily sending limits
MailMergicSend from any of these:GmailGoogle WorkspaceMailMergic addressSMTP / OutlookYour domain
Use it for
YAMM, GMass, MailmeteorNewsletters, outreach, mass emails
MailMergicCertificates, invoices, contracts, reports
Sheet as data source
YAMM, GMass, MailmeteorYes
MailMergicYes
Add-on permissions
YAMM, GMass, MailmeteorGmail sending plus spreadsheet access
MailMergicThe spreadsheet it is open in, plus a connection to MailMergic. No Gmail or Drive access
How MailMergic handles your Google Sheets data
Your Sheet stays your Sheet
Your rows are used to make and deliver your documents.
Only the sheets you pick
Google's file picker with the drive.file permission: MailMergic opens the spreadsheets you choose, never the rest of your Drive.
EU-hosted, GDPR-compliant
MailMergic is hosted in the EU and GDPR-compliant by default.
No AI training, no ads
Your rows are never used to train AI models or for advertising.
Deleted after 30 days
Generated documents and email reports are deleted automatically after 30 days. Choose anything from 5 minutes to 180 days, or delete them yourself at any time.
Try it yourself, no signup required.
Try for freeTemplate gallery
Templates for Google Sheets users
Bring your own template, or start from one of these: certificates, receipts, badges, contracts, tickets and more. Pick one and MailMergic generates one personalized document per row of your Sheet.
