Insert Dynamic Hyperlinks in your Emails

With Mergo, you can insert a dynamic hyperlink anywhere in your email draft. Once sent, your recipients can click on it and jump to the targeted link or URL. And you can use it not just on text, but on images as well!

In this article 

Info: 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, follow these steps to set up your 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)

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

3

Press enter. Then copy the formula to the relevant rows.

4

Lastly, place the hyperlink {{merge tags}} in your Gmail draft. 


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)

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

3

Press enter. Then copy the formula to the relevant rows.

4

Lastly, place the hyperlink {{merge tags}} in your Gmail draft. 


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