# Mail Merge Tutorial

First, make sure you have installed Mail Merge for Gmail from the [Google Workspace Marketplace](https://workspace.google.com/marketplace/app/mail_merge_for_gmail_%F0%9F%93%A3/562406866377). Once installed, let's see how to personalize and send your first emails.

{% embed url="<https://youtu.be/eDfDZtL_daU>" %}
A short video to cover the basics of Mail Merge for Gmail
{% endembed %}

## 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.&#x20;

### 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)*.

<figure><img src="https://3759601264-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FtBoQpQrzJViUHu4Cv5ai%2Fuploads%2FsTcWN9yAxmkj5v8tOm2H%2Fdatasheet.png?alt=media&#x26;token=5d56e14b-68b3-41df-8884-a85b5f801670" alt=""><figcaption><p>Start with data</p></figcaption></figure>

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.**&#x20;

<figure><img src="https://3759601264-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FtBoQpQrzJViUHu4Cv5ai%2Fuploads%2FvDyNinQsCfejXpgPKtkw%2Fhighlight%20mergetag.png?alt=media&#x26;token=ee956eb1-002c-4e17-8552-c598210d0e48" alt=""><figcaption><p>headers in your spreadsheet..</p></figcaption></figure>

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 :&#x20;

<figure><img src="https://3759601264-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FtBoQpQrzJViUHu4Cv5ai%2Fuploads%2FeCeBNBoBKxCpoeEi1Lse%2Fuse%20mergetag.png?alt=media&#x26;token=decf79fb-59ff-4ed5-9de3-f75505fd08a5" alt=""><figcaption><p>..becomes merge tags in the template editor!</p></figcaption></figure>

## 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 show below:

<figure><img src="https://3759601264-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FtBoQpQrzJViUHu4Cv5ai%2Fuploads%2FhvASE2iGp4kbzRqvnfgA%2Fsubject.png?alt=media&#x26;token=bd665e06-6c3f-45de-9116-2b9eb0ec24b6" alt=""><figcaption><p>Customize email subjects signficantely improve your opening rates</p></figcaption></figure>
