Mail merge, right inside Google Sheets.
Turn a spreadsheet into a personalized email campaign — sent from your own Gmail, with per-recipient merge fields, a live preview, and open & click analytics. No exports, no separate tool.
Your sheet is the mailing list
Each row is a recipient; each column is a merge field. Reference any column in your subject or body and Emerge fills it in per person.
-
Simple fields
Drop
{{First name}},{{Company}}, or any column into the subject and body. Every recipient gets their own values. -
Lists & tables
Repeat a column across rows to render a bulleted list, or use dotted headers (e.g.
Item.name,Item.qty) to build a per-recipient table automatically. -
Rich-text templates
Compose with a formatting toolbar — headings, links, bold, lists — or drop into raw HTML when you need it. Templates are saved with your sheet.
How it works
- Open the add-on from a Google Sheet that has your recipients — one row per person, a header row of column names, and an email-address column.
- Compose your template. Write the subject and body, insert merge fields from your columns, set the sender name and reply-to address, and save.
- Preview, then send. Step through a live, fully merged preview of any recipient. When it looks right, send — every message goes out through your own Gmail account, personalized per row.
Built for sending real campaigns
-
Sends from your Gmail
Messages are delivered through your own Gmail account, so your From address is a real, authenticated identity — not a relay. Set a sender name and reply-to, or send from a verified alias.
-
Live per-recipient preview
See exactly what each person will receive — fields, lists, and tables fully merged — before a single message goes out.
-
Queued, quota-aware sending
Large campaigns send in batches on a schedule so they stay within Gmail's daily limits and keep going even after you close the sheet.
-
Open & click analytics (optional)
Turn on tracking and Emerge sets up a Google Analytics property for you, then shows opens, clicks, and recent activity right in the dashboard.
-
Smart defaults
Your Google profile name pre-fills the sender field, sample data shows the merge syntax, and a setup checklist tells you exactly what's left before you can send.
-
Everything stays in your account
Templates and settings live with your spreadsheet; mail goes out through your mailbox. There's no external account to create and no data parked on our servers.
What this is not
- Not a bulk-spam tool. You mail people who belong in your own sheet, from your own mailbox, subject to Gmail's sending limits.
- Not a shared relay. Every message is sent through your authenticated Gmail account.
- Not a contact-scraping or list-buying service. You bring the recipients.
About this add-on
Emerge: Mail Merge is a Google Workspace add-on that runs inside Google Sheets. It reads the recipients and template from your spreadsheet, renders a personalized message for each row, and sends it through your own Gmail. When you enable analytics, it provisions and reads a Google Analytics property on your behalf so you can measure opens and clicks.
See the Privacy Policy — including a scope-by-scope explanation of every permission — and the Terms of Service for the full details.
Ready to send your first campaign?
Install the add-on and merge straight from your Google Sheet.
Install from Google Workspace