A Gmail mail merge sends one personalized email to every row of a Google Sheet. You write a template with fields such as {{first_name}}, an add-on fills them in for each row and sends from your own Gmail, and nobody sees anyone else's address, which is the reason to use it instead of BCC. It takes about 45 minutes the first time. It's a good tool for a one-time notice and a workable one for a first outreach batch. It stops working as outreach once you need follow-ups, replies and a daily pace.
Below are the steps with times, then the four things a merge does not do, then what to use when you reach them.
Step 1: Build the sheet (10 minutes)
One row per person, one column per thing you'll put in the email. Hollis runs drone roof inspections for warehouse owners in Phoenix. His sheet has these columns: Email, FirstName, Company, Hook, Status. The Hook column is the part that makes each email read like a person wrote it: "your Buckeye Road building has a flat roof over 90,000 square feet," pulled from a county record he looked up. Fill in the Hook by hand for every row. Twenty rows is plenty for the first run.
Before you merge, clean the sheet. Delete duplicate rows, delete anyone you've emailed before, and check each address looks real. A bounce rate of more than a few in a hundred damages your sending, as the bounce rate guide explains.
Step 2: Write the template (10 minutes)
Write the email as a normal Gmail draft with the field names in double curly brackets, matching your column headers exactly. Put a field in the subject too if it helps: "your roof on Buckeye Road." Keep it plain text. Add your signature, a mailing address and a one-line opt-out. Check what you'll do about empty cells: if a Hook is blank the email will say "Hi ," or a gap in the middle of a sentence. Fill every cell or delete that row.
Step 3: Install an add-on (5 minutes)
Mail merge in Gmail runs through an add-on or a script attached to your sheet. When you install one, Google asks you to approve access to read and send mail from your account. That's a lot of access. Check who published the add-on, read the permissions screen, and when you're done with it, remove its access under your Google Account's security settings. If your Google Workspace plan includes Gmail's own multi-send option, use that instead, since it comes from Google. Whichever you choose, the merge sends as you, from your address.
Step 4: Preview and send a test (5 minutes)
Preview three different rows and read each one out loud. Then send a test to a second address you own and open it on your phone. Look for the fields that didn't fill, odd spacing and links that were added without you asking. If the test lands in spam or in Promotions, stop and fix that before sending anything to real people. Whether your sending address is free Gmail or Workspace can matter here.
Step 5: Send in a small batch (5 minutes, then wait)
Send to 20 people, not all 200. Most add-ons will cheerfully send everything at once if you let them, and Google's published limits are far above what's sensible for a new cold sender. Google's help page puts the personal-account ceiling at 500 emails a day, and its Workspace limits page lists 1,500 a day for mail merge specifically, but a safe start is 20 to 50 a day. How to ramp is in warming up a Gmail account. If you do hit a wall, here is what to do when Gmail says the daily limit is exceeded.
Step 6: Read the replies yourself (10 minutes a day)
Replies come into your normal inbox mixed with everything else. Open the sheet each morning, mark the Status column for anyone who replied, and handle their answer. That manual step is where the trouble starts.
What a mail merge does not do
| Thing that breaks | In a mail merge | With one-to-one sending |
|---|---|---|
| Daily pace | You decide and keep to it | A daily cap is built in |
| Stop on reply | Depends on the add-on; test it | A reply ends the follow-ups |
| Reading replies | You, in a shared inbox | Each reply is sorted: interested, no, remove me |
| Follow-ups | By date, for everyone | By each person's situation |
The one that costs people customers is the second. If the follow-up goes out on day four to someone who replied "not interested" on day two, you've created a complaint. And opt-out requests need to be honored quickly, which in a spreadsheet means you remember to type them in. Cold email opt-out wording and routine covers that side.
One-to-one sending from your own Gmail
The alternative to a merge is a worker that sends each email as its own message, one at a time, from the same Gmail. Rocketship does this: it finds the buyers, writes each email from what it knows about that person, sends within a daily cap, reads replies as they arrive, ends a person's follow-ups when they answer, and follows up on its own schedule. The mail still goes out from your address. You don't maintain a sheet or mark a status column. The outreach tool for people who do not do sales describes the difference in daily work, and the AI workers page shows the setup.
A 20-email test before you send 200
Whichever way you send, run the same test. Twenty hand-checked rows, sent over two days. After a week, count: bounces (aim for zero or one), replies (any kind), interested replies, and anything in spam from your test addresses. If two of those look wrong, fix them before you scale. One bad sheet sent to 200 people does more harm than ten careful batches of 20 ever could. For the overall method of getting started from your own account, how to send cold emails from Gmail is the longer version.
A mail merge is a good place to learn what your outreach needs. Rocketship finds the buyers, emails them from your own Gmail, follows up, and books the meeting on its own. Plans that get you customers start at $24.99 a month (Launch), and every monthly plan starts with a 7-day free trial, card required.