Google Sheets now integrated with mail merge in Gmail

25/07/2023

Table of contents

What’s changing

Last year, we made it easier to send individual emails to many recipients with the launch of multi-send in Gmail, and introduced the ability to personalize multi-send emails with mail merge tags like @firstname and @lastname.

Today, Google is pleased to announce that mail merge will support Google Sheets in the web version of Gmail. This integration will allow you to associate a Sheet with up to 1,500 recipients and use any column of data from your Sheet as a mail merge tag.

Google Sheets has been integrated with Mail Merge in Gmail 1

Who’s impacted

End users

Why it’s important

With mail merge, you can send more engaging and personalized marketing emails to a wider audience from Gmail on the web.

Additional details

With this update, mail merge will completely replace multiple sending. Google is also moving the mail merge icon from the main compose toolbar at the bottom of your email draft to the top right corner of the compose window. You can still use the mail merge feature without linking the Sheet, using the built-in merge tags: @firstname, @lastname, @fullname and @email.

Like multiple submissions, mail merge contains a unique unsubscribe link for each recipient by default. Recipients who unsubscribe from your emails are automatically excluded from future mail merges you send.

Getting started

Admins
- For customers Google Workspace Enterprise Standard, Enterprise Plus, Education Standard and Education Plus, by default, mail merge is restricted to internal recipients.
- For customers Google Workspace Business Standard and Business Plus, mail merge is available to external recipients by default.
- For all Google Workspace editions, you can turn mail merge ON for external recipients at the OU or Group level.
- Visit the Help Center to learn more about managing Gmail settings for your users, and customizing access policies for different organizational units or groups.
End users
- To link your Sheet to a draft in Gmail:
  - Turn on mail merge using the icon in the top-right corner of a new compose tab.
  - Click Add from a spreadsheet and select which Sheet you want to use for recipient data.
    - The Sheet must contain at least one column of email addresses and one column with recipient names.

Google Sheets has been integrated with Mail Merge in Gmail 2

Note: Your recipient data must be in the first tab of the Sheet.

Note: Users are limited to 1,500 mail merge recipients or messages per day, and you can't use Cc or Bcc when recipients are added from a Sheet.
Next, you will see a Finish linking spreadsheet dialog:
- Choose the columns that contain recipients’ email addresses and names.
To insert merge tags to your draft:
- Type “@” in your draft to show a list of available merge tags.
- Every valid column in the first tab of your Sheet should be available as a merge tag.
- Insert the desired merge tag by pressing Enter or by clicking on the tag.
- Note: Merge tags can’t be used in the subject line or in links.
Visit the Help Center to learn more about Mail Merge in Gmail.

Rollout pace

Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) starting on June 27, 2023
Scheduled Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on July 19, 2023

Availability

For Google Workspace Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Standard customers, Education Plus and Non-Profit Organization

For more detailed product information or to need technical support, you can contact Gimasys - Premier Partner of Google in Vietnam at the following information: