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.
Then get the URLs of all the personalized images you want to send to your recipients.
To obtain the image URLs in Google Photos:
- Open an image in Google Photos.
- Right-click the image and select the correct copy image URL option for your browser.
- In Google Chrome, select Copy image address.
- In Safari, select Copy Image Address.
- In Firefox, select Copy Image Link.
You can now paste the image URL in the IMAGE() function.
2. Use =IMAGE() formula to add personalized images
Use the =IMAGE() function in your spreadsheet to add the URLs of the images.
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.
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 add in column E the image function =IMAGE(D6)