Mail Merge for Google Sheets: Does It Actually Work for Small Teams

Mail merge via Google Sheets is one of those solutions that looks free until you read the fine print on Gmail’s daily sending limits. The core setup costs nothing and works well for small lists. Once you understand exactly what constrains it, you can decide whether it fits your use case or whether you need a proper email platform.

This article contains affiliate links. If you buy through them, I may earn a small commission at no extra cost to you.

Mail merge from Google Sheets uses your spreadsheet as a contact database, pulls fields like first name, company, and custom variables into a Gmail draft, and sends personalized emails to each contact without you writing individual messages. The most commonly used add-on for this setup is YAMM (Yet Another Mail Merge), which connects Sheets and Gmail through the Google Workspace Marketplace.

How to Set It Up with YAMM

Install YAMM from the Google Workspace Marketplace. It appears under Extensions in Google Sheets once installed. Create a spreadsheet with column headers that match the fields you want to merge. Standard headers include First Name, Last Name, Email Address, and any custom fields your email will reference. Every contact goes in a separate row.

Write your email draft in Gmail. Use double curly braces around your merge fields: {{First Name}}, {{Company}}, {{Custom Field}}. The field names in the draft must match the column headers in your spreadsheet exactly, including capitalization. If the spreadsheet column is “First Name” and the draft says {{firstname}}, the merge will not work.

Open YAMM from Extensions in Google Sheets, select Start Mail Merge, choose your Gmail draft from the list, and run the merge. YAMM shows you a preview of what the first email will look like before sending. The tracking feature in YAMM records opens and clicks in a new column in your spreadsheet, which is genuinely useful for follow-up sequencing.

The Sending Limits You Need to Know

YAMM’s free tier allows 50 emails per day. That is not 50 per month or 50 per campaign. It resets every 24 hours. For a list under 50 contacts, the free tier is sufficient. For anything larger, you are either upgrading YAMM or splitting your list across multiple days.

Gmail itself has its own sending limits independent of YAMM: 500 emails per day on a personal Gmail account, 2,000 per day on a Google Workspace account. YAMM’s paid plans cap at 400 per day on their individual plan and 1,500 per day on the team plan, so even paid YAMM stays below Gmail’s Workspace limit. If you need to send to more than 1,500 contacts in a single day, mail merge from Google Sheets is not the right infrastructure.

Deliverability Considerations

Emails sent through this method come from your personal or Workspace Gmail address. That is both an advantage and a risk. The advantage is that they look like genuine personal emails because they are. The risk is that if your campaign generates complaints or bounces, those affect your personal sending reputation on that Gmail account.

For cold outreach, this risk is real. Gmail’s spam filters are sophisticated and accounts that send similar-looking emails to large lists in short windows can be flagged. For warm outreach to existing contacts, customer follow-ups, or internal communications, the deliverability risk is minimal. Use this tool for lists where you have some relationship with the recipients, not for cold prospect lists.

What Mail Merge from Google Sheets Cannot Do

There is no A/B testing capability. You cannot send version A of an email to half your list and version B to the other half without manually splitting the spreadsheet and running two separate merges. There are no automated sequences. If you want to send a follow-up three days after the first email, you build a separate spreadsheet and run a separate merge manually. There is no unsubscribe management built in, which creates compliance risk for anything that could be classified as commercial email under CAN-SPAM.

For workflows that go beyond what Google Sheets mail merge can handle, Make.com can automate the entire sequence: trigger an email when a form is submitted, add the contact to a Google Sheet, wait three days, and send a follow-up, all without manual intervention. For an all-in-one solution that handles email marketing with built-in list management and deliverability tools, Systeme.io is worth evaluating. Their free tier supports up to 2,000 subscribers with unlimited email sends.

When Mail Merge from Google Sheets Is the Right Tool

It is the right tool for: personalized outreach to a list under 400 people where you have an existing relationship, one-time campaigns that do not require follow-up automation, internal team communications that need to address people by name, and event invitations where CAN-SPAM compliance is not a concern.

It is not the right tool for: cold email campaigns at any scale, ongoing newsletter distribution, any list that requires unsubscribe management, or campaigns where you need open rate and click data beyond the basic tracking YAMM provides.

The free tool stack covered in the 2026 tool stack guide puts mail merge in context alongside other zero-cost options. For AI-assisted email writing that improves the copy going into your merge templates, the writing assistance guide covers the practical workflow. And if you are using mail merge as part of a broader content distribution strategy, the SEO content marketing guide explains how email fits into the larger picture.