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.
Get your image URLs.
- Open Google Drive and upload the image you want to use.
- In Google Drive, right-click on the image and select Get link.
- Set the appropriate access level to ensure that your image will be displayed correctly for all recipients, then click Copy link.
The link will have the following format: https://drive.google.com/file/d/IMAGE_ID/view?usp=share_link.
An example is https://drive.google.com/file/d/1nk7jW7MjbBCZZg7815AUsmhbGAeWBMOc/view?usp=share_link, where 1nk7jW7MjbBCZZg7815AUsmhbGAeWBMOc is the IMAGE_ID.
- Copy the IMAGE_ID and paste it into the following format: https://drive.google.com/uc?id=IMAGE_ID.
Using the example in step 2, we have https://drive.google.com/uc?id=1nk7jW7MjbBCZZg7815AUsmhbGAeWBMOc.
Use the =IMAGE() function in your spreadsheet to add the URLs of the images.
info Learn more about the =IMAGE() function: https://support.google.com/docs/answer/3093333
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).
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)