# 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_how/57033717989). 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.

### 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://2496194107-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfMFh73sMAMDGxDQtrIYR%2Fuploads%2FHXDYHeKM29ikAj7ySFpg%2Fspaces_tBoQpQrzJViUHu4Cv5ai_uploads_sTcWN9yAxmkj5v8tOm2H_datasheet%20(1).webp?alt=media&#x26;token=84ab9e79-b949-420e-a049-273a578c9e6f" alt="Start with data. Pay attention to headers names"><figcaption><p>Start with data. Pay attention to header names</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.**

<figure><img src="https://2496194107-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfMFh73sMAMDGxDQtrIYR%2Fuploads%2FmKnS4jJo3aka1eDh3hJg%2Fhighlight%20mergetag%20(1).png?alt=media&#x26;token=d847f800-08fd-4b3b-84aa-28e03a0a9371" alt="Headers become merge tags"><figcaption><p>Headers become merge tags</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 :

<figure><img src="https://2496194107-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfMFh73sMAMDGxDQtrIYR%2Fuploads%2FT5c6SVXzfpq9wbHCEiwl%2Fuse%20mergetag.png?alt=media&#x26;token=47205854-4649-4b13-a302-480eb45ee59f" alt="Merge tags becomes your data"><figcaption><p>Merge tags becomes your data</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 shown below:

<figure><img src="https://2496194107-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfMFh73sMAMDGxDQtrIYR%2Fuploads%2FfOrEcuNGbR9Xy2nZ7nFW%2Fspaces_tBoQpQrzJViUHu4Cv5ai_uploads_hvASE2iGp4kbzRqvnfgA_subject%20(1).webp?alt=media&#x26;token=0ac90778-3f11-41a5-a549-c63ca65162a1" alt="You can customize the subject with merge tags too"><figcaption><p>You can customize the subject with merge tags too</p></figcaption></figure>
