How to Insert Dynamic Hyperlinks in your Emails

This site is now deprecated.

๐Ÿ‘‰ Visit our NEW Mergo Help Center

Do you want to know how to use hyperlink text or images in your email campaigns?

We're excited to introduce the Dynamic Hyperlink feature. You can insert a dynamic hyperlink anywhere in your draft. Once sent, your recipients can click on it and jump to the targeted website. And you can use it not just on text, but on images as well!

๐Ÿ›ˆ๏ธ Note: To achieve our goal, we're going to use Google Sheets' built-in functions called hyperlink() and image().

Set up Text hyperlinks

Assuming you already have an existing campaign sheet, just follow the additional steps to set up the dynamic text hyperlink:


1. Create 3 new columns in your campaign sheet. In our example, we labeled it as URL, Display Text, & Hyperlink. Where:

  • URL - the target or destination site (column D)

  • Display Text - this is the anchor text that your readers will see (column E)

  • Hyperlink - this contains the hyperlink() function that will reference your URL & Display Text columns (column F).

Mergo datasource

2. Click cell F2 then type in "= hyperlink(D2, E2)". Where:

  • D2 - is the cell of your referenced URL

  • E2 - is the cell of your referenced display text

hyperlink formula

3. Press enter.

4. Then copy the formula to the relevant rows.

5. Lastly, place the hyperlink {{merge tags}} in your Gmail draft. See our example below.

Gmail draft with dynamic hyperlinks

This is the resulting email that contains text and image hyperlinks.


Set up Image hyperlinks

Assuming you already have an existing campaign sheet, just follow the additional steps to set up the dynamic image hyperlink:


1. Create 4 new columns in your campaign sheet. In our example, we labeled it as URL, Display Text, Image (URL), & ImageHyperlink. Where:

  • URL - the target or destination site (column D)

  • Display Text - this is the anchor text that your readers will see (column E)

  • Image (URL) - this contains the image URL or address (column F).

  • ImageHyperlink - this contains the combo formula hyperlink() + image() functions that will generate both the image and its hyperlink (column G).

Mergo datasource

2. Click cell G2 then type in "= hyperlink(D2,image(F2))". Where:

  • D2 - is the cell of your referenced URL

  • F2 - is the cell of your referenced display text

hyperlink & image formula

3. Press enter.

4. Then copy the formula to the relevant rows.

5. Lastly, place the hyperlink {{merge tags}} in your Gmail draft. See our example below.

Gmail draft with dynamic hyperlinks

This is the resulting email that contains text and image hyperlinks.