Dynamically merge images, QR Codes and Barcodes

You can merge any image (including QR Codes and Barcodes) into your personalized emails or letters. The image needs to be accessible from a public url. You can even specify a new size for the merged image. This is ideal to generate certificates, application forms, marketing campaigns, direct customers to you business location, download apps, direct customers to a social media page or website and much more.

Template

Merged Email or Letter

How to do it?

  1. The column name in your Google Sheet containing the image URL should be tagged with the value <img> (for example "<img> Photo" as shown in the image below).
  2. If the image is in your Google Drive get the URL as follows:
    • Right click the image and click ‘Get shareable link’.
    • Copy the link and paste it in your Sheet as shown in the image below.
    • If the image is in your Google Drive get the URL as follows:
  3. Insert the *|<img> Photo|* merge field into your Google Document template or Email Body just like you would with any other merge field.
  4. Hit the Merge button as you're good to go!

Can the original image be resize?

Yes. You can set with width and height in pixels within the <img> tag.

For example the following column header <img|200x100> Photo would resize the image width to 200px and height to 100px for all the images within that column.



How can I generate QR Codes?

You can use an online service which generates a QR Code image from a URL. For example you can use Google Charts QR Codes as follows:

https://chart.googleapis.com/chart?cht=qr&chs=128x128&chl=Joe Smitháé

QR Code URL

Merged QR Code Image

How can I generate Barcodes?

You can use an online service which generates a Barcode image from a URL. For example you can use barcodesinc.com as follows:

https://www.barcodesinc.com/generator/image.php?code=Full Name&style=196&type=C128B&width=200&height=100&xres=1&font=3

Template

Merged Barcode Image