Insert Dynamic Links in your Emails

With Mergo, you can insert a dynamic link 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 links

Assuming you already have an existing campaign sheet, follow these steps to set up your dynamic text link:

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 (rename as needed)- 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

Note: For the hyperlink() function to work, you need to select or reference the relevant cells from the same campaign sheet you will be using Mergo with (and not from a different sheet/tab). 

3

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

4

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


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


Set up Image links

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

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 (rename as needed) - 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 link {{merge tags}} in your Gmail draft. 


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

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us