Mail Merge Gmail: Send a Newsletter From a Google Sheet

Mail merge Gmail is Google's built-in way to send one personalized email to many people at once: each recipient gets their own copy, with tags like @firstname filled in from your contacts or a Google Sheet. It works only on certain paid Google Workspace plans, and it caps you at 1,500 recipients a day. The method: keep your list in a Sheet, turn on mail merge in the compose window, insert merge tags, dress the message with a layout, and send.

Who can use mail merge in Gmail

Eligibility is the first wall, so check it before you build anything. Google's help page says to sign in to an account with an eligible Google Workspace plan, and lists exactly these: Workspace Individual, Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Standard and Education Plus ^[1]. A free @gmail.com account is not on that list. Neither is Business Starter.

Mail merge also replaced the older multi-send mode, so guides that tell you to click multi-send describe a button that no longer exists. If you are on an eligible plan, you will see a Use mail merge icon to the right of the To line when you compose. If you do not see it, check your plan against the list above.

One more rule matters for a newsletter. Mail merge cannot send from a different domain, and Google says that includes secondary domains and domain aliases you own. Your newsletter goes out from the mailbox you are signed in to. Plan your sender address around that.

Mail merge Gmail, step by step from a Google Sheet

A Google Sheet is the natural list for a small newsletter. Every column header becomes a merge tag, so a column called firstname becomes @firstname in the email. Keep headers to plain letters and numbers: Google says a header with special characters gets identified by its position instead, so the first column becomes @A. Email addresses with special characters are treated as invalid. The contact data must sit in the first tab of the Sheet and contain only text.

Here are the steps exactly as Google documents them:

1. On your computer, open Gmail and click Compose at the top left (or open an existing draft).
2. On the right of the To line, click Use mail merge.
3. Turn on Mail Merge.
4. Click Add from a spreadsheet, select your Sheet and click Insert. In the window, pick the columns that hold Email and First name (Last name is optional), then click Finish. The Sheet is added to the To line.
5. In the message body, type @ and pick a merge tag. The tags come from your column headers.
6. Press Enter to insert the tag, finish the message, and send.

Without a Sheet, you can add people straight to the To line and use the default tags @firstname, @lastname, @fullname and @email. Gmail splits a name like Lisa Rodriguez into first and last name when the person is not in Google Contacts. A contact label in Google Contacts drops a whole group into the To line at once.

When a recipient is missing a value for a tag you used, Gmail shows an error. You can type a default value right in that error, or remove the incomplete rows. If a linked Sheet throws errors, Google's fix is to copy the data, create a new Sheet, and use Paste special, Values only, to strip hidden formatting.

What you cannot personalize

Merge tags do not work in subject lines, in hyperlinked text, or in plain-text mode. Mail merge also cannot be used for replies, forwards, scheduled sends, or confidential-mode messages. So your subject line is the same for everyone, and you press Send yourself on the day. Write it accordingly.

Make it look like a newsletter with Gmail layouts

Plain Gmail text reads like a personal note. For something closer to a branded newsletter, Gmail has layouts, which Google describes as a way to send professional-looking emails to a large audience ^[2]. Google lists the same set of Workspace editions for layouts as for mail merge.

To set them up, click Compose, then Layouts at the bottom of the window (check More options if you do not see it). The first time, click Default styling and set your logo, colors, fonts, footer details such as business name and address, and social links. Save the changes. They apply across the default layouts.

To build a reusable design, pick a layout from Default layouts or My layouts and click Edit layout. You can move text boxes, buttons and images, add a theme, and preview mobile, tablet and desktop views before you click Insert. Saved layouts live in Google Drive, so a teammate can edit them with you.

If you searched for a newsletter template in Google Docs, consider this the inbox version of one. Draft your words in Docs if that is where you think best. Build the email itself in a layout, which is made for the compose window.

A mini example: 2,000 names in one Sheet

Illustration, with round invented inputs. A neighborhood bakery keeps 2,000 customer addresses in a Sheet with columns for firstname and email. The owner is on Business Standard, so mail merge is available.

Google allows up to 1,500 recipients in the To line per message, and 1,500 mail merge recipients per day. That cap is shared with regular email: once the combined total of regular and merged sends hits 1,500, mail merge stops until the daily quota resets. For most work accounts the total daily limit is 2,000, and the last 500 are reserved for ordinary email.

So the bakery splits the list. Day one, rows 1 to 1,500 go out. Day two, the remaining 500. If the owner also sent 300 ordinary emails on day one, only 1,200 merged sends fit that day. Attachments are copied into every recipient's message, so a 10MB file sent to 500 people uses about 5GB of storage. Link to files instead.

How to send mass email in Gmail without Workspace

On a free Gmail account there is no mail merge. Google states that standard Gmail accounts have a daily send limit of 500 outgoing messages. The only built-in route is one message to many people, typically with the list in Bcc or a contact label. Everyone gets the same unpersonalized copy, and nothing adds an unsubscribe link for you.

That route also gives you nothing for Google's bulk rules. Its email sender guidelines, which apply to anyone sending to personal Gmail accounts, require authentication and a low spam rate, and list using an @gmail.com domain as the display name for bulk email among deceptive display-name practices ^[3]. Keep the display name to your real name or organization.

Where sending a newsletter from Gmail breaks

Mail merge is a real tool for an announcement to a few hundred people who know you. It stops being enough at specific points.

The daily cap

At 1,500 recipients a day, any list past that size takes several days per issue. Growth turns every send into a scheduling chore.

Unsubscribes you cannot see

Gmail does add a unique unsubscribe link to each mail merge email, and it emails you when someone unsubscribes. But Google says you cannot get a list of all unsubscribed recipients. People who unsubscribe can still receive your mail sent without mail merge, or from another account in your domain. Keeping your Sheet clean is on you.

No sign-up form, no archive, no bounce cleanup

Mail merge sends to a list you already have. It does not collect subscribers, host past issues on the web, or describe removing addresses that bounce. Each of those becomes a manual job.

The rules for bulk mail

Google requires every sender to Gmail accounts to set up SPF or DKIM and keep the spam rate in Postmaster Tools below 0.3%. Past 5,000 messages a day to Gmail accounts, marketing messages must support one-click unsubscribe with a visible unsubscribe link. US law adds its own floor: the FTC's CAN-SPAM rule defines a valid physical postal address as a current street address or a registered Post Office box or private mailbox, and bars making people pay a fee, give anything beyond their email address and opt-out preferences, or do more than send a reply email or visit a single web page to opt out ^[4].

The honest threshold: once you want a sign-up form, a public archive, or a list past about 1,500, the Gmail way costs more time than it saves. A newsletter tool handles those parts as its basic job. MailerLite, for example, walks you through the full send: recipients, subject, blocks, mobile preview, a test, then send or schedule. Creators who want subscribers and an archive in one place can read how Kit runs a newsletter and its funnel or how Beehiiv handles posts, the site and growth.

For a full comparison of what each one covers, see our guide to email newsletter software. If you are still shaping the first issue, start with how to start a newsletter.

The bottom line

Gmail's mail merge is a fair free start if you already pay for an eligible Workspace plan: a Sheet as the list, merge tags for names, a layout for the look, and up to 1,500 recipients a day. It is not a newsletter system. Unsubscribes stay hidden in notifications, sign-ups and archives do not exist, and a free @gmail.com account cannot use it at all. Send your first few issues this way if it fits. Move to a newsletter tool the day the list, the form or the archive starts to matter.