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.

4.7 from 194 reviews · 54K+ installs

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

  1. 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.
  2. Compose your template. Write the subject and body, insert merge fields from your columns, set the sender name and reply-to address, and save.
  3. 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.

Reviews

Loved by 54K+ Google Workspace users

Rated 4.7 out of 5 on the Google Workspace Marketplace. Here's what users say.

4.7194 reviews on Google Workspace Marketplace →

Ready to send your first campaign?

Install the add-on and merge straight from your Google Sheet.

Install from Google Workspace