How to Send Personalized Emails with Mail Merge in Gmail

Learn how to send personalized email messages in bulk using mail merge in Gmail . You can send rich HTML emails with unique file attachments and track your email opens and clicks on links.

Mail Merge for Gmail helps you send personalized messages to one or more email recipients. You can write a single draft email in Gmail, specify the list of email recipients in a Google Sheet and the Mail Merge program will automatically send customized emails to all these addresses in one go.

Mail Merge is a popular feature of Microsoft Outlook and, with the help of Google Scripts, we can easily perform mail merge in Gmail and G Suite accounts as well.

Gmail Mail Merge is powerful, popular (500,000+ users) and packed with useful features.

You can insert different (unique) file attachments from Google Drive for each recipient, the emails can be written in plain text or formatted in rich-text HTML and the email opens can be tracked so you’ll know if an email has been read. You can also schedule merges and send your emails later at your preferred date and hour.

Mail Merge - Getting Started

Watch this Mail Merge video tutorial to learn more.

How to do Mail Merge in Gmail

To get started, install Mail Merge for Gmail. You can either add the merge add-on in your own Google Account or, if you are a GSuite admin, you can install Mail Merge for all users in your G Suite domain.

After the add-on is installed, follow these steps to get started:

  1. Go to the Google Spreadsheet, click the Add-ons menu and you’ll see a new menu called Mail merge with Attachments.
  2. Click the Create Merge Template menu to clone the blank mail merge template in your Google Spreadsheet. It contains the mandatory columns - like First Name, Email Address, etc. - but you can add more columns.
  3. Go to the Import Google Contacts menu to fetch any existing contact groups from Google Contacts into Mail Merge. This saves time but you can also write the first name, email addresses and other details of the recipients manually in the Mail Merge sheet.
  4. If you wish to add unique attachments for your recipients, you can add them in the File Attachments column. Go to Google Drive, right-click a file and choose Get Link to copy the URL of that file that can paste into the sheet. You can include multiples files too but remember to separate the file URLs by comma.
  5. When you run mail merge, it will send all the mails immediately. However, you also have an option to schedule emails and the program will automatically send them later. To schedule an email, go to the Scheduled Date column and insert the date and time when you wish to schedule that particular email. Use the dd/mm/yyyy hh:mm format.

Create the Mail Merge Template

Go to your Gmail or Google Inbox account and create a new draft message. You can include one or more variable fields in the email message using the {{field name}} notation and these will be replaced with the actual values from the sheet when the emails are sent. Let me explain.

Say you want to send an email to a group where the content of the message body is mostly similar except a few fields like salutation, first name and city that will be unique for each message. What you need to do is add columns in the sheet for each of these variable fields. And in your Gmail Draft, your can refer to these variable fields as {{First Name}}, {{City}} and so on.

Mail Merge - Gmail Template

You can include file attachments in the draft message and they’ll be sent with every email. You can also include inline images, animated GIFs, and make your message stand out with rich-text formatting.

Now that our template is ready, switch to the Mail Merge sheet and choose Run Mail Merge to start sending emails. Choose the Gmail draft that you created in the previous step and hit the Run button. The add-on will instantly send emails to addresses where the Scheduled Date column is blank while others would be put in the queue and will be sent automatically at your preferred date and hour.

While mail merge with Gmail is easy, you should always test your merge before sending the email blast to a large group. Just have a single data row in the spreadsheet and put your own email addresses in the Email Address column. Run Merge as before and see your Gmail Sent Items folder to make sure that your outgoing emails are as expected.

Please refer to the Mail Merge Documentation for answers to common questions.

Amit Agarwal

Amit Agarwal

Google Developer Expert, Google Cloud Champion

Amit Agarwal is a Google Developer Expert in Google Workspace and Google Apps Script. He holds an engineering degree in Computer Science (I.I.T.) and is the first professional blogger in India.

Amit has developed several popular Google add-ons including Mail Merge for Gmail and Document Studio. Read more on Lifehacker and YourStory

0

Awards & Titles

Digital Inspiration has won several awards since it's launch in 2004.

Google Developer Expert

Google Developer Expert

Google awarded us the Google Developer Expert award recogizing our work in Google Workspace.

ProductHunt Golden Kitty

ProductHunt Golden Kitty

Our Gmail tool won the Lifehack of the Year award at ProductHunt Golden Kitty Awards in 2017.

Microsoft MVP Alumni

Microsoft MVP Alumni

Microsoft awarded us the Most Valuable Professional (MVP) title for 5 years in a row.

Google Cloud Champion

Google Cloud Champion

Google awarded us the Champion Innovator title recognizing our technical skill and expertise.

Email Newsletter

Sign up for our email newsletter to stay up to date.

We will never send any spam emails. Promise.