To do a mail merge from a spreadsheet, you put one person on each row and one detail in each column. Then you write the message once, with a placeholder wherever a detail goes. The mail merge tool sends one copy per row, with that row’s details filled in. With Google Sheets, you have four good ways to do it:
- Gmail’s own merge, if your Workspace plan has it. No install, up to 1,500 a day.
- Google’s free Apps Script, which works on any Google account. No code to write.
- An add-on like YAMM or Mailmeteor, for tracking and a friendlier screen.
- Docs and label add-ons, when the output is letters, PDFs or envelopes instead of email.
Your sheet works for all of them. Set it up once, using the template below, and you can switch routes without starting over. Every Google fact here comes from Google’s own pages, checked on October 5, 2026.
A Google Sheet template for mail merge
Here’s a sheet that works with Gmail’s merge, Google’s script and the add-ons alike. Copy the block below, paste it into cell A1 of a new sheet, and pick Data > Split text to columns if it lands in one column.
Recipient,FirstName,Company,InvoiceNumber,DueDate,Email Sent
maria@example.com,Maria,Alvarez Design,1042,October 15,
sam@example.com,Sam,Northside Bakery,1043,October 20,
| Recipient | FirstName | Company | InvoiceNumber | DueDate | Email Sent |
|---|---|---|---|---|---|
| maria@example.com | Maria | Alvarez Design | 1042 | October 15 | |
| sam@example.com | Sam | Northside Bakery | 1043 | October 20 |
Each choice in it is there for a reason:
- Recipient and Email Sent are the two column names Google’s script looks for. Keep them exactly as written. Gmail’s merge lets you pick any column for the address, so it’s happy with Recipient too.
- FirstName, not First name. Gmail names each tag after its header. A header with a space or symbol gets a tag named by its position instead, like @A, which is easy to mix up.
- The list lives on the first tab. Gmail only reads the first tab, so keep notes and old lists on later tabs.
- Dates are typed as words. Gmail’s help says the contact data “can only contain text.” Typing “October 15”, or setting the column to Format > Number > Plain text, stops a date arriving as a number.
- Email Sent starts empty. The script writes the send time here. Gmail and the add-ons ignore it.
Then add your own columns. A column for anything that changes per person makes the message read as written to them. A first name alone rarely does that. Keeping a mail merge personal is about choosing those columns well.
Which route fits your send
Here’s how the options compare, with figures from each vendor’s own pages:
| Route | Cost | Daily limit | Personal subject line | What you get |
|---|---|---|---|---|
| Gmail’s built-in merge | Included on eligible Workspace plans | 1,500 recipients | No | Nothing to install, replies in separate threads |
| Google’s Apps Script sample | No cost | 100 on @gmail.com, 1,500 on Workspace | Yes | Works on any Google account, logs each send in the sheet |
| YAMM | Free plan, paid upgrades | 20 free, up to 1,500 paid | Yes | Gmail draft as template, tracking, splits large sends over days |
| Mailmeteor | Free plan, paid upgrades | 50 free | Yes | Works from Gmail or Outlook, tracking |
| Autocrat | Free | Docs and PDFs, not a send limit | n/a | One letter or PDF per row, can email them |
| Label Maker (Avery Label Merge) | Free trial, then paid | Print, not a send limit | n/a | Labels and envelopes from sheet rows |
The short version:
- Your Workspace plan has mail merge. Use the built-in one. It’s already there.
- You’re on free Gmail or Business Starter, sending under 100. Use Google’s script. It costs nothing.
- You send from a sheet every week and want to know who opened it. An add-on is worth its fee.
- You need paper. Autocrat for letters, a label add-on for envelopes.
Every email route here sends as you, from your Gmail address. That means Gmail’s own daily ceiling sits on top of the tool’s. Gmail and Outlook sending limits covers what happens when you cross one.
Route 1: Gmail’s built-in mail merge with a Sheet
Gmail can link your sheet straight into a new message. It comes with Business Standard and Plus, Enterprise Standard and Plus, Education Standard and Plus, and Workspace Individual. It isn’t on free @gmail.com accounts or Business Starter. Mail merge in Gmail shows how to tell whether yours has it.
- Compose in Gmail on a computer opens a new message.
- Use mail merge sits beside the To line. Switch it on.
- Add from a spreadsheet opens your Drive. Pick the sheet and click Insert.
- Gmail asks which columns hold the email, first name and last name. With the template, that’s Recipient and FirstName, and you can leave last name blank.
- Finish puts the sheet in the To line.
- Typing @ in the body lists a tag for every column, such as @Company and @InvoiceNumber.
A few things are different when the recipients come from a sheet. Google’s mail merge help page spells them out:
“If you added recipients using a spreadsheet, you can’t include “Cc” or “Bcc” recipients with your message.”
So nobody gets copied on a sheet-driven merge. The other limits apply as usual:
- The subject line is the same for everyone. Tags can’t go in subjects or in linked text.
- It sends when you press send. Scheduled send isn’t available with a merge.
- An unsubscribe link is added to the bottom of each email.
- Attachments are copied per person. Google’s example is 500 recipients with a 10 MB file using about 5 GB of storage. A Drive link costs nothing.
If a row has an empty cell for a tag you used, Gmail stops and asks for a default. “Hi there” is a common one. Filling the gap in the sheet works too.
Route 2: a mail merge script in Google Sheets
This is the answer to “How do I create a mail merge script in Google Sheets?” You don’t write one. Google publishes a Gmail/Sheets mail merge sample that’s free and works on any Google account. It’s maintained by Google and was written by Martin Hawksey, a Google Developer Expert.
Here’s how it works:
- Make a copy on Google’s page puts the sample spreadsheet, with the script attached, in your Drive.
- Your rows go in its sheet. The template above uses the same column names, so you can paste it in.
- A new Gmail draft becomes your template. Each detail goes in double braces, matching the header exactly.
- The spreadsheet now has a Mail Merge menu. Send Emails starts it.
- Google asks you to authorize the script the first time. On a work account, your admin may need to approve it.
- The script asks for your draft’s subject line. Paste it in and click OK.
A draft for the template above might read:
Subject: Invoice {{InvoiceNumber}} for {{Company}}
Hi {{FirstName}},
Invoice {{InvoiceNumber}} is due on {{DueDate}}. I've attached a copy.
If anything on it looks wrong, just reply and I'll sort it out.
Thanks,
Dana
The subject can carry placeholders here, which Gmail’s built-in merge can’t do. As each email goes, the script writes the time into Email Sent. If you run it again, it skips those rows. That makes it safe to stop and pick up the rest tomorrow. If a row fails, the error message lands in that cell instead. Clear it before the next run, or the row will be skipped.
Google’s page notes a few catches:
“Placeholders are case sensitive and must exactly match the column headers.”
So {{firstname}} won’t fill from a FirstName column. There are three more:
- Formatting. If you bold a placeholder, bold the braces too. Google says so directly.
- Emoji. A draft with emoji needs a one-line change to the code, and Google’s page shows which line.
- Filters. Rows hidden by a filter still get emailed. They just don’t get a timestamp.
Anything attached to the draft goes to every row. The limit is set by Google’s Apps Script quotas. That’s 100 recipients a day on a free @gmail.com account and 1,500 on Workspace.
Route 3: mail merge add-ons for Google Sheets
So what’s the best mail merge add-on for Google Sheets? It’s the one whose free tier or price fits how often you send. Two come up most, and both work from a sheet like the template:
- YAMM (Yet Another Mail Merge) uses a Gmail draft with
{{First name}}-style placeholders, the same idea as Google’s script. Its quota page allows 20 recipients a day free and up to 1,500 on a paid Workspace account. The limit resets on a rolling 24 hours. Its Marketplace listing says it splits sends over 1,500 across a few days. - Mailmeteor works from Gmail or Outlook. Its Marketplace listing offers 50 personalized emails a day free.
What the add-ons add over the script is mostly tracking, scheduling and a preview screen. Before you install one, look at the permissions it asks for. Mail merge tools goes through what each one is for.
Letters and PDFs in Google Docs
Google Docs has no merge button of its own. The usual route is Autocrat, a free add-on from New Visions Cloudlab. It creates “PDF or shared Documents from spreadsheet data,” one per row.
You write the letter once in a Doc, with each detail in double angle brackets, such as <<FirstName>>. Autocrat matches those to your sheet’s columns and makes a file for each person. It can also email each file as an attachment. That suits certificates, offer letters and statements, where each person needs a document of their own.
Labels and envelopes from Google Sheets
For printing addresses, Label Maker (Avery Label Merge) by Quicklution is the common pick. Its listing says it does “Mail Merge envelopes, labels, QR Codes and Barcodes from Google Docs and Google Sheets.” There’s a free trial, then a paid license.
Add address columns to your sheet: Street, City, State and ZIP. The add-on lays the rows out on an Avery label size or an envelope like a #10, and builds a Doc ready to print. When you print, set the scale to 100% or “actual size.” “Fit to page” shrinks the layout and the text slides off the labels.
Before the first real send
Whichever route you take, a test saves you from the one mistake you can’t undo:
- Put yourself in row 2. Send to just that row first, and read it as the recipient would.
- Scan for empty cells. A blank FirstName reads as “Hi ,”.
- Count the rows. Check they fit under the day’s limit, with room for your normal mail.
Sometimes, looking at the sheet, the merge turns out to be the wrong tool. Twelve rows that all need a different paragraph are twelve emails. When a mail merge is the wrong tool helps you tell.
After the sheet has done its job
The replies come back as separate threads, one per person. A sheet of forty invoices can mean forty conversations by Thursday. A few have questions, most say thanks, and one bounces. Handling the replies to a mail merge covers working through them.
That part is where Point helps. Point doesn’t send mail merges; your sheet and Gmail do that. When the replies land, Point reads each one. The client asking about line 3 of invoice 1043 is at the top of your feed, with a reply drafted for you to check. The thank-yous wait below. What Point does for you shows a full day of it, and how it works shows the steps.
Common questions
How do I do a mail merge with a spreadsheet?
Put one person per row and one detail per column, with a column for email addresses. Write the message once, with a placeholder where each detail goes. A mail merge tool then sends one copy per row with the details filled in. In Google Sheets, that tool can be Gmail’s built-in merge, Google’s free Apps Script sample, or an add-on.
Is there a Google version of mail merge?
Yes. Gmail has a built-in mail merge on eligible Workspace plans, and it can link a Google Sheet directly. Google also publishes a free Apps Script sample that merges from Sheets on any Google account. Google Docs has no merge button, so letters and labels need an add-on.
What is the best mail merge add-on for Google Sheets?
YAMM and Mailmeteor are the most widely used for email. YAMM’s free plan covers 20 recipients a day, and Mailmeteor’s covers 50. For letters and PDFs, Autocrat is free. For labels and envelopes, Label Maker (Avery Label Merge) is the usual choice.
How do I create a mail merge script in Google Sheets?
Copy Google’s Gmail/Sheets mail merge sample from its developer site. It brings the script with it. Fill in the Recipient column, write a Gmail draft with {{Column name}} placeholders, then choose Mail Merge > Send Emails in the sheet. It sends up to 100 recipients a day on a free account and 1,500 on Workspace.
Can I personalize the subject line from a Google Sheet?
Not with Gmail’s built-in merge, which keeps the subject the same for everyone. Google’s Apps Script sample and add-ons like YAMM fill placeholders in the subject too.
Can I Cc someone on a mail merge from Google Sheets?
Not with Gmail’s built-in merge. Google’s help page says a merge with spreadsheet recipients can’t include Cc or Bcc recipients.