Insert different images in your spreadsheet with the =Image() function in Google Sheets to send emails with personalized images to each recipient.

1. For each recipient row, add your image URL under a particular column, for example Picture URL.

2. Add a column, for example, Product Picture, and use the =IMAGE() function as shown below.

=IMAGE(D2)

info To insert the image along with its properties, such as alt text or size, combine the elements inside an HTML image tag. For an HTML tag like<img src="https://i.imgur.com/1i0dsyL.jpg" alt="Tarva bed"> with the image source in D2 and the alt text in E2, type: ="<img src=""" & D2 & """ alt=""" & E2 & """>"

3. Add the marker {{Product Picture}} in your Gmail draft. 

And that's it! You can do your mail merge as usual, and each recipient will receive 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 E is a valid image URL, and we can add in column F the image function =IMAGE(E2)