Simple Mail Merge

Documentation: from a list in Google Sheets to a personal email in every inbox, sent from your own Gmail.

← Back to product page

Last updated

How it works

Simple Mail Merge is a Google Sheets add-on. You write one email, put {{merge fields}} where the details change, and it sends a separate email to every row in your sheet through your own Gmail.

Each email goes to one person. It shows your name and address, and it lands in your Sent folder like any email you’d send by hand. Every row then gets a result in a Merge status column, so you can see who got the email and safely run it again later.

Everything lives in the Extensions → Simple Mail Merge menu:

  • Open Mail Merge: pick the sheet, write the email, test it and send it.
  • Check Quota: how many emails you’ve sent today and when the count resets.
  • Settings: your sender name, a “Send mail as” alias and your license.
  • Contact Us / Help: opens the help page.

Set up your sheet

Put one person per row and give every column a header in row 1. The headers become your merge fields.

Email First name Company
[email protected] Priya Northwind
[email protected] Daniel Acme Co
  • You need an email column. A column called Email, E-mail or Email address is picked automatically. Any other name works too; you choose it in the dialog.
  • Header names are flexible. {{First name}}, {{first name}} and {{ First Name }} all match the same column.
  • Keep headers unique. If two columns share a name, the first one is used and you’ll see a warning.
  • Leave the Merge status column alone. The add-on adds it the first time you send. Don’t type in it unless you mean to change what gets sent next time (see The Merge status column).

Want to send to just part of the list? Filter the sheet. Hidden rows are skipped.

Send your first mail merge

  1. Open the add-on. In your sheet, go to Extensions → Simple Mail Merge → Open Mail Merge. Approve the permissions the first time.
  2. Pick the recipient sheet and the email column. The top of the dialog also shows how many emails you can still send today.
  3. Write the email. Click Compose email. Type the subject and body, and use Insert field to drop in a column. The preview on the right shows the email filled in with the first row; change the Preview row number to check others. Click Save & back.
  4. Send a test. Click Send test email. It uses the first row’s values and only goes to you, with [TEST] at the start of the subject. CC and BCC are left off, and tests don’t count toward your daily quota.
  5. Send. The button says how many emails will go out, for example Send 48 emails. Click it. A progress bar shows how many are sent, and you can close the window: sending carries on in the background.

The dialog checks everything before you can send. If a merge field doesn’t match any column, the subject is empty, or there are no rows left to send, it tells you what to fix.

See Merge fields, links and images for everything you can put in a merge field.

Schedule a send

Click Schedule, pick a date and time, and click Confirm. The time is in the spreadsheet’s time zone, which is shown next to the picker.

Scheduled sends run on Google’s servers. Your computer can be off and the sheet closed.

Sender name and From alias

Open Extensions → Simple Mail Merge → Settings.

  • Sender name is the name people see next to your address.
  • Send from alias is optional. It must already be a verified “Send mail as” address in your Gmail settings. If it isn’t, Gmail sends from your main address instead, so send yourself a test after you set it.

CC, BCC and Reply-To

In the Open Mail Merge dialog, click CC, BCC & Reply-To…. Separate addresses with commas.

Merge fields work here too. Put {{Manager}} in CC and each email copies the address in that row’s Manager column. Follow-ups use the same CC and BCC as the original email.

What the add-on can access

Simple Mail Merge asks Google for as little as it can:

It can It can’t
Send email from your Gmail Read, search or delete your email
Edit the spreadsheet it’s opened in See your other spreadsheets or Drive files

The send-only permission is the reason a few features other mail merge tools have aren’t here, such as importing a Gmail draft or noticing replies. Reading your inbox would need far broader access.

Plans

Free Paid
Emails per day 50 No Makeinfo limit. Gmail’s own daily limit still applies
Merge fields, test sends, scheduling, status column ✓ ✓
Follow-ups (up to 3) ✓

After you buy, open Settings, enter your License key and Purchase email, and save. More on the numbers in Daily limits and quota.

Troubleshooting

“Unknown merge fields”

A {{field}} in your email doesn’t match any column header. Check the spelling against row 1. Capital letters and extra spaces don’t matter, but other characters do.

“No rows to send”

Every row already has something in the Merge status column, is hidden by a filter, or has no email address. Add new rows, or clear the status of the rows you want to send again.

“X recipients, Y left today”

On the free plan, a send that’s bigger than what you have left today doesn’t start. Filter the sheet down to Y rows, or wait for the reset at midnight UTC.

Some rows say ERROR

The reason is written in the cell. Fix it, clear the cell, and send again. Only the cleared rows go out. The Merge status guide lists the common errors.

The progress bar says “Paused: Gmail daily sending limit reached”

Gmail stopped accepting emails from your account for today. The add-on tries again 24 hours later and carries on from where it stopped, so you don’t need to do anything. The progress bar shows when it resumes.

Still stuck?

Email [email protected] with what you clicked and what the message said. A screenshot helps.

Get it first

Simple Mail Merge is in Google Workspace Marketplace review. Leave your email and we send the install link the day it goes live.

Request early access →