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)