GPT for Google Sheets, Docs AI, Slides, Forms

How to Mail Merge in Gmail with Google Sheets (Step-by-Step)

How to mail merge in Gmail with Google Sheets: Gmail's built-in option, Apps Script or an add-on. Real steps, placeholders, test emails and daily limits.

To mail merge in Gmail with Google Sheets, list one recipient per row in a sheet, write the email once as a Gmail draft with placeholders such as {{First Name}}, and let a tool send one personalized copy per row. You can use Gmail’s built-in mail merge (eligible Google Workspace plans only), a Google Apps Script, or a Sheets add-on such as Mail Merge for Gmail and Google Sheets, which also works on free @gmail.com accounts.

Try Mail Merge for Gmail and Sheets →

What “mail merge in Gmail” actually means

A mail merge combines a template (your subject and body, with placeholders like {{First Name}}) with a data source (your Google Sheet, where each row is one recipient). It sends one separate email per row, so nobody sees the rest of the list.

What you need before you start

  • A Google Sheet with one row per recipient and clear column headers.
  • A Gmail or Google Workspace account to send from.
  • An email draft with placeholders that match your column headers exactly.
  • A clear reason to email the list: people who expect to hear from you, or a relevant outreach context.
  • A plan for opt-outs, and time to send yourself a test before the real campaign.

Set up your Google Sheet columns

Mail Merge for Gmail and Sheets needs two headers spelled exactly like this: Email and Mail Merge. When you click Launch on an empty sheet, the add-on creates Email, First Name, Last Name and Mail Merge in row 1 for you. Add any other columns to the right.

Column Example Why it matters
Email [email protected] Required. One address per row
First Name Alex Greeting
Last Name Rivera Optional
Mail Merge (leave empty) Required. The add-on writes each row’s status here
Company Northstar Labs Business context
Reason hiring SDRs A specific personalization line

Remove duplicate rows, fix invalid emails, fill missing fields, and put very different audiences on separate tabs. Mail merge scales a message, so small mistakes scale too.

Method 1: Gmail’s built-in mail merge

Gmail has its own mail merge in the compose window (Use mail merge, next to To). It is plan-gated: only eligible Google Workspace plans have it (Workspace Individual, Business Standard and Plus, Enterprise Standard and Plus, Education Standard and Plus), not free @gmail.com accounts. It personalizes with tags such as @firstname or columns from a linked spreadsheet, for up to 1,500 recipients a day.

Method 2: Google Apps Script (free but technical)

You can write a Google Apps Script that reads your sheet and sends through Gmail. It’s free, but you write and maintain the code yourself. Scripts are bound by Google’s Apps Script quota: about 100 recipients a day on @gmail.com and 1,500 on Google Workspace. A fine path for developers, a poor fit if you just want to send today.

Method 3: A mail merge add-on for Sheets and Gmail

An add-on does the scripting for you. Mail Merge for Gmail and Sheets fills the placeholders in your Gmail draft from your sheet and sends one email per row from your own Gmail account, on free @gmail.com or any Workspace plan. It adds a test email, a status for every row, and open and click tracking on every plan. Paid plans add scheduling and a different attachment per recipient.

You start with 11 free emails; paid plans start at $4.99 a month or $49.99 a year (pricing). The add-on runs on Apps Script, so the same daily quota applies.

Start your first merge →

Step-by-step: mail merge with the add-on

  1. Install and launch. Install the add-on from the Google Workspace Marketplace with the account you send from. In your sheet, open Extensions → Mail Merge for Sheets™ Gmail™ → Launch. It creates the Email, First Name, Last Name and Mail Merge headers.
  2. Add recipients, one per row. Paste them, or use Import Google Contacts.
  3. Write a Gmail draft. Click Compose, leave To empty, and write the subject and message with placeholders that match your headers, e.g. Hi {{First Name}}, quick note about {{Company}}…. Close the window; Gmail saves the draft.
  4. Start a new campaign. In the sidebar, click Start New Campaign and pick your draft. On Campaign Options, choose tracking and add a Sender Name or Reply-to if you need one.
  5. Send a test. On 3. Schedule, click Send Test Email. It goes only to you, filled with row 2’s data. Check that nothing shows a raw {{tags}}.
  6. Send. Click Start Campaign, or schedule it on a paid plan. Each sent row gets EMAIL_SENT. Later, Refresh Email Status shows EMAIL_OPENED and EMAIL_CLICKED.

Every option is explained in Get started.

Write a personalized template

A good mail merge template reads like a normal email. Each placeholder needs a column with exactly that header; one with no matching column is sent as it is.

Example: sales outreach (columns: First Name, Company, Reason, Idea)

Subject: Idea for {{Company}}

Hi {{First Name}},

I saw that {{Company}} is focused on {{Reason}}. One practical next step could be {{Idea}}.

If useful, I can send a quick example for your team.

Best, Ana

Example: customer update (columns: First Name, Company, Update, Segment, Next Step)

Subject: Update for {{Company}}

Hi {{First Name}},

Quick update: {{Update}}.

Because you are in the {{Segment}} group, the most relevant next step is {{Next Step}}.

Thanks, Ana

Need a first draft? The free ChatGPT email generator, a separate DocGPT.ai tool, writes one from a short brief. Placeholder rules: Personalize with placeholders.

Test before going live

A short test prevents a Hi {{First Name}} going out to your whole list. There is no preview of every row, so use this order:

  1. Put a tricky row in row 2. The test uses row 2’s data, so a long company name or an empty field shows problems fast.
  2. Click Send Test Email. It goes only to you and doesn’t use your free emails. Check the subject, greeting, links, attachments and signature.
  3. Ask a teammate. Forward the test for a second opinion on the tone.
  4. Send a small real batch. Set Maximum emails per launch low, then watch your inbox for replies and bounce messages.
  5. Send the rest. Run the campaign again. Rows marked EMAIL_SENT are skipped.

Track results and plan follow-ups

With tracking on, click Refresh Email Status in the sidebar and the Mail Merge column changes to EMAIL_OPENED or EMAIL_CLICKED. Open counts are approximate, because some email apps block or pre-load images.

The add-on doesn’t track replies, bounces or unsubscribes; replies arrive in your Gmail inbox. Note replies and bounced addresses in a column of your own, and type SKIP in the Mail Merge cell of anyone who opts out so later runs skip them.

There are no automatic follow-ups. To send a second email, copy the rows you want (for example, those without EMAIL_OPENED or EMAIL_CLICKED) to a new tab, write a shorter draft and run a new campaign there. See mail merge follow-up emails.

Examples by team

  • Sales teams: keep leads, company context, outreach reason and owner in Sheets. Keep personalization factual and easy to verify.
  • Recruiters: use columns for candidate name, target role, skill match, location preference and recruiter. Avoid sending irrelevant roles to broad lists.
  • Customer success: send onboarding reminders, feature updates, renewal notices or feedback requests to segmented customers, with clear opt-out or preference language.
  • Community and events: keep attendee lists, event tracks and registration details in Sheets. Test links and calendar details before sending.

Sending limits and big lists

Mail Merge for Gmail and Sheets sends through Google Apps Script, so Google’s Apps Script quota applies: about 100 recipients a day on a free @gmail.com account and about 1,500 a day on Google Workspace (source: Google’s Apps Script quotas). It resets 24 hours after your first send, and a paid plan doesn’t raise it. The 2,000-a-day figure you may have seen is Gmail’s own limit for mail Workspace users send in Gmail itself; it doesn’t apply to Apps Script.

To send a big list over several days, set Maximum emails per launch a little under your limit (for example 90 on @gmail.com) and run the campaign once a day. Each run sends the next unsent rows. Details: Gmail sending limits for mail merge.

To protect your sender reputation, email only people who expect to hear from you, add an opt-out line (the add-on doesn’t add an unsubscribe link), and avoid spammy subjects and link-heavy messages. Consent rules such as CAN-SPAM and GDPR are your responsibility as the sender.

Responsible sending checklist

Before you press send, confirm that:

  • recipients are consented or clearly relevant;
  • subject lines are accurate;
  • every placeholder matches a header exactly;
  • links and attachments are tested;
  • opt-out requests can be honored;
  • your daily volume fits Google’s limit;
  • someone watches the inbox for bounces and replies.

How to mail merge in Gmail FAQ

Can I mail merge in Gmail for free?

Yes. Google Apps Script is free if you can write code. Mail Merge for Gmail and Sheets gives you 11 free emails to start, including on free @gmail.com accounts. Gmail’s built-in mail merge has no extra cost but needs an eligible Google Workspace plan.

Do I need Google Workspace to use Gmail’s built-in mail merge?

Yes. Gmail’s built-in mail merge is available only on eligible Workspace plans. Free Gmail users can mail merge with an add-on or Apps Script instead.

How many emails can I send in a Gmail mail merge?

With a Sheets add-on or Apps Script, Google allows about 100 recipients a day on @gmail.com and 1,500 on Google Workspace. The quota resets 24 hours after your first send. Gmail’s built-in mail merge allows 1,500 recipients a day on eligible Workspace plans.

What columns do I need for a Gmail mail merge?

With Mail Merge for Gmail and Sheets, you need headers named exactly Email and Mail Merge. Launch creates Email, First Name, Last Name and Mail Merge for you. Add any other column, such as Company, and use it as a placeholder.

Can I track opens and clicks?

Yes. Mail Merge for Gmail and Sheets tracks opens and clicks on every plan, including free. Click Refresh Email Status to update the Mail Merge column. It does not track replies, bounces or unsubscribes. Replies arrive in your Gmail inbox.

How is a mail merge different from a group email?

A mail merge sends a separate, personalized message to each recipient, so people never see each other’s addresses. A group email puts everyone on one message, which exposes the list and feels impersonal.

Send your first personalized merge

Keep your recipients in Google Sheets, write one Gmail draft, send yourself a test, and let Mail Merge for Gmail and Sheets send a personalized email to each row.

Try Mail Merge for Gmail and Sheets →