MailMergic (formerly PDF Mail Merger) turns every row of your Google Sheets™ spreadsheet into its own finished document. Pick a PDF, Word or Excel template, and MailMergic fills it once per row: certificates, address labels, name badges, donation receipts, invoices, letters, contracts and tax forms. Download the documents, or email each one to its recipient as a personal attachment, with delivery, bounce and open tracking.

WHAT PEOPLE MAKE WITH IT

* Certificates of completion, attendance and awards for students and course participants
* Address labels on Avery sheets such as 5160, many rows to a sheet, ready to print
* Name badges and event tickets
* Year-end donation receipts for every donor
* Invoices, letters, notices and contracts
* Tax and HR forms such as 1099, W-2 and 1095-C, filled from your contractor or employee list
* Google Forms™ responses: open the add-on on the form's responses sheet and every response becomes its own PDF

HOW IT WORKS

1. Open the add-on in Google Sheets™, check your data and choose the rows to merge
2. Pick a saved template, or upload a new PDF or Word template in MailMergic
3. Preview a row, then generate: one personalized document per row
4. Download the documents, or email each one to its recipient, and mark the rows as done in your sheet

IN GOOGLE SHEETS™

* Send your sheet to MailMergic in one click, no CSV download needed
* Run a saved template on all rows, the selected rows, or only the rows not done yet
* Preview any row as a finished document before you generate
* Check your data first: invalid emails, duplicates and blank cells, plus an optional AI check
* See results in your sheet: mark rows as done, or add each row's delivery status and a link to its document

IN MAILMERGIC

* Fill fillable PDF forms, or place text anywhere on a flat PDF that has no form fields
* Use Word, Excel and image templates too, or start from over 100 ready-made templates
* Get one file per row, or everything combined into one PDF
* Email each document with its own subject and message, from your own Gmail™ or a MailMergic address
* Track delivery, bounces and opens for every email
* Set custom file names and per-recipient PDF passwords, and add barcodes and QR codes

WHO USES IT

Schools and training providers, HR, payroll and accounting teams, nonprofits, event organizers, agencies and small businesses in more than 100 countries. MailMergic GmbH has made mail merge software since 2019.

PRICING AND PRIVACY

The add-on is free. MailMergic has a free plan (no credit card required) and paid plans for higher volumes at mailmergic.com/pricing. The add-on reads only the spreadsheet you have open, and writes to it only when you ask: data-issue notes, a status column, or result columns. Your sheet data is sent to MailMergic only when you click: choosing a template sends only the column headers, Preview selected row sends that one row, Generate documents and Upload a template send the rows you chose, and Deep check with AI sends a size-capped sample. Nothing is sent in the background. MailMergic is GDPR compliant and EU hosted. Files are encrypted, and you choose how long they are kept, from 5 minutes to 180 days.

Questions? support@mailmergic.com

Google Sheets™, Google Forms™ and Gmail™ are trademarks of Google LLC.