Gmail Mail Merge

Gmail mail merge is the process of sending personalized emails to multiple recipients directly from your Gmail account using data from Google Sheets or other sources, combining the familiarity of Gmail with the power of mail merge automation.

Each recipient gets their own email, not a shared message with a long To or BCC line. Their name, company, or any other detail from your sheet is filled in, and the email is sent from your own address, so replies come back to your inbox.

Ready to send one? Mail merge for Gmail with BetterMerge works on free Gmail and Google Workspace accounts, with a free plan of 50 emails a day.

Does Gmail Have a Built-in Mail Merge?

Yes, on some paid Google Workspace editions (such as Business Standard, Business Plus, and Enterprise). Gmail’s native mail merge lets you add merge tags like @firstname and link a Google Sheet for custom fields. Each recipient gets a separate copy, and replies come back as separate conversations.

It has real limits:

• Merge tags work in the email body only, not in the subject line or link text.
• It cannot be scheduled, and there is no open or click tracking.
• Only one CC or BCC recipient, and it is not available on free @gmail.com accounts.
• Mail merge sends are capped at 1,500 recipients a day.

Gmail’s Built-in Mail Merge vs a Mail Merge Add-on

For free options side by side, see free mail merge plans compared. For other add-ons, see the comparison pages.

How Gmail Mail Merge Works

1. Put your recipients in a Google Sheet

Use one row per person. The column headers become your merge fields.

| Email | First Name | Company |
|-------|------------|---------|
| sarah@example.com | Sarah | Acme Corp |
| mike@example.com | Mike | Beta Ltd |

2. Write one email with merge tags

Subject: A quick idea for {{Company}}

Hi {{First Name}},

I noticed {{Company}} is growing its team this year...

3. Preview, test, and send

Check how each email looks with real rows filled in, send a test to yourself, then send or schedule the campaign. The add-on sends each email through your Gmail account one by one, so they appear in your Sent folder like normal messages.

For the full walkthrough with screenshots, follow the beginner tutorial.

Gmail Sending Limits

Google limits how many emails an account can send in a day, whichever tool you use:

• Free Gmail accounts: about 500 emails a day.
• Google Workspace accounts: about 2,000 emails a day.
• New accounts start lower and build up over time.

Mail merge tools also have their own plan limits. BetterMerge’s free plan sends up to 50 emails a day. See email quotas for how the limits work together.

Best Practices

• Send only to people who expect to hear from you. Purchased lists hurt your sender reputation and break the law in many countries.
• Use a clean sheet. Remove duplicates and fix empty cells so no one gets “Hi ,”.
• Personalize with purpose. A name plus one relevant detail beats five generic fields.
• Test first. Send a test email to yourself before every campaign.
• Include an unsubscribe link and honor opt-outs. BetterMerge adds the link and skips people who opted out in your future campaigns.
• Pace large lists. Spread big sends across days to stay within Gmail’s limits.

Common Mistakes

1. Mismatched merge tags: a tag in the template that does not match a column header exactly.
2. Empty cells: missing data that leaves awkward gaps in the email.
3. Hitting the daily limit: sending more than your Gmail account allows in one day.
4. Skipping the test send: formatting or links that only look wrong in a real inbox.

When an Add-on Is Worth It

Gmail’s built-in option is fine for a simple announcement on an eligible Workspace plan. Use an add-on when you need personalized subject lines, a free Gmail account, scheduling, tracking, attachments, or follow-ups based on who engaged.

See how mail merge for Gmail works in BetterMerge.