Mail Merge Tutorial

Follow these simple steps to send your first emails with Mail Merge.
First, make sure you have installed Mail Merge for Gmail from the Google Workspace Marketplace. Once installed, let's see how to personalize and send your first emails.
A short video to cover the basics of Mail Merge for Gmail

Personalize your email content

With Mail Merge for Gmail📣, you can change the content of each email received by each recipient. This is what we call personalization.

Start with the Google Sheet content

The idea is simple, in your Google Sheet, each row will represent an email. The minimal requirement to send a campaign is to have a column with all the recipients (Column "A" in the screenshot below).
Start with data. Pay attention to headers names
Start with data. Pay attention to header names
You can add as many columns as you want, and you will be able to retrieve them in the template editor. ( Column Name / Company ...)

Customize your email template

In the template editor, You are now able to retrieve your Spreadsheet data to customize your emails, through what we call merge tags.
Headers become merge tags
Headers become merge tags
Merge tags are simply names of your columns, surrounded with characters {{ }}. For instance, if you want to use the "Name" column in your template, bring it with {{ Name}}.
You don't have to type merge tags, just use our dropdown menu :
Merge tags becomes your data
Merge tags becomes your data

Personalize your email subject

To customize your email subject, you can also use Merge tags. For instance, if your Google Sheets contains a column "Name", you can customize your email subject using merge tag "{{Name}}" as shown below:
You can customize the subject with merge tags too
You can customize the subject with merge tags too