# Gmail Mail Merge

Send personalized videos to multiple recipients using Gmail mail merge

Once you are done generating personalized videos for your list of contacts, the next step is to deliver the videos to your contacts.

In this tutorial, we will show you how to deliver personalized videos via Mail Merge with Gmail. So your end result will look something like this:

<Image align="center" border={true} src="https://files.readme.io/3f08882143a7358968088d0bbf127cb349c5d947122b8be594027cfe312064f8-image.png" className="border" />

<Callout icon="📘" theme="info">
  **Note:**

  Dynamic GIF preview is not available here since Mail Merge in Gmail does not currently support HTML.
</Callout>

Once the recipient clicks the link in the email, they will be able to view the personalized video in a new tab.

<iframe src="https://app.heygen.com/share/79488c7a76914b949c607c9cf608958c" width="100%" height="520" frameborder="0" allowfullscreen />

# Prerequisites

<Callout icon="📘" theme="info">
  **Note:**

  Mail merge in Gmail is only available to Google Workspace plan users.
</Callout>

This tutorial assumes that you already have a list of generated personalized videos. If not, follow along [Generate personalized videos from template via Google Sheets + Zapier](https://docs.heygen.com/docs/create-personalized-video-template) to generate your initial set of personalized videos.

Or you can use this [Example Google Sheet](https://docs.google.com/spreadsheets/d/1G5tRaDJ_o4e2E3DM_oz_dscFwxV_R8Y_KZWa1IX2hK0/edit?usp=sharing) of personalized videos to jump start this tutorial.

<Image border={false} src="https://files.readme.io/27cf860104994842a56c155712cda882e984049b9c5918515a4e419044c41921-image.png" />

# Tutorial video

Follow these steps to send personalized video emails:

1. Connect Gmail to Google Sheet via mail merge
2. Create email template & define variables
   * [Sample email template](https://docs.google.com/document/d/122T_0UdSp8MhRxuuGzWlAhAu2uLNzkp5v5Vz9KQsxLo/edit?usp=sharing)
3. Send emails

**Watch the video tutorial here:**

<Embed url="https://www.loom.com/embed/f7d13fdc6e03440f89b2979d8e56e9a5?sid=87b3b18d-9d38-49b6-a99f-192c5721cfa6" href="https://www.loom.com/embed/f7d13fdc6e03440f89b2979d8e56e9a5?sid=87b3b18d-9d38-49b6-a99f-192c5721cfa6" typeOfEmbed="iframe" height="520px" iframe="true" />

# Resources

* [Send personalized emails with mail merge (Gmail)](https://support.google.com/mail/answer/12921167?hl=en)