Send personalized images to each recipient

You can insert different images in your spreadsheet with the Image formula from Google Sheets. YAMM will then send emails with personalized images to each recipient.

1. Get the URLs of all your images

You can first host your images in your own server/website, or use Google Photos.

warning If you upload your images from Google Drive, it will not work.

Then get the URLs of all the personalized images you want to send to your recipients.

2. Use =IMAGE() formula to add personalized images

info Learn more about the =IMAGE() function: https://support.google.com/docs/answer/3093333

Once you get your picture URLs, use the =IMAGE() function in your spreadsheet.

We will then automatically convert it to an HTML image, so your recipients get a viewable picture in the email.

Then, add the marker {{Product Picture}} on your Gmail draft.

done 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).

Not work personalized images

However, this will work :

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

Will work personalized image

The best mail merge tool for Gmail

1. Get the URLs of all your images

2. Use =IMAGE() formula to add personalized images

Important notes about =IMAGE() formula

Comments

Articles in this section