Skip to main content

How to Embed a dynamic Image when creating PDFs from Google sheet rows

Docu Merge add-on allows you to generate professional looking documents (Invoices , Certificates , Business Documents etc). You can also embed dynamic images from various sources during this document generation.You can embed an image from a publicly available source such as imgur.com . You can also embed an image which the user submits to a form question as part of form response.Please read below to learn more.

Embed Dynamic Image​

You may need to embed an image uploaded by form respondents dynamically. Here's how:

Folder permision required​

if you want to Embed Images submitted via Google form Change the folder permission where uploaded images are stored to "Anyone with the link" and only Viewer.

Embed Image Tag​

This should be used inside Template Document to be able to embed the Image in the Final Generated document.

Use the tag syntax {{ Embed Image, form question / http image url, optional width, optional height }}.

Examples:​

  • {{ Embed Image, image }} - Form field question name for File Upload.
  • {{ Embed Image, https://i.imgur.com/VW8rUE7.png, 60, 70 }} - Embed a static public image with width and height.
  • {{ Embed Image, image, , 250 }} - Adjust only the height.

Embed QR Code using Embed Image​

You can also generate and embed QR code using the Embed Image syntax

Examples:

{{ Embed Image, https://qrcode.tec-it.com/API/QRCode?data=https%3a%2f%2fqrcode.tec-it.com?code=<<Expression>>&errorcorrection=H&color=0a5c2a&quietzone=5, 120, 120 }}

{{ Embed Image, https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=https%3a%2f%2fqrcode.tec-it.com?code=<<Expression>>, 150, 150 }}

{{ Embed Image, https://api.dub.co/qr?url=https://github.com/dubinc/dub, 120, 120 }}

tip

Please note that to evaluate an expression inside the Embed Image tag you have to use <<Expression>> .

Embed BAR Code using Embed Image​

You can also generate and embed Bar code using the Embed Image syntax

Examples:

{{ Embed Image, https://barcodeapi.org/api/auto/<<Expression>>, 120, 120 }}

The websites referred for QR code and Bar code API are random and in no way we promote or recommend them . You can use any other public facing apis to generate and embed QRCode or Bar code.