How to send a mail merge with google sheets

3 years ago

Want to send a mail merge with google sheets? You are in the right place! This article will help you to learn how you can send a mail merge with google sheets. Mail merges make it easier to send an email with multiple recipients. It makes it happens in just a matter of seconds and so can be useful for email marketing campaigns.

Mail merge:

It is a programmed process that enables you to insert the details of recipients into an email template. This means you don’t have to manually enter every individual recipient, sending mass emails is now effortless and your work becomes easier now.


It is software that allows you to use mail merge in your Gmail account. GMass is used widely by many users due to its excellent functioning and remarkable results.

Let’s have a look at how you can use GMass to send a mail merge with google sheets.

Spreadsheet formatting:

To get the best results it is important to create proper formatting. The spreadsheet should be created in plain text so that it can be used by GMass.

It is advised to put column names such as first name and email address in the first row. No spaces or special characters should be used. The data should start from the second row. One column should be of email addresses that would be automatically be used by GMass as your recipient address column.

Login to your Gmail account:

The next step to use mail merge is to log in to your Gmail account.

Connecting spreadsheet and GMass:

The first way to upload contacts is to click the sheets button. A pop-up window will open and you can select the google sheets to now import the recipients.

Another way is to compose your email and select the GMass button on the top right corner to select the sheet.

Select worksheet:

If you are having multiple worksheets in your spreadsheets then you can select any specific one from the dropdown menu.

Keeping duplicates is optional:

The duplicate recipients can be filtered out if you wish to. You can also send duplicate emails if it is required. This is completely optional.

Sending to specific rows or all rows:

The rows here can be filtered according to your choice. It can be filtered via column names or by setting filter criteria in name pairs.

Let’s Merge:

Here the mail merge will be sent either at the moment or later, depending upon how you have scheduled the email.

To summarize:

Mail merges are a powerful and very effective tool to run email campaigns and to accelerate your conversations. By this, you can easily send and manage your emails with automated functions available. GMass allows you to use google sheets as your source of recipients. Mail merges are far most the best option to send documents to a group of recipients and interestingly you can personalize each of them.

Leave a Reply