How to mail merge from Google Sheets to Gmail

Updated October 29, 2026

Short answer

Make a sheet with one row per person and an Email column, then connect it to a mail merge tool. Each column becomes a tag you can drop into your message. Gmail’s built-in merge reads the first tab of a sheet on eligible Workspace plans. Mergeline reads a pasted Sheets link on any Gmail account.

Why Google Sheets works so well

A spreadsheet is already a mail merge list. Each row is a person, and each column is a detail you can use in the email. You can sort, filter and fix it before you send, and several people can edit it at once.

Sheets is also where many lists already live: sign-up forms, event registrations, class rosters and lead lists from a CRM export. Connecting the sheet saves you from copying and pasting a single address.

Set up the sheet the right way

Most mail merge errors start in the sheet. Spend five minutes here and the rest goes smoothly.

Put column names in row 1: Email, FirstName, Company, and so on.
Keep everything on the first tab. Gmail’s own tool only reads the first tab, and it reads values as plain text.
Use one email address per cell. A cell like “jane.doe@example.com, john.doe@example.com” breaks most tools.
Fill a FirstName column, even if you have to split a full name. “Hi Jane” beats “Hi Jane Doe”.
Add a column for anything you want to change per person: a link, a date, a price.

Email	FirstName	Company	Meeting
jane.doe@example.com	Jane	Acme	Tuesday 10am
john.doe@example.com	John		Wednesday 2pm
sam.lee@example.com	Sam	Beta Labs	Thursday 9am

John has no company. Decide now what his email should say, and use a fallback or a conditional sentence so it still reads well.

How to mail merge from Google Sheets with Mergeline

Copy the sheet link. Open the sheet in Google Sheets and copy its link from the address bar.
Paste it into Mergeline. Start a campaign, choose Google Sheets and paste the link. Mergeline asks once for permission to download that sheet as a CSV, and nothing else.
Check the import. Mergeline finds the email column by name, removes duplicates and invalid addresses, and shows how many people it kept.
Use the columns as tags. Each column is now a tag. {{Company}} pulls from the Company column, and {{FirstName|there}} falls back to “there” when the cell is empty.
Preview the tricky rows. Look at people with empty cells and long names in the preview before you send.
Send. Press send. Emails go out one by one from your Gmail, and you can watch progress in the report.

With Gmail’s built-in mail merge

On Workspace Individual, Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Standard and Education Plus, you can pick a Google Sheet as the recipient list in a mail merge email and insert its columns as fields (Google: Send personalized emails with mail merge in Gmail).

Three rules trip people up. The data has to be in the first tab. You cannot add any Cc or Bcc when you use a spreadsheet. And merge fields do not work in the subject line, so every person gets the same subject.

If Gmail says it cannot open your sheet, check that the list is on the first tab, that you own or can open the file, and that the cells hold text, not formulas pointing at other files. More in why Gmail mail merge can’t open your sheet.

With a Sheets add-on

Add-ons such as YAMM run inside Google Sheets. You install it from the Workspace Marketplace, draft the email in Gmail, and start the merge from a Sheets menu. YAMM’s free plan sends 20 emails a day, and a review notes it “used to be 50” (Capterra: YAMM reviews).

The trade-off is access. YAMM asks to “read, compose, and send emails from your Gmail account” and to see and edit all your sheets (YAMM: permissions needed). That is normal for add-ons, but worth knowing before you click Allow.

Keep the sheet and the campaign in sync

Lists change. New people sign up after you send, and someone fixes a typo in row 40. With most tools you rerun the merge and hope it skips the people who already got the email.

Mergeline Pro can watch the linked sheet: new rows added later get the email automatically, and people who already got it are skipped. On Free, import the new rows as a fresh list. Pro is $12 a month or $99 a year.

Common problems and fixes

Problem	Likely cause	Fix
Names show as “Hi ,”	Empty FirstName cells	Add a fallback: {{FirstName\|there}}
A tag shows up raw in the email	The column name changed	Match the tag to the header in row 1
Fewer people imported than rows	Duplicates or invalid addresses	Check the import summary and fix the rows it skipped
Dates look wrong	The cell holds a formula or a date format	Type the date as text the way you want it to read

Fix the sheet, not the email. If you correct a row in the sheet, the next import picks it up, and you keep one source of truth for the whole team.

Questions

Does the sheet need to be shared publicly?

Not always. Mergeline first tries to read the sheet with your own Google sign-in in that browser. If it cannot, it asks you to share the sheet as “Anyone with the link can view”, or to download it as a CSV and drop the file in instead.

Can I use several tabs?

Gmail’s built-in tool reads only the first tab. In Mergeline, put the list you want on its own sheet or export that tab as a CSV.

Can the subject line use sheet columns?

Not with Gmail’s built-in merge. With Mergeline, yes: {{Company}} works in the subject just like in the body.

What if two rows share an email address?

Most tools drop the second row. If you need both (two kids, one parent), merge them into one row first, for example a “Children” column. See mail merge and duplicate addresses.

How many rows can I send to?

As many as Gmail allows in a day: about 500 on a free account, and 1,500 mail merge recipients on Workspace (Google Workspace: Gmail sending limits).

Sources

Facts checked October 29, 2026. Google and other vendors change their limits and prices, so check the source before you rely on a number.

Mergeline does this from your own Gmail. Free for 60 emails a day with merge tags and no branding. Pro is $12 a month or $99 a year for follow-ups, scheduling and attachments.

Add to Chrome, free See pricing