Mail Merge from Google Sheets to Gmail: Columns, Tags, Fallbacks

Updated

To mail merge from Google Sheets to Gmail, put one contact per row with a header row (email, first_name, company and any notes), clean duplicates and stray spaces, then connect the sheet. On eligible Workspace plans, use Gmail's "Add from a spreadsheet"; otherwise paste the rows or a CSV into an extension. Use merge tags that match the headers, with fallbacks for empty cells.

Google Sheets is where most small businesses already keep their contact lists. Getting those rows into Gmail as personalised emails takes three things: a well-structured sheet, a way to connect it to Gmail, and merge tags that handle missing data. Most mail merge mistakes come from the sheet, not the email, so that’s where to start.

How to set up your sheet for a mail merge

One row per person, one header row

Row 1 holds the column names. Every row below it is one contact. Don’t merge cells, add subtotals or leave blank rows in the middle of the list.

Keep the contact list on the first tab. Gmail’s built-in mail merge only reads the first tab, and keeping to that habit avoids exporting the wrong one.

Which columns to include

Column header Example What it’s for
email sarah@harlowandco.co.uk Required. One address per cell.
first_name Sarah The greeting. Keep it separate from the surname.
last_name Jones Optional; rarely needed in the email itself.
company Harlow & Co Mentioning the business by name.
role Marketing manager Tailoring the angle of the email.
city Leeds Local relevance, such as delivery areas.
notes Met at the Leeds trade show in October Anything specific you know about this person.

Short, lower-case headers without spaces or symbols are the safest. They become your merge tags, and Google’s help page says headers with special characters have to be referenced by column position (such as @A) instead of by name.

The notes column is the most useful one and the most often skipped. A line such as “asked about gluten-free options at the farmers’ market” is what turns a template into an email someone wants to answer. Our guide to personalising cold emails with AI goes further into which columns are worth collecting.

Clean the data before you merge

A design agency exporting 200 contacts from an old CRM will usually find a mix of “SARAH”, “sarah”, “Sarah Jones” and blank cells. Fix these in the sheet, not in each email.

Remove duplicates and stray spaces

Google Sheets has both built in. Select the data, then go to Data > Data cleanup:

  • Remove duplicates lets you choose which columns to compare. Compare on the email column only, so the same person with two spellings of their company isn’t kept twice.
  • Trim whitespace removes leading, trailing and repeated spaces. A trailing space after an email address is a common reason for a send to fail.

If you want to keep the original data, the TRIM function does the same thing in a new column: =TRIM(B2).

Split full names into first names

If you only have a “name” column with full names, add a first_name column and use:

=INDEX(SPLIT(B2, " "), 1)

Then check the results by eye. Names such as “Dr Ahmed Khan” or “Mary-Jane O’Neill” need fixing by hand, and a sheet of 200 rows takes a few minutes to scan.

Fix capitals

Names typed in capitals or all lower case look careless in a greeting. The PROPER function capitalises the first letter of each word, but it turns “McDonald” into “Mcdonald”, so check the output rather than applying it blindly.

Remove addresses that will bounce

Delete rows with obvious typos (gmial.com, hotmail.co), and think twice about role addresses such as info@ or noreply@. Bounces count towards your daily allowance and, in large numbers, can get your account blocked from sending for a day. Our guide to Gmail sending limits explains how.

Two ways to mail merge from Google Sheets to Gmail

Option 1: Gmail’s built-in “Add from a spreadsheet”

If your Workspace plan includes Gmail’s mail merge (Workspace Individual, Business Standard and Plus, Enterprise Standard and Plus, Education Standard and Plus), you don’t need anything else:

  1. Open a new draft in Gmail.
  2. Turn on mail merge using the control beside the To field.
  3. Click Add from a spreadsheet and select your sheet.
  4. Choose the email column and the first name column, plus last name if you want it, then click Finish.
  5. Type @ in the body to insert tags, including any extra columns from your sheet.

Google’s help page lists the restrictions: up to 1,500 recipients a day, no merge tags in the subject line, no Cc or Bcc when you send from a spreadsheet, and no scheduled sending or follow-ups. For a one-off email to a list that fits within those rules, this is the simplest option.

Option 2: Paste the rows into an extension

On a free @gmail.com account, on Business Starter, or when you need follow-ups, an extension does the sending through your Gmail account instead.

With Replyable you don’t have to connect the sheet at all. Select the rows in Google Sheets including the header row, copy them, and paste them into the side panel in Gmail. The email column is detected automatically, and a “name” column gives you a {{first_name}} tag without any setup.

If you’d rather use a file, download the tab from Google Sheets with File > Download > Comma-separated values (.csv) and upload it. The CSV route is useful when you want to keep a fixed copy of exactly what you sent.

Merge tags and fallbacks

A merge tag is a placeholder that is replaced with the value from that person’s row. In Replyable, tags use double curly brackets and match your column headers:

Hi {{first_name}}, I saw {{company}} has opened a second shop in {{city}}.

Fallbacks for empty cells

Some rows will always be missing data. A fallback is the text used when the cell is empty:

Hi {{first_name|there}},

Sarah’s email starts “Hi Sarah,”. A row with no first name starts “Hi there,”.

Write fallbacks that keep the sentence correct. A tag in the middle of a sentence is harder:

I saw {{company|your business}} is hiring.

That works. But “I saw {{city|your area}} has a new market” reads oddly when the fallback is used. If a sentence only works with real data, either fill the column for everyone or move that detail into a per-person line you can leave out.

Typos in tags

If you type {{compnay}} and there is no column with that name, the worst outcome is 200 emails that literally say “{{compnay}}”. Replyable blocks sending when a tag doesn’t match a column and has no fallback, so you find out before anyone else does. Gmail’s built-in option shows an error when a recipient is missing data for a tag.

Check before you send

  • Preview a few rows with missing data. Look at the contacts with blank cells, not just the complete ones.
  • Send yourself a test. Read it on your phone.
  • Check the count. If your sheet has 212 rows and the tool says 198 contacts, find out why. Usually it’s duplicates or invalid addresses that were removed, which is what you want.

The extension’s review step shows each contact’s subject and body exactly as they’ll receive it, and removes duplicates, invalid addresses, role addresses, domains with no mail server, and previous unsubscribes and bounces before sending.

A worked example

A UK bakery wants to write to 140 cafés about its wholesale range. The sheet has columns email, first_name, cafe_name, area and notes. Forty rows have notes from the owner’s visits, such as “uses oat milk, asked about vegan bakes”. The rest are blank.

The email uses {{first_name|there}}, {{cafe_name}} and {{area}}. The forty rows with notes get a specific opening line about what the owner discussed; the other hundred get the standard opening. Every row has cafe_name and area filled in, because those tags sit in the middle of sentences and don’t read well with a fallback.

The bakery sends from a free Gmail account, so 140 emails sit comfortably within the 500-a-day limit, with one follow-up a week later. Daily limits and follow-ups by plan are on the pricing page.

When your sheet is ready, you can install Replyable and paste the rows straight into Gmail. For a broader overview of the options, see our guide on how to mail merge in Gmail.

Questions people ask

Can I mail merge from Google Sheets to Gmail without an add-on?

Yes, if your Google Workspace plan includes Gmail's mail merge (Business Standard and above, Workspace Individual, and some Enterprise and Education plans). Turn on mail merge in a draft and choose "Add from a spreadsheet". Free @gmail.com accounts need an extension or add-on.

Which tab does Gmail read from my sheet?

Google's help page says the contact data must be on the first tab of the spreadsheet and contain only text.

What happens if a cell is empty?

In Gmail's built-in mail merge you get an error and can enter a default value. In Replyable you write the fallback into the tag, such as {{first_name|there}}, and a tag with no matching column and no fallback blocks sending.

Should I use full names or first names?

Keep a separate first name column. "Hi Sarah" reads naturally; "Hi Sarah Jones" reads like a mail merge.

Sources