How to Insert Personalized Images in your Emails

Did you know that you can insert personalized images in your email campaigns?

Using images in your email leads to better retention and engagement. But remember to use images sparingly and only to complement your message.

🛈Info: To achieve our goal, we're going to use Google Sheets' built-in function called image().

📌Note: Supported image formats are PNG, GIF, and JPEG.

Set up your image hyperlinks

1. Create 2 new columns in your campaign sheet. In our example, we labeled them as URL & Image. Where:

  • URL - website address of where your image is uploaded (column D)

  • Image - this contains the image() function that will reference your image’s URL column (column E):

2. Click cell E2 then type in "=IMAGE(D2)". Where:

  • D2 - is the cell of your image’s URL

3. Then copy the image() formula to the relevant rows.

4. Lastly, place the image {{merge tags}} in your Gmail draft. See our example below:

This is the resulting email that contains our personalized image: