Insert a clickable image or button to your email template for a clear call to action (CTA) that will increase your click and conversion rates.
Send the same clickable image to all your recipients
-
Insert an image in your email draft between 2 markers as shown below.
-
Add column headers corresponding to your markers in your spreadsheet, with an HTML anchor tag.
- Send your mail merge!
Your recipients will receive a personalized email with a clickable image.
Send a personalized clickable image to each recipient
- For each recipient row, add your image link under a column, for example Product picture.
info In our example, we use imgur.com for hosting images, but you can use other cloud storage solutions for your image uploads. We do not recommend using Google Drive or Google Photos, as those services have restrictions that could affect the accessibility of your images for this particular case. -
Next to each image, add the product website link under another column, for example Product link.
- Add a third column, for example Clickable image, and combine the =IMAGE() and =HYPERLINK() functions as shown below.
==HYPERLINK(D2,IMAGE(C2))
-
Write your Gmail draft with the different markers.
- Send your mail merge!
Your recipients will receive a personalized email with the correct image, and they will be able to click on them, directly from the email.