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.
IMPORTANT NOTE: Please be aware that /file/d/FILE_ID/view
links are preview links, which no longer work as intended. Users will need a download link instead. To create a download link, you must replace /file/d/FILE_ID/view
with /uc?id=FILE_ID
in the URL manually.
Additionally, ensure the file is shared publicly (set to "Anyone with the link").
Info: To achieve our goal, we're going to use Google Sheets' built-in image() function.
Note: Supported image formats are PNG, GIF, and JPEG.
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)
Important: If the image you want to use is located on Google Drive, make sure to use the following URL format: https://drive.google.com/uc?id=XXX (where XXX is the Google Drive ID of your image) - Image - this contains the image() function that will reference your image’s URL column (column E)
Click cell E2 then type in =IMAGE(D2). Where D2 - is the cell of your image’s URL.
Then copy the image() formula to the relevant rows.
Lastly, place the image {{merge tags}} in your Gmail draft.
Here's the resulting email that contains our personalized image.