When generating documents or send 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 use this feature, you must have a column with a URL for each image. With that information, Sheetgo can place the image on a document or an email.

There are two ways to add a dynamic images to documents.

When building a document template, insert a smart tag with the IMAGE: prefix followed by the header title of the column that has the image URLs. This smart tag will be dynamically replaced with the corresponding image in the document.

Another way to add a dynamic image to a document is with a placeholder image in the template. To do this, add any image to the document, right-click it and select Alt text, then add the smart tag to the alternative text title.

By doing so, there's no need to use the image prefix. This technique ensures that the formatting, style, and location of the image are preserved after replacement.

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.

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.

If the initial Google Drive URL looks like this:

The result would look something like this: