Insert personalized images in your generated Google Docs
Using images in your merged google docs leads to better retention and engagement with your audience. To achieve our goal, we're going to use Google Sheets' built-in image() function.
In this article
Set up Images
1. Create 2 new columns in your datasource. In our example, we labeled the headers as ImageURL and Images. Where:
- ImageURL - URL where your images are uploaded or stored (column D).
- Images - 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. Copy the image() formula to the relevant rows.
4. Insert the {{image}} merge tag in your Google Docs ({{Images}} - column E in our example.
Tip: On Adjusting the size of your image in Google Docs.
Info: Having a hard time getting your Google Drive image URLs?
=https://drive.google.com/uc?id=1abcWdefgFhiVYgWi5GUjklmn7kXeI-YZ
You will immediately know that the URL you entered is correct when you see an in-cell image generated by Google Sheets (cell E2).
Set up QR Codes
- ImageURL - URL where your images are uploaded or stored (column D).
- Images - This contains the image() function that will reference your image’s URL column (column E).
2. Click cell E2 then enter:
=https://chart.googleapis.com/chart?chs=200x200&cht=qr&chl=FirstName%20LastName%20kris@gmail.com
Where:
3. Repeat steps 1 & 2 to the relevant cells under Column E.
💡 Use the Concatenate() function to automate your image-link generation.
Info: {{Image}} merge tags can be placed anywhere in your document (body, header, or footer). Just remember that since QR codes are generated as images, they will have Google Docs’ default padding, wrapping, and position. Adjust these properties as needed.
Note: Using an ArrayFormula() to generate the images for all rows is currently not supported.