Gmail Mail Merge: Complete Guide to Sending 1500 Newsletters Per Day

You have 500 contacts to reach out to. You open Gmail, type the first email, then the second, then the third... You give up after the tenth attempt.

Gmail mail merge solves this problem.

This native Google Workspace feature allows you to send up to 1500 personalized emails per day directly from your Gmail inbox. Each recipient receives a message that feels personally addressed to them — with their first name, last name, or other data — without seeing that others received the same email.

In this guide, you will learn how to set up Gmail mail merge, connect it to Google Sheets to automate your contact lists, and follow best practices to ensure your emails land in the inbox (not in spam).

---

What is Gmail Mail Merge (and why it’s not a classic group send)

For years, Gmail offered group sending: you put your contacts in BCC, wrote a message, and sent it. Recipients couldn’t see who else received it.

But it was limited. No personalization. No automatic unsubscribe link. No integration with your data.

Gmail mail merge changes the game.

It’s a direct evolution of group sending, but with three major differences:

1. Personalization via tags — you insert @first_name, @last_name, @email and each recipient sees their own version
2. Mandatory unsubscribe link — Gmail automatically adds an "Unsubscribe" button to comply with anti-spam rules
3. Google Sheets integration — you connect a spreadsheet directly instead of managing contacts manually

In practical terms: you write an email once, Gmail sends it 1500 times with personalization. No manual duplication.

---

Google Workspace versions that support mail merge

Gmail mail merge is not available on free Gmail. You need a premium version of Google Workspace:

• Workspace Individual (€6/month)
• Business Standard (€14/month)
• Business Plus (€18/month)
• Enterprise Standard (€22/month)
• Enterprise Plus (€28/month)
• Education Standard (free for schools)
• Education Plus (free for schools)

If you use a personal Gmail address (@gmail.com), you cannot access this feature. You need a professional domain (@yourcompany.com).

---

Initial Setup of Gmail Mail Merge: Step by Step

Step 1: Open Email Composition

Log in to Gmail with your Google Workspace account. Click on "New message" or "Compose" (the button is usually at the top left).

The composition window opens.

Step 2: Find the "Use Mail Merge" Button

Look under the "To:" field — you will see a line with several options. One of them is called "Use Mail Merge".

Click on it.

You will know it’s activated because a purple banner appears at the bottom of the composition window.

Important: this feature works best on Google Chrome. If you are using Firefox or Safari, it may not display. Switch temporarily to Chrome if you encounter this issue.

Step 3: Add a Contact Source

Once mail merge is activated, you have two options to add your contacts:

1. "Add from Google Contacts" — you select a contact label you’ve already created
2. "Add from a spreadsheet" — you connect a Google Sheets

For this demonstration, we will use Google Sheets (it’s more flexible and what most users do).

---

Create and Organize Your Contacts in Google Contacts

Before connecting a spreadsheet, you need to understand how Google Contacts works with mail merge.

Create a Contact Manually (for Testing)

Go to contacts.google.com.

Click on "Create contact" at the top left.

Fill in: - First Name: "François" - Last Name: "Dufour" - Email: "[email protected]"

Click on "Save".

You have created your first contact. When you use mail merge with this contact, the tags @first_name and @last_name will work correctly.

Create Labels to Organize Your Contacts

Labels are categories. Click on "Create label" on the left and name it (for example, "Prospects 2025", "Restaurants Nice", "Clients").

When you import your contacts in bulk, you will assign them to a label. This will allow you to quickly find them and create targeted campaigns.

---

Import Your Contacts in Bulk with a CSV File

Creating 500 contacts manually? No, thank you.

You will import a CSV file.

CSV File Format

Your CSV file must contain at least these columns:

Email,First Name,Last Name
[email protected],François,Dufour
[email protected],Marie,Bernard
[email protected],Jean,Thomas

Important: - The first line must be a header (Email, First Name, Last Name) - Emails must be valid - No extra spaces before/after the data - No unescaped special characters

Remove Duplicates Before Import

Before importing, remove duplicate emails. If you send to the same email twice, Gmail will detect it and it may affect your sender reputation.

If you use Excel or Google Sheets: - Select the "Email" column - Go to Data > Remove duplicates - Confirm

Import into Google Contacts

Go to contacts.google.com.

Click on "Import" at the top left.

Select your CSV file.

Choose the label to import the contacts into (or create a new one).

Click on "Import".

Google Contacts will process your file. If you have 500 contacts, it will take a few seconds.

Check after import: click on your label and make sure all contacts are there with the correct data.

---

Use Google Sheets for Advanced Personalization

Google Contacts works well, but Google Sheets offers more flexibility.

With Sheets, you can: - Add additional columns (company name, industry, phone) - Use formulas to clean data - Share the file with your team - Update data in real time

Create Your Google Sheets

Go to sheets.google.com.

Click on "Create a new spreadsheet".

Create this header (first row):

Email | First Name | Last Name | Company

Fill in your data:

[email protected] | François | Dufour | Boulangerie Dufour
[email protected] | Marie | Bernard | Salon de Coiffure Bernard

Tip: if you have a lot of data, use Google Sheets to clean the data before mail merge. Example: use the PROPER() function to capitalize names correctly, or LOWER() to make emails lowercase.

Share Your Google Sheets

Click on "Share" at the top right.

Change permissions to "Anyone with the link" with "Editor" access.

Copy the link — you will need it to connect the Sheets to the mail merge.

---

Connect Google Sheets to Gmail Mail Merge

Now, the key moment: connect your Sheets directly to the mail merge.

Open Composition and Activate Mail Merge

Open a new Gmail message.

Click on "Use Mail Merge".

You will see two options: 1. Add from Google Contacts 2. Add from a spreadsheet

Click on "Add from a spreadsheet".

Select Your Sheets

Gmail will ask you: "Select a Google Sheets".

A window opens with your recent Sheets files. Find your file and click on it.

If you don’t see it, use the search bar.

Map the Columns

Gmail now asks: "Select the columns to use".

You will see a list of your columns (Email, First Name, Last Name, Company).

• Email: required (this is where the email will be sent)
• First Name: optional (but recommended for personalization)
• Last Name: optional

Select at least Email and First Name.

Click on "Finish".

Gmail is now loading your data from the Sheets. You will see a message: "X contacts found".

---

Write Your Email with Personalization

Now that your contacts are connected, you can write your email.

Available Tags

When you write, you can insert tags to personalize each email. The available tags are:

• @Email — the recipient's email address
• @First_Name — the recipient's first name
• @Last_Name — the recipient's last name
• @Full_Name — first name + last name

To insert a tag, type @ in your message. A dropdown list will appear with the available options.

Example of Personalized Email

Hello @First_Name,

I noticed you manage a @Company. 
I think our services could interest you.

Could you spare 15 minutes next week?

Best regards,
[Your name]

Each recipient will receive:

Hello François,

I noticed you manage a Boulangerie Dufour. 
I think our services could interest you.

Could you spare 15 minutes next week?

Best regards,
[Your name]

The Unsubscribe Link (Mandatory)

At the bottom of each email, Gmail automatically adds an "Unsubscribe" link.

Do not delete it. It is mandatory for anti-spam rules. If you delete it, Gmail may mark your account as a spammer.

---

Preview Before Sending: Check Your Data

Before sending to 500 people, always check a preview.

Click on "Preview" at the bottom of the composition window.

Gmail displays your email as it will be received, with the tags replaced by the real data. For example:

Hello François,

I noticed you manage a Boulangerie Dufour. 
...

Check: - The first and last names are correct - Special characters display correctly (accents, hyphens, apostrophes) - The unsubscribe link is present - No tag is left empty (for example, "@Company" instead of a real company)

If you see an empty tag, it means the column does not exist in your Sheets. Go back to your Sheets, add the column, and reconnect it.

You can navigate between previews with the arrows to check multiple recipients.

Common Issues and Solutions

Issue: Special characters display incorrectly (for example, "L'Atelier" becomes "L'Atelier")

Solution: Your CSV file is not encoded in UTF-8. Re-encode it: - Open the file in a text editor (Notepad++, VS Code) - Go to File > Encoding > UTF-8 - Save and re-import

Issue: An email is invalid and the preview shows an error

Solution: Go back to your Sheets, find and correct the email. Ensure there are no spaces before/after.

---

Send Your Mail Merge

Once satisfied with the preview, you are ready.

Click on "Send All" at the bottom right.

Gmail displays a final warning: "Are you sure? You will send X emails."

Confirm by clicking "Send".

Gmail is now sending your emails. Depending on the number of recipients, this may take a few seconds to a few minutes.

You will see a message: "Your emails have been sent".

The emails are now on their way.

---

Important Limits of Gmail Mail Merge

Gmail mail merge is powerful, but it has limits you need to know.

Limit of 1500 Emails Per Day

You can send a maximum of 1500 emails per day with Gmail (whether via mail merge or classic sending).

If you have 5000 contacts to reach, you will need to split them into 4 campaigns over 4 days.

Why this limit? Google implements it to prevent abuse and massive spam campaigns.

No Automated Email Sequences

Gmail does not have a function to create email sequences (also called "drip campaigns").

A sequence is: "Send email 1. If no response after 3 days, send email 2. If no response after 5 days, send email 3."

With Gmail mail merge, you have to do this manually.

Solution: use specialized tools like Lemlist, Instantly, or Mailchimp for sequences.

No Scheduling (Immediate Sending Only)

You cannot schedule a mail merge for later. When you click "Send All", the emails go out immediately.

If you want to send tomorrow at 10 AM, you will need to log in tomorrow at 10 AM and manually restart.

No Open or Click Statistics

Gmail does not tell you: - How many people opened your email - How many clicked on a link - Who clicked on "Unsubscribe"

You only see the replies that arrive in your inbox.

Solution: use tools like Google Analytics or UTM links to track clicks.

No A/B Testing

You cannot test two versions of an email (different subject, different body) to see which performs better.

You must send a single version to all recipients.

Personalization Limited to 4 Tags

You only have 4 tags available: @Email, @First_Name, @Last_Name, @Full_Name.

You cannot create custom tags like @Industry or @Region.

Workaround: use Google Sheets and create additional columns, but you will need to manually add each tag in the email.

---

Best Practices to Get Your Emails to Inbox

Sending 1500 emails is good. But ensuring they arrive in the inbox (not in spam) is better.

Here’s how to do it.

1. Always Keep the Unsubscribe Link

Gmail adds it automatically. Do not delete it. It is a legal requirement (CAN-SPAM Act in the U.S., GDPR in Europe).