Add different images to each email sent

*** A new version of this article is available on this page ***

Using =IMAGE() formula to add personalized images

You can use the =IMAGE() function in your spreadsheet and we will automatically convert it to an HTML image so your recipients get a viewable picture in the email.

Lean more about this function: https://support.google.com/docs/answer/3093333

Then, add the marker <<Product picture>> on your Gmail draft:

And that's it! You can do your mail merge as usual, and each recipient will receipt the right picture:

Important notes about =IMAGE() formula

Note that only the =IMAGE() formula is currently supported, you cannot use other formulas inside it.

For example: This will not work (concatenate function in image function):

However, this will work:

The value of column D is a valid image URL and we can simply add in column E the image function =IMAGE(D6)