---
title: "Gmail mail merge: How to send personalized messages in Gmail"
description: "If you want to dynamically update templated messages to send personalized emails, Gmail mail merge will get the basic job done. Here's how it works."
image: "https://images.ctfassets.net/lzny33ho1g45/3ylbUcVuRlGVTZ085lwaqs/40806c2559b79644d4ea17c6a4e9451c/gmail-hero-neutral.png"
---

# Gmail mail merge: How to send personalized messages in Gmail

If you want to dynamically update templated messages to send personalized emails, Gmail mail merge will get the basic job done. Here's how it works.

If you want to send personalized marketing emails to a large audience, mail merge in Gmail...isn't the way to go. (Those types of sends are better handled by [email marketing](https://zapier.com/blog/best-drip-email-marketing-apps/) and [newsletter](https://zapier.com/blog/best-email-newsletter-software/) platforms.) 

But if you're running a small operation or want to send thank-you emails to everyone who donated to your walk-a-thon, Gmail's mail merge will do just fine. Here's how it works. 

**Table of contents**: 

- [What is mail merge in Gmail?](#what)
- [How to do a mail merge in Gmail](#how)
- [Gmail mail merge send tips](#tips)
- [Automate your Gmail inbox](#automate)

## What is mail merge in Gmail?

Mail merge in Gmail lets you batch send emails that are personalized for each recipient by dynamically updating four merge tag fields: 

- @first name
- @last name
- @full name
- @email

For example, if your email opens with "Dear @firstname," Gmail mail merge automatically updates `@firstname` with the recipient's first name.  

When you send your message, each recipient will get a unique copy of the email with all merge tags replaced with their specific details. 

**Note: **Mail merge in Gmail only works on paid accounts, so you can't use mail merge on your @gmail.com account.

## How to do a mail merge in Gmail 

There are two main ways to dynamically insert your recipients' data in a Gmail mail merge: 

- [Add recipients from Google Contacts](#google-contacts)
- [Add recipients from Google Sheets](#google-sheets)

### How to do a mail merge in Gmail using Google Contacts

Chances are, your recipients' details are already stored in [Google Contacts](https://zapier.com/blog/what-is-google-contacts/). (It's the terrifying magic of Google.) 

1. With Gmail open, click **Compose**.
2. In the _To_ field, click the **Use mail merge** icon.

3. Click the box next to _Mail Merge_. Your message box will turn a Google Forms-style purple color, an _Unsubscribe_ option will appear at the bottom of your message, and _Send_ will change to _Continue_.

4. Draft your templated message as you normally would, or insert an existing [email template](https://zapier.com/blog/gmail-email-templates/). When you want to insert a merge tag, type `@`, and then click to select one of the merge tags.

5. In the _To_ field, enter your recipient's name or email address. To add multiple recipients (as shown in the example below), first [create a group email in Gmail](https://zapier.com/blog/how-to-create-group-gmail/) and enter the group label in the _To_ field.

6. Optional but strongly recommended actions:
- **Preview your mail merge tags**: Hover over each merge tag, and select **Preview** to ensure your recipients' information is accurate. You'll also have the option to preview your message in its entirety at the end.

- **Set default values**: Hover over the merge tag, and select **Set default value** to enter a default value for Gmail to display if Google Contacts is missing that data. In the example below, if one of my recipients doesn't have a first name listed, Gmail mail merge will automatically update "Hey @firstname" to "Hey my buddy, my dude." To be clear, I'm not suggesting that this is a professional default value.
7. Click **Continue**.
8. The first time you use mail merge in Gmail, a popup will appear reminding you not to spam people. Click **Got it**. (You can click the box next to _Don't show again_ if you'll remember not to send unsolicited emails in the future.)

9. Another popup will appear with an option to send a test email to yourself. To do that—and I strongly recommend you do—click **Send preview**. Otherwise, click **Send all**.

That's it. Your recipients will receive individual copies of your templated email. 

### How to do a mail merge in Gmail using contacts in Google Sheets

If you store your contact information in [Google Sheets](https://zapier.com/blog/google-sheets-tutorial/), Gmail can pull that data and use it in a mail merge. But first, some spreadsheet housekeeping: 

- Add column headers—for example, "First name" and "Last name"—to make it easier for yourself later on when you tell Gmail which column you want it to pull data from for each merge tag.
- Your contact information has to be in the first tab of your spreadsheet and can contain only text.
- Email addresses that contain special characters are considered invalid. What counts as a special character? Your guess is as good as mine. Gmail doesn't specify. All I know is that Gmail _doesn't_ consider the plus sign (`+`)—as in jane.doe+2@acme.com—as a special character.

Once you've tidied up your spreadsheet, you're ready to do a Gmail mail merge. 

1. With Gmail open, click **Compose**.
2. In the _To_ field, click the **Use mail merge** icon.
3. Click the box next to _Mail Merge_, and then click **Add from spreadsheet**.

4. Choose the spreadsheet you want to link to, and click **Insert**.
5. In the popup that appears, select the columns from your linked spreadsheet that correspond to the recipient's email, first name, and last name.
6. Click **Finish**.

7. Draft your templated message as you normally would. Be sure to use the merge tags in the spots you want Gmail to dynamically update (type `@` and select the tag).
8. Hover over the merge tag, and select **Set default value** to enter a default value for Gmail to display if Google Contacts is missing that data. (This is optional but strongly recommended.)
9. Click **Continue**.
10. In the popup that appears reminding you not to spam people, click **Got it**.
11. Before you batch send your emails, click **Send preview** to send a test email to yourself.
12. If the test email looks good, click **Send all**.

## Gmail mail merge send tips 

Dynamically updating an email to make it feel personal is one thing, but sending it to a huge list is another. Tread lightly, and keep these tips in mind. 

- **Be mindful of storage limits**. There's a 1,500-person/day limit on your mail merge emails, but each of those is going to turn into a "sent" email in your inbox. If your email includes images, that's going to eat up your [Google storage limits](https://zapier.com/blog/manage-google-storage/) pretty quickly.
- **You can CC or BCC someone, but…don't.** If you CC or BCC someone, they'll get the email as many times as there are contacts on the list. So unless you want your business partner to get the same email 1,500 times, I'd suggest not using the CC or BCC field.

## Maybe don't use Gmail mail merge 

Honestly, I can think of only one good reason why you would use mail merge in Gmail: you like what you know, and what you know is Gmail. There's nothing wrong with that. 

But if you'll entertain me, here's what you're working against if you use the feature: 

- **Extremely limited personalization**. Gmail mail merge lets you dynamically update only the recipient's name and email address in the body of your message (no subject lines). So apart from being able to start your email with a personal touch—"Hey, Sam"—the rest will probably sound boilerplate.
- **Basic contact management**. If you're using Gmail mail merge for email marketing—and again, I'm not suggesting you should—the contact management is really basic. This means you can't easily [segment your audience](https://zapier.com/blog/email-segmentation/) or [A/B test](https://zapier.com/blog/ab-testing-email-marketing/) things like subject lines.
- **No email analytics**. Gmail mail merge doesn't offer any analytics, so you won't be able to tell how your emails are performing. (And you definitely won't know if Aunt Sue actually clicked your sponsor-me link to donate to that walk-a-thon.) You can't even see a full list of everyone who unsubscribed, though you will get notified if anyone clicks unsubscribe on your email—that person will no longer receive any mail merge messages you send from the same email address.

## Automate your Gmail inbox

If your heart's set on using Gmail for all your email needs, I can't stop you. But I can help you delegate some of your inbox-related tasks to the robots.

By [connecting Google Contacts with Zapier](https://zapier.com/apps/google-contacts/integrations), you can automatically pull in contact information from other places like form submissions—keeping your digital Rolodex up to date across apps. Learn more about [how to automate Google Contacts](https://zapier.com/blog/automate-google-contacts/), or get started with one of these ready-made templates. 

If you store your contact information in Google Sheets, you can do the same thing by using [Zapier's Google Sheets integration](https://zapier.com/apps/google-sheets/integrations). 

You can also [connect Gmail to Zapier](https://zapier.com/apps/gmail/integrations) to do things like [create a to-do list from your inbox](https://zapier.com/blog/create-trello-card-from-google-calendar-events/), [automatically save email attachments](https://zapier.com/blog/email-to-dropbox/), or even [use AI to automatically label your emails](https://zapier.com/blog/automatically-label-emails-with-chatgpt/). Learn more about [how to automate Gmail](https://zapier.com/blog/automate-gmail-with-zapier/), or get started with one of these pre-made templates.

And if you're using your inbox to manage all your work, you can build a [Zapier Agent](https://zapier.com/agents), no code required, to [automatically create drafts](https://zapier.com/agents/templates/automated-email-reply-drafts-agent-76a3e6), [organize emails by required action](https://zapier.com/agents/templates/organize-gmail-emails-by-required-action), or even [manage your entire inbox in one go](https://zapier.com/agents/templates/clare-vos-inbox-zero-agent-de4f2e).

**Related reading**:

- [Email marketing best practices](https://zapier.com/blog/email-marketing-best-practices/)
- [How to send newsletters in Gmail with customized layouts](https://zapier.com/blog/how-to-send-newsletter-in-gmail/)
- [How to create a newsletter in Outlook](https://zapier.com/blog/how-to-create-newsletter-outlook/)
- [How to grow your newsletter without paid ads](https://zapier.com/blog/how-to-grow-a-newsletter)

_This article was originally published in July 2024. The most recent update was in November 2025._