Mail Merge Gmail: How to Send Personalized Emails at Scale

TL;DR: Gmail mail merge sends personalized emails at scale by pulling contact data from a Google Sheet into a single email template. You can do it free with Gmail's built-in multi-send (Workspace only), free with Google Apps Script, or with basic paid add-ons like Mailmeteor ($9.99/month) or YAMM ($30/year). 

The hard limits: free Gmail caps at 500 emails/day, Workspace at 2,000/day, and sustainable cold outreach is 50-100/day per mailbox before you start damaging your sender reputation. When you need real sequences, multiple mailboxes, automated warmup, and AI reply handling, Gmail mail merge is the wrong tool. That's where Smartlead picks up.

A Gmail mail merge sends a single email template to multiple recipients as individual, personalized emails, pulling contact-specific data (first name, company, custom fields) from a Google Sheet into each message. Every recipient receives a separate email in their inbox, not a CC or BCC blast.

Here is the problem that brings most people to this page: you tried sending personalized bulk email from Gmail and either hit a daily limit, landed in spam, or got your account restricted. Or you are looking at various Gmail add-ons and extensions and want to know which ones are actually worth using and which limitations apply to all of them, regardless of which you choose.

This mail merge Gmail guide answers both questions. We cover every method for sending Gmail mail merge (free and paid), the real sending limits that matter for deliverability (not just the official caps), and the point at which Gmail mail merge stops being a viable tool for sales outreach. If you are still unclear on what cold email actually means vs a mail merge, that guide covers the distinction in detail.

What Is Gmail Mail Merge and When Should You Actually Use It?

Gmail mail merge is the right tool for a specific, narrow use case: sending one personalized email to a curated list of people who have some prior relationship with you or your organization.

Use Mail Merge Gmail when:

• You are sending under 100 emails per day from a single Gmail account
• The list is curated and warm (event invites, customer announcements, alumni outreach, small newsletters)
• You need basic personalization (first name, company name, one or two custom fields), but not multi-step logic
• You want a free or low-cost solution without needing warm-up infrastructure or reply tracking

Do not use Mail Merge Gmail when:

• You are running cold outreach to people who do not know you (the single biggest deliverability mistake)
• You need a multi-step sequence (initial email plus follow-ups based on opens or replies)
• You are sending more than 100 emails per day per mailbox to strangers
• You need A/B testing, reply classification, or unified inbox management
• You want results that do not depend on luck and reputation management

Gmail mail merge is a communication tool, not a sales outreach tool. If your goal is to start conversations with strangers who have never heard of you, you have already outgrown it before you started. For a full breakdown of the approach that actually scales, the cold email sequence guide covers multi-step campaign architecture in detail.

Every Method for Gmail Mail Merge in 2026 (Free and Paid)

There are five methods. Here is what each one actually does.

Method 1: Gmail's Built-In Multi-Send (Workspace Only, Free)

What it is: Gmail's native mail merge feature, called "multi-send" or "mail merge mode," available on Google Workspace Individual, Business Standard, Business Plus, Enterprise Standard, and Enterprise Plus. Free Gmail accounts (gmail.com) do not have this feature.

Step-by-step:

1. Create a Google Sheet with column headers in row 1: email, first_name, company, and any custom fields you need.

2. Open Gmail and click Compose. In the compose window, click the small toggle icon at the bottom right. The tooltip says "Mail merge" or "Multi-send." Click to enable it. The window turns purple.
3. In the To field, click "Add from a spreadsheet." Select your Sheet. Map the email column.
4. Type @ in the email body to insert merge tags. Gmail surfaces your Sheet columns. Select one, and a {{first_name}} style tag appears.
5. Click "Continue" then "Send all." Gmail sends individual personalized copies. Each appears as a separate thread in the recipient's inboxes and in your Sent folder.

Hard limits:

• 1,500 emails per multi-send batch
• 2,000 per day total (Workspace)
• No reply tracking, no scheduling per recipient, no sequences, no conditional logic, no follow-ups
• No open or click tracking

Best for: Workspace users who need a free one-shot personalized send with no add-ons.

Method 2: Google Apps Script (Free, Technical)

What it is: Google publishes a free Apps Script mail merge template that scripts the send process. Works on free Gmail accounts.

Step-by-step:

1. Make a copy of Google's official Gmail Mail Merge Apps Script template Sheet.
2. Replace the sample data with your contacts. Keep Recipient as the email column header (the script requires this exact name).
3. In Gmail, compose a new draft. Use {{First name}} double curly brace merge tags matching your Sheet column names. Save as draft. Do not send.
4. Back in the Sheet, click "Mail Merge" in the top menu (the script adds this menu after authorization). Click "Send Emails."
5. When prompted, paste the subject line of your draft. Authorize the script to send on your behalf.

Honest assessment:

• Free and works on personal Gmail accounts
• No UI, no tracking, no scheduling, no follow-ups
• If the script fails midway, you have to manually track which rows were sent
• No inbox placement testing or spam protection of any kind

Best for: Technical users on free Gmail accounts who want zero cost and do not mind debugging scripts.

Method 3: GMass (A Gmail Chrome Extension With Serious Limitations)

What it is: A Chrome extension that lives inside Gmail. It adds basic sequencing and conditional logic for individual senders, but it is locked entirely to Gmail infrastructure and built for solo users. It is also one of the most searched tools when people want an alternative, because its limitations become apparent quickly once you try to scale.

Step-by-step:

1. Install GMass from the Chrome Web Store. Sign in to Gmail. A red GMass button appears next to the compose button.
2. Click the GMass spreadsheet icon. Connect your Google Sheet. GMass parses the columns and converts them into merge tags.
3. Compose your email using {first_name} syntax (single curly braces in GMass, not double). Add subject, optional scheduling, and follow-up sequences.
4. Click the red GMass button (not Gmail's Send). GMass queues your emails with 5 to 60 second delays between sends.

Where GMass stops working for serious outreach:

• Locked to Gmail only: You cannot use it with Outlook, Microsoft 365, or any custom SMTP setup. If your team or your prospects are on anything other than Gmail, GMass is immediately disqualified.
• No automated warmup: GMass sends from whatever reputation your Gmail account currently has. There is no warmup infrastructure to protect you on a new or low-activity domain. Your deliverability depends entirely on your existing domain reputation and luck.
• Single-user pricing with no shared inbox: Plans start at $19.95/month per user with no team inbox, no reply routing across reps, and no way to manage shared campaigns. Teams of more than one person find the structure quickly unworkable.
• No real multi-mailbox rotation: GMass is effectively one-mailbox software. Distributing sends across mailboxes to stay under Gmail's daily limits has to be done manually.
• Rides entirely on Gmail's infrastructure: Your sending limits, domain reputation, and deliverability outcomes are all governed by Google's rules. There is no dedicated sending infrastructure, no isolated IP, and no protection if Gmail changes its policies.
• Email only. No LinkedIn, no calling, no coordinated multi-channel sequences.

GMass pricing (2026): Standard $19.95/month, Premium $29.95/month, Professional $49.95/month. All plans are per-user with no shared team features. See GMass pricing.

Verdict: GMass works for one person sending a small number of Gmail-only campaigns who does not need warmup, team features, or multi-mailbox management. Most outbound teams hit their ceiling within weeks of any real scaling attempt.

Method 4: Mailmeteor (Simple and Cheap)

What it is: A Google Workspace Marketplace add-on that operates inside Google Sheets. The simplest paid option with a genuinely usable free tier.

Step-by-step:

1. Install Mailmeteor from the Google Workspace Marketplace.
2. Open your contact Sheet. Click Extensions > Mailmeteor > Send emails.
3. Mailmeteor opens a side panel. Write your email with {{first_name}} tags. Preview each row before sending.
4. Click Send Emails. Mailmeteor uses your Gmail account to send.

Pricing: Free for 75 emails/day. Premium from $9.99/month for 1,500 emails/day. See Mailmeteor pricing.

Best for: Non-technical users who work in Sheets and want the fastest setup. Event coordinators, teachers, and small nonprofits.

Limitations: No conditional logic, no sequences, no unified reply inbox. Open and click tracking is available only on Premium.

Method 5: YAMM (Yet Another Mail Merge)

What it is: Another Google Workspace Marketplace add-on with a similar workflow to Mailmeteor, but with slightly more tracking visibility built directly into the Sheet.

Step-by-step:

1. Install YAMM from Google Workspace Marketplace.
2. Draft your email in Gmail. Save it as a draft (do not send).
3. Open your contact Sheet. Click Add-ons > Yet Another Mail Merge > Start Mail Merge.
4. Select the draft, map your columns, and send. YAMM adds a status column to your Sheet showing sent, opened, and clicked per row.

Pricing: Free for 50 emails/day. Personal $30/year (1,500 emails/day). Pro $50/year. Team $60/user/year.

Best for: Teams that want open and click tracking inside the Sheet itself without needing a Chrome extension.

Limitations: No sequences, no conditional logic, limited reply tracking.

Side-by-Side Comparison: All Five Methods + Smartlead

The table makes the ceiling of every Gmail-native tool clear. None of them includes warmup, multi-mailbox rotation, Outlook support, or a team inbox. These are not missing features you can work around. They are architectural limits of tools built on top of Gmail rather than purpose-built for outbound.

How to Set Up Google Sheets for Gmail Mail Merge (The Right Way)

A badly structured Sheet is the most common reason mail merges fail silently or embarrassingly.

Required columns:

• email — lowercase, the actual address. This is always the primary key.
• At least one personalization column (first_name minimum)

Recommended columns:

• last_name
• company
• title
• custom_field_1 — a specific hook (recent news, mutual connection, funding event, recent blog post)
• custom_field_2 — the relevance bridge (why this is pertinent to them specifically)

Merge tag syntax by tool:

A working email template using merge tags:

Subject: Quick question about {{company}}'s {{custom_field_1}}

Hi {{first_name}},

Saw {{company}}'s {{custom_field_1}} — {{custom_field_2}}.

We help teams like yours [specific outcome]. Worth a 15-minute look?

[Sender name]

Sheet hygiene checklist before every send:

• Remove all rows with empty email cells (use Filter > "email is not empty")
• Run =TRIM(A2) on the email column to remove trailing spaces
• Use consistent column naming (all lowercase or all title case, pick one)
• Send a test to yourself first using a row with your own email address
• Verify at least a sample of addresses with NeverBounce or ZeroBounce before sending to a cold or old list

Gmail Sending Limits: The Official Caps vs the Real Limits That Actually Matter

This section is what most guides get wrong. The official Gmail limit and the practical safe volume are very different numbers.

The Official Gmail Sending Limits (2026)

Google Workspace: Email sending limits. The 24-hour window is rolling from your first send of the day, not a calendar reset at midnight.

What Hitting the Limit Looks Like

When you exceed the cap, Gmail returns a 550-5.4.5 Daily user sending limit exceeded SMTP error. Gmail then locks outgoing sends from that mailbox for 1 to 24 hours. Repeatedly hitting the cap creates a negative signal in Gmail's internal sender scoring system.

The Real Safe Volume for Cold Outreach

The official 2,000/day limit is not the number you should be sending. For cold outreach to people who do not know you:

• 50 to 100 emails per day per mailbox is the sustainable cold outreach volume
• 200 to 300 per day is acceptable for warm lists or opt-in contacts
• 500+ per day from one mailbox to cold prospects will trigger Gmail's spam filters within 7 to 14 days, per Google Postmaster Tools data

Gmail's spam filters do not just count volume. They track the engagement rate of your outgoing mail. If you send 500 cold emails and 3% get marked as spam (15 complaints), you have crossed Gmail's internal 0.1% spam complaint threshold that triggers throttling. Cold mail to strangers with no warm-up and no list verification will hit that threshold much faster than you expect.

How to Work Around Gmail's Daily Limits

Option 1: Add more Gmail mailboxes

Each mailbox gets its own 2,000/day cap. Five warmed Workspace mailboxes give you 10,000 sends per day in theory, but keep individual mailbox cold volume under 200/day. Gmail-native tools handle one mailbox; dedicated platforms handle unlimited.

Option 2: Rotate across secondary domains

Register 2 to 3 secondary domains (yourcompany.co, getyourcompany.com), authenticate them (SPF, DKIM, DMARC), and run separate mailboxes on each. This isolates your primary domain from cold email reputation risk. The full setup process is covered in the email deliverability guide.

Option 3: Move to a dedicated cold email platform

This is the only option that scales without managing spreadsheets of mailboxes manually. Smartlead handles the rotation, warmup, and reputation management automatically across unlimited connected mailboxes.

Protecting Your Sender Reputation During a Gmail Mail Merge

This is the step that virtually every Gmail mail merge guide skips, and it is the step that determines whether your campaigns land in inboxes or spam folders.

What does sender reputation mean in Gmail's context? 

Gmail assigns every sending domain and IP a reputation score based on spam complaint rate, bounce rate, engagement rate (opens and replies vs ignores and deletions), and authentication status (SPF, DKIM, DMARC pass rates). This score directly controls where your emails land.

The three things that destroy sender reputation fastest in a mail merge context:

1. High bounce rate 

If more than 2-3% of your sends have a hard bounce (invalid addresses), Gmail interprets this as evidence that you are sending to scraped or purchased lists. Always verify email addresses before a cold send, regardless of where they came from.

2. High spam complaint rate

Google's enforced threshold is 0.1% spam complaints (1 in every 1,000 emails). Mail merging to cold contacts who do not recognize your name will hit this threshold faster than you expect. Once you cross 0.3%, Gmail begins aggressive filtering and throttling.

3. No warmup

Sending a mail merge from a brand-new Gmail account or a domain that has not been gradually warmed will trigger spam folder placement almost immediately. New mailboxes need 14 to 30 days of gradual volume ramp-up before any cold campaign.

Pre-send reputation checklist:

• Verify your domain DNS (SPF, DKIM, DMARC) with MXToolbox before sending
• Run a sample email through mail-tester.com — score of 8/10 minimum before sending
• Verify email addresses with NeverBounce or ZeroBounce (keep bounce rate under 2%)
• Check Google Postmaster Tools for domain reputation signals if you have sent campaigns before
• If the domain is under 30 days old, do not run a cold mail merge, warm it first

How to Personalize Beyond {{first_name}}: What Actually Moves Reply Rates

Basic token replacement (Hi {{first_name}}) is table stakes. It improves over "Hi there," but by itself produces 1 to 3% reply rates. Here is the full personalization ladder, with data from the cold email statistics benchmarks.

Level 1: Token replacement only 

Hi {{first_name}}, hope you're well. Reply rate: 1 to 3%. Gets ignored by experienced prospects.

Level 2: Token plus company or role context 

Hi {{first_name}}, saw {{company}} just raised {{custom_field_1}}. Reply rate: 3 to 5%. Still feels templated to sharp readers.

Level 3: First-line personalization per prospect

A custom opening sentence per prospect referencing something specific, like their LinkedIn post, a news article, a product launch. The rest of the email is templated. Reply rate: 5 to 9%. This is where serious outbound lives.

Level 4: Full first-paragraph personalization

The entire opening paragraph is bespoke. The pitch and CTA are templated. Used for the highest-value target accounts. Reply rate: 9 to 15%. Only sustainable with AI assistance or very small, high-value lists.

Generating Level 3 personalization at scale:

Add a custom_intro column to your Sheet. Fill it with AI-generated or researched one-liners per prospect. Reference that column as the first line of your template:

{{custom_intro}}

That's why I wanted to reach out. We help {{company}} [specific outcome]...

This approach works in all five Gmail mail merge methods since it is just a merge tag. For pre-built frameworks, see the cold email templates that get replies.

How to Track Opens, Clicks, and Replies

Gmail's built-in multi-send does not track opens or clicks. Here is what each tool provides.

The Apple MPP problem for Gmail mail merge in 2026:

Apple Mail Privacy Protection pre-fetches every tracking pixel in emails received on iOS devices, inflating open rates with phantom opens. As of late 2024, over 70% of iOS Mail users have MPP active. Your "open rate" from any tracking tool includes a significant number of fake opens from Apple's servers. The only reliable engagement metric for outreach in 2026 is reply rate, not open rate.

When Gmail Mail Merge Breaks: 5 Signs You've Outgrown It

Every serious outbound team eventually hits one of these five walls. When you do, no amount of optimizing your Sheet or tweaking your merge tags fixes the underlying problem.

Sign 1: Emails landing in spam despite clean lists and good copy.

The cause is almost always the same: no automated warmup, no reputation infrastructure, sending from a Gmail account that lacks a warmup history at your current volume. None of the Gmail-native tools in this guide fix this because the fix is at the infrastructure level, not the template level.

Sign 2: The daily cap hit and pipeline are not moving.

When 100 cold emails per day from one mailbox is not generating enough replies to fill your pipeline, the options are: burn one mailbox by pushing to 1,000/day (typically destroys sender reputation within two weeks), or build a multi-mailbox infrastructure that every tool covered in this guide was not designed to manage.

Sign 3: You are manually tracking follow-ups in a spreadsheet.

Hunter.io's 31-million email analysis found that a single email achieves a 3.3% reply rate. Three to four follow-ups push that to 6.8%, a 106% lift. If you are running follow-ups manually, you are leaving more than half your potential replies on the table.

Sign 4: Replies are piling up across multiple Gmail tabs.

Once you are sending to 3 or more mailboxes, replies scatter. You miss messages. You double-reply. You follow up with people who already responded. No Gmail mail merge tool includes a centralized reply view. Smartlead’s Master Inbox consolidates every reply across all connected mailboxes into one prioritized view.

Sign 5: You need AI to handle reply triage.

Classifying replies ("interested," "not right now," "wrong person," "out of office") manually at scale is 30 to 60 minutes per day of pure admin. SmartAgents do this automatically, route interested replies to the right rep, and can draft responses or book meetings directly. No Gmail mail merge tool has an equivalent.

Why Smartlead Is the Right Tool When Gmail Mail Merge Runs Out

When Gmail mail merge hits its ceiling, the answer is not a different Gmail extension. Every extension covered in this guide shares the same fundamental constraints: Gmail's infrastructure, Gmail's sending limits, Gmail's deliverability rules, and no warmup. Switching from one Gmail tool to another does not solve those problems.

Smartlead is purpose-built for the use case that Gmail mail merge cannot handle: outbound sales at real volume, across multiple mailboxes, with deliverability infrastructure built in from day one.

What Smartlead does that no Gmail mail merge tool can:

Unlimited mailboxes with automated rotation

Connect 5, 50, or 500 Gmail, Outlook, or custom SMTP mailboxes. Smartlead sends them automatically, keeping per-mailbox volume under the threshold that triggers reputation damage.

Automated email warmup on every mailbox

Every connected mailbox gets daily warmup emails through Smartlead's 35,000 account warmup network. This builds the sending reputation that determines inbox placement before you ever run a campaign. No Gmail mail merge tool includes this.

Real multi-step sequences with conditional branching

Day 1, Day 3, Day 7, Day 14 cadences with logic that stops when someone replies, escalates when they open multiple times, and switches to a different angle if the first two emails go unopened.

Coordinated multi-channel outreach

Email, LinkedIn touches, and cold calling (via SmartCoach) in a single coordinated sequence. Gmail mail merge is email only. Teams running multi-channel campaigns consistently produce 3x more meetings than email-only approaches.

AI-powered reply management via SmartAgents

Reads every incoming reply, classifies intent, routes hot leads to the top of your inbox, and can draft responses or book meetings. This saves serious outbound teams 30 to 60 minutes per day.

First-party deliverability data

Smartlead surfaces your reply rate, inbox placement rate, and spam complaint rate against benchmarks across 100,000 users, so you know immediately when something is wrong before it damages your domain.

When to make the switch:

• Under 50 cold emails/day total: Mailmeteor or YAMM is adequate for simple use cases.
• 50 to 100 cold emails/day: You are at the boundary where Gmail infrastructure starts becoming the bottleneck.
• 100+ cold emails/day across multiple mailboxes: You have already outgrown every tool in this guide.

"We moved to Smartlead when our team grew to 5 SDRs. The unified inbox alone saved 40 minutes per day per rep. The warmup network took our inbox placement from 61% to 89% in three weeks." — G2 reviewer, B2B SaaS sales team, January 2026

If you want to find out more about mail merge software, then check this mail merge software guide

Common Gmail Mail Merge Mistakes (and How to Avoid Them)

Mistake 1: Using a brand-new Gmail account for cold mail merge

New accounts have no sending reputation. Hitting even 50 cold emails in the first week can trigger Gmail's anti-spam systems. Warm new accounts gradually over 14 to 30 days before any cold campaign.

Mistake 2: Sending to unverified lists

A 5% bounce rate from one campaign can take weeks to recover from in terms of domain reputation. Always verify before sending, not after.

Mistake 3: Not testing merge tags before the full send

Send the complete email to a test account with your actual data before touching the real list. "Hi @first_name," reaching 500 people is a reputation event, not just an embarrassment.

Mistake 4: Using your primary business domain for cold outreach

Spam complaints from cold outreach follow the sending domain. If you send cold mail from the same domain you use for customer support and product emails, a reputation hit affects everything. Use a secondary sending domain for cold outreach. The best cold email software guide covers domain architecture in more detail.

Mistake 5: Treating the 2,000/day Workspace limit as the safe volume

The official limit is the technical cap. The practical safe limit for cold outreach to strangers is 50 to 100/day per mailbox. The gap between those numbers is where most deliverability disasters happen.

Mistake 6: No unsubscribe option in cold outreach emails

Under CAN-SPAM, every commercial email must include a way to opt out. A one-line "Reply 'unsubscribe' to be removed" at the bottom of every template is the minimum. Not including it is a legal risk and inflates spam complaint rates.

Frequently Asked Questions

Is Gmail mail merge free? 

Gmail's built-in multi-send is free for Google Workspace accounts (Business Standard and above). It is not available on free Gmail accounts. Free alternatives include Google Apps Script (works on free Gmail), Mailmeteor's free 75/day plan, and YAMM's free 50/day plan.

How many emails can you send per day with Gmail mail merge? 

Free Gmail (gmail.com): 500 per 24 hours. Google Workspace: 2,000 per 24 hours. The safe, sustainable volume for cold outreach to strangers is much lower: 50 to 100 per mailbox per day. Sending the full Workspace cap to cold contacts will trigger spam filtering within 7 to 14 days based on Google Postmaster Tools data.

Can you do a mail merge with attachments in Gmail? 

Static attachments (same file for every recipient) work in Gmail's built-in multi-send. Per-recipient attachments (a different file per row) require a third-party add-on with file URLs stored in a Sheet column.

What is the difference between Gmail mail merge and a cold email sequence? 

Gmail mail merge sends one personalized email to many people, one time. A cold email sequence sends an initial email plus 3 to 5 automated follow-ups over 14 to 21 days, with conditional logic that stops the sequence when someone replies. Mail merge is a single send. A sequence is an ongoing campaign.

Can I do Gmail mail merge without Google Sheets? 

Not reliably. All five methods use Google Sheets as the data source. You can manually enter recipients in Gmail's multi-send To field without a Sheet, but you lose merge tag capability. Google Sheets is the required data layer for any meaningful personalization.

What should I use instead of Gmail mail merge for sales outreach? 

For anything beyond basic one-shot personalized sends, you need a platform built for outbound rather than a Gmail add-on. Smartlead handles unlimited mailboxes, automated warmup, multi-step sequences, and AI reply management in one platform. See the full platform comparison for a detailed breakdown.

Does Gmail mail merge work with Outlook or other email providers? 

No. All five Gmail mail merge methods send exclusively from Gmail or Google Workspace accounts. If you need to send from Outlook, Microsoft 365, or custom SMTP, you need a dedicated cold email platform. Smartlead supports Gmail, Workspace, Outlook, Microsoft 365, and custom SMTP across unlimited mailboxes.

Is Gmail mail merge GDPR compliant? 

Compliance depends on how you use it, not the tool itself. You need a lawful basis (consent or legitimate interest) for every recipient, an opt-out mechanism in every email, and a documented process for honoring deletion requests. Gmail mail merge does not add or remove GDPR compliance obligations.

How do I avoid my Gmail mail merge landing in spam? 

Five things that matter most: verify email addresses before sending, keep your daily volume under 100 cold sends per mailbox, include a genuine opt-out option, use a warmed sending domain, and check your spam score with mail-tester.com before the full send. If your score is below 8/10, fix the issues flagged before sending to your real list.

What is the difference between a mail merge and BCC? 

BCC sends one email to multiple recipients, where each recipient sees "Undisclosed recipients" in the To field. Mail merge sends separate, individual emails to each recipient, where they see only their own address in the To field. BCC is widely recognized as a spam signal. Mail merge produces individual sends that look like personal emails.