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:
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)
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).
Press enter. Then copy the formula to the relevant rows.
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
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)
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
Press enter. Then copy the formula to the relevant rows.
Lastly, place the link {{merge tags}} in your Gmail draft.
This is the resulting email that contains text and image links.