Add a clickable image / button with a specific link for each recipient

Follow this tutorial to insert a clickable button or image to your email template. That is useful if you want a clear call-to-action button that will increase your click and conversion rate.

Add a clickable image to your email

warning To know more about how to upload images in an email, read the following article: How to upload your images in your emails?

1. List all your image URLs under a specific column

Next to each recipient, add your image URLs under a particular column, for example, Product picture.

info In our example, our image is hosted on Google Drive. We do not recommend hosting your images on Google Photos, as links generate through it expire after a set duration.

2. List the personalized website URLs next to the related image

Next to each image, add the product website URLs under another column, for example, Product link.

3. Use =IMAGE() and =HYPERLINK() formulas to create your clickable image

Add a third column, for example, Clickable image, and combine the =IMAGE() and =HYPERLINK() formulas as shown below.

4. Send your mail merge

And that's it! Send your mail merge with the different personalized fields/markers:

Your recipients will receive a personalized email with the correct image, and they will be able to click on them, directly from the email.

Add a clickable button to your email

If you want to display a custom button in the emails that you send, and you want to redirect each recipient to a different URL when they click on the link/button in the email, add an image/button in your draft in Gmail, between 2 markers as below.