GMass has many great options for mail merge personalization options, from simple mail-merge personalization to fallback values and even automatic first name detection. But did you know you can also include a personalized image for each recipient of your email marketing campaign?
The best practice for including a personalized image is to include an “img” tag in a column in your Google Docs spreadsheet. Let’s walk through an example of how to do that.
Example: Different Zodiac Signs
After using GMass to connect to your spreadsheet, the Compose window launches. In our fictional example, the Star Sign promotional email looks like this:
Note the presence of the text “{ImageLink}” in the center of the email. That is how GMass will know to replace that with the image indicated in the spreadsheet.
When your email is sent, each recipient will get the same text, but a unique image. For example, the recipient Brandon, who is an Aries, will receive the following email:
Ron, who is a Leo, will get the same text, but an entirely different personalized image:
Finally, Jack, who is a Capricorn, will receive yet a different image:
Other Use Cases
You can personalize emails using any images you want, of course, but just to give a sense for how this GMass feature could be used, here are some example cases:
- Put a player’s name on the sports jersey or hat you are selling them.
- Include a photo of the person taken as part of his or her interaction with your business. For example, at a tourist site in which souvenir photos are taken.
- Include a different theme image depending on whether the recipient is male or a female, older or younger, from a particular country, or of some other demographic grouping that you could respectfully represent with an image.
- Provide a photo of the branch of your business that is local to the recipient.
- Show photos of specific products or services that each particular client is likely to be interested in based on customer data you already have.
Using Google Drive images
Google Drive is a great place to store images for your GMass campaigns. But… it takes a few steps. One, giving GMass permission to access Google Drive. Two, making sure your images have proper sharing permissions. And three, getting the actual image URLs (not the URLs to the images’ Google Drive page).
Click this link to give GMass permission to access your Google Drive images. We don’t ask for this permission by default; only in situations like this when we need it.
Now upload your images to Google Drive. Then select your images and give everyone with the link permission to view.
Now hit that Copy links button at the bottom of the popup.
Follow these steps to turn Google Drive’s string of URLs into actual images you can use.
- Open a new Google Sheet
- Click into cell A1 and hit paste.
- In cell A2, enter this formula:
=SPLIT(A1,", "). Don’t forget the space after the comma that’s inside the quotes. - Select everything in the second row. Click Copy.
- In cell A3, click Edit > Paste special > Values only.
- Select everything in the third row. Click Copy.
- In cell A4, click Edit > Paste special > Transposed.
Now we have every Google Drive image URL on its own line.
Delete rows 1, 2, and 3. That will leave you with just the URLs as they’re supposed to be for mail merge. That’s because Google didn’t give you direct links to the images — the links are to Google Drive pages featuring those images. And to mail merge the images, we need to grab the image links themselves.
In B1, type in the following formula: =MID(A1,33,(FIND("/",A1,33)-33)). We’re extracting the file ID from the string. We know it starts at the 33rd character and we’re accounting for the possibility it could be any length. Then drag that formula down to the rest of the rows.
It’s finally time to build mail merge links.
In C1, type the following =CONCATENATE("<img src=""https://drive.google.com/uc?export=view&id=",B1,""">") . You need all those double quotes in there because that’s how you escape quotation marks in this particular Google Sheets scenario. Now drag that formula down to the rest of the cells in the column.
Now copy everything in column C. Go to your main spreadsheet and paste those links in the right rows. Make sure to use Edit > Paste special > Values only.
The images will now be properly embedded in your emails.
Using Dropbox images
Much like Google Drive, Dropbox doesn’t like giving you the direct URLs to your images — they give you links to Dropbox pages featuring your images. So again, we need to extract the URLs.
And with Dropbox, you have to do this one at a time. Plus the URLs are really long. So it’s not the ideal solution.
Upload your images to Dropbox.
Right click on one of your images and chose Share then Share with Dropbox.
Make sure the permission is Anyone with this link can view. Then click Copy Link.
Now open an incognito browser window. (It needs to be an incognito window so you get the public URL.) Paste in the link. Then right-click and choose Copy Image Address.
Now paste that URL into your spreadsheet. And add <img src=" before the image URL and "> after.
Now repeat for the rest of your images.
Things to Keep in Mind
Although that is the basic idea, here are a few other points to keep in mind about personalizing images:
- To keep things simple, I’ve just used a regular typed-in email for the example above. However, in many cases you will want to use the personalized image technique in the context of a custom HTML email. It works exactly the same way: just paste in your HTML into the Gmail compose window and then type in your {ImageLink} tag where you want the personalized image to appear. You can read more about How to use custom HTML in a Gmail compose window.
- You can also make the image a link itself, of course. That would require using the personalized link technique I’ve blogged about before, but, in your spreadsheet, including the <img> tag within the <a> tag, like this:
<a href="https://www.starsignessentialoils.com"> <img alt="Aries Essential Oil" src="https://i.imgur.com/n3LQgc1.png"> </a>
Summary
If you need to send personalized images as part of a Gmail-based email marketing campaign, just host the individual images somewhere online and then include the full personalized image links, one for each recipient, in your Google Docs spreadsheet. Finally, include the personalization tag (such as {ImageLink} or whatever you’d like to call it, as long as it matches to the spreadsheet column) in the body of your email. It’s that easy!
Want more?
- Now that you know how to personalize images, learn how to personalize links as well.
- See the complete guide to personalization for a deep dive into personalizing mail merge campaigns.
Email marketing. Cold email. Mail merge. Avoid the spam folder. Easy to learn and use. All inside Gmail.
TRY GMASS FOR FREE
Download Chrome extension - 30 second install!
No credit card required
Ajay is the founder of GMass and has been developing email sending software for 20 years.
By emailing myself using the G Mass button, I have created 5 templates which will be used in my email sequence. All the templates have images in them but I only see the image in the first email that I sent out (one that shows the subject) after that every email is not showing the images….. how do you fix this?
Hi Agbish,
Before “saving” the template to your account, please make sure to test email it first to ensure the image shows. You’ll have to email templates 2-5 to yourself again, making sure to send a test email before clicking the GMass button to ensure that the image is also saved.
This works great, but the image in my test email is HUGE. I’ve reduced the size of the original file, but there is no change in the size of the image when I re-test.
I emailed this question directly to you, but thought you might want to answer here too for the benefit of others.
Hi Dave,
We’ve answered your email directly. You may set the width of your image by adding width=”200″ prior to the closing bracket of your image code.
Example:
img src="http:www.yourdomain.com/yourimage.jpg"img src="http:www.yourdomain.com/yourimage.jpg" width="200"I just tried to set the width of my file following your guidelines, but it’s not working … the code I used is (example)
The image didn’t show up – what am I missing?
Hi Chelsie,
Does your spreadsheet have the image HTML code in the cell under the column with the header “example”?
Your spreadsheet column should contain something like:
Replace the () with html brackets
(img src="yourimageurl.jpg" /)What do you mean?
If i want to make sure the image size is correct, where do i add this width and number?
And how do i know what size to add?
How do i preview to make sure size is correct
please explain
Hi Letisha,
You can set the width of an image as part of the img HTML code as seen in the example below:
img alt="Aries Essential Oil" src="https://i.imgur.com/n3LQgc1.png" style="width:300px, height:auto"
I am following all the instructions listed here and when I test the email, it either comes up as a full hyperlink or the image doesnt display, almost like it is a broken link. I have include images directly in the email before without having to hyperlink them. Any suggestions?
Hi Todd,
Please contact our support team at https://www.gmass.co/blog/how-to-get-support-from-the-gmass-team/ with a screenshot of your spreadsheet.
Hi Marvin,
Facing an issue as I’m drab-n-drop image into message area. The test email shows the image name with a broken link. I’ve performed this many times prior but seems it doesn’t work the same now. Suggestions?
When adding an image in a GMass email, how do you wrap the text of the email around the image?
Hi Dorothy,
You would need to use HTML to achieve this since you would need to set the image alignment which Gmail does not allow. Please see https://www.gmass.co/blog/use-custom-html-in-gmail-compose-window/
Hi there!
I’m not sure if I’m in the right place. I’m trying to use the gMASS module for emailing pet health records (personalized attachments) from Google Drive and Google Sheets but when we go to open the attachements while testing the software we’re unable to open them.
I’ve watched the video and have scoured the website for further instruction but I’m stumped :/
Help please?
Hi Alexis,
Please contact our support team (gmass.co/g/support) so we can assist you directly. Please include the campaign ID in your initial email so we can check right away.
Where would be a place that we host images?
So i can use this feauture please
And how do i make sure image is in a certain area of the email?
lets say above my signature …
Hi Letisha,
You can host your images in any image hosting service provider that allows direct linking. The recommended place since you have your own domain would be to host your images in your hosting. Offsite hosting can also be done such as imgur.com
Thank very much for helping me.
How to send individual links to my email recipients?
Hi Nishani,
Please see https://www.gmass.co/blog/how-to-include-a-personalized-link-in-a-gmail-email-marketing-campaign/
One thing I would like to say is the fact that before obtaining more laptop memory, look at the machine within which it can be installed. If the machine is definitely running Windows XP, for instance, a memory threshold is 3.25GB. Setting up a lot more than this would easily constitute just a waste. Make sure that one’s motherboard can handle the particular upgrade amount, as well. Great blog post.
why some more words like “lazy ” befoe the “src” and no image display instead only the link words ?
If I dont have a website to store images on. Is there a way to pull these images right out of a folder in my Drive??
I have tried so many times, but I past my { } link and no image comes through. The text links come through just fine. But the image doesn’t show up. I can see the image in my google sheets, but it never copies through to the email.
Hello, I tried this method to add personalized images to the GMass email but the image is not displaying. Instead it has an empty icon shows, like a picture is supposed to be there but it didn’t load. I am linking images from my Google Drive. Would that be the problem? TIA
Hello there.
I used to use Sendinblue to send custom images and links to my clients, but they don´t have this functionalitty anymore.
Do you know any email plataforms that let me send custom images?
Thanks a lot
Hi Fernando,
If you’re sending campaigns within your account’s sending limit, you can use the above article to send your personalized emails/links without the need for a third-party SMTP service. If you would rather send using a third-party SMTP, we recommend SendGrid which is the same SMTP service provider we maintain an account with that is compatible with GMass.
If we have an image placed directly in a spreadsheet cell (not hovering over the cell, but actually within the cell, will that image carryover to the email template? I’m having trouble accomplishing that and wonder if it is required to have to use a link to the image instead? THanks,