When sending emails automatically with Sheetgo, you can include smart tags to personalize them using information from a spreadsheet. This feature allows you to send only specific data for each email. You can take this personalization further by placing a specific image for each recipient.
To do this, first you need a column with a URL for each image. With that information, Sheetgo can place the right image for each email.
Note: Only image URLs are supported, and they must be public on the internet. This means you need a workaround to add Google Drive images.
To add an image to an email, first select Email under Generate when setting up the destination part of your workflow.
When creating your email body, click the Insert image icon.
On the dropdown menu on the Insert Image box you will find a list with all the columns on your spreadsheet, select the one that has the image URL and click Done.
On the email textbox, you will see a placeholder image, which will be replaced dynamically when generating emails.
Workaround to add Google Drive images
Images on Google Drive can't be published on the web, making them difficult to use for document generation and automatic emails. There is a workaround to this limitation.
Share the image with anyone who has the link.
Copy the image code from the URL.
Place it in this link: "google.drive.com/thumbnail?id={image_code}"
Additionally, you can add this suffix to set the desired image pixel size "&sz=w100-h100". You can set only the width or the height, and the aspect ratio will be respected.
If the initial Google Drive URL looks like this:
https://drive.google.com/file/d/1vGzgSDj2-Oce_8LKpwXH5JWDa2PWoSA9/view?usp=sharing
The result would look something like this:
drive.google.com/thumbnail?id=1vGzgSDj2-Oce_8LKpwXH5JWDa2PWoSA9&sz=w500