Follow this tutorial to insert a clickable button or image to your email template. This is useful if you want an effective call-to-action button that will increase your click and conversion rate.
Add a clickable image to your email
1. List all your image URLs under a specific column
Next to each recipient, simply add your image URLs under a specific column, for example 'Product picture':
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() & =HYPERLINK() formulas as shown below:
4. Send your mail merge
And that's it! Simply send your mail merge with the different personalized fields/markers:
Your recipients will receive a personalized email with the right image, and will be able to click the image directly from the email:
Add a clickable button to your email
If you want to display a custom button in the emails you send, and want to redirect each recipient to a different URL when they click on the link / button in the email, simply add an image / button in your draft in Gmail, between 2 markers as below:
And add column headers corresponding to your markers in your spreadsheet, with an HTML anchor tag:
As a result you get an anchor tag set around an inline image, and you can put a different link for each recipient.