How to Insert Unique Images in Merged Documents

H
Published in: Document Studio

With Document Studio, you can insert dynamic images in your generated documents. These images can either be stored in your Google Drive, Google Photos or you can pull them directly from the Internet.

To get started, add a variable marker in your document template where you would like the images to appear. Let’s call it {{Student Photo}}.

Then go to your source spreadsheet and create a new column for the image. The header title of the column should be same as the marker name - Student Photo - without the surrounding curly braces.

Upload Images from the Computer

Go to our free image hosting website and upload the image from the desktop to the internet. The app will offer you a URL of the uploaded image that you can put in the spreadsheet cell.

Upload Images from Google Drive

Open your Google Drive, or Google Photos, where the images are available. Right-click any image in Google Drive and choose the “Get Shareable Link” option as shown above. Copy-paste then URL in your source spreadsheet.

google-drive-image.png

When document merge runs, the {{Student Photo}} marker in your document template would be replaced with the actual thumbnail image of the photo picked from Google Drive.

You can use image markers in both Google Slide and Google Document based templates.  Image markers are supported in Google Spreadsheet templates as well via the IMAGES function.

📮  Subscribe to our Email Newsletter for Google tips and tutorials!
Published in: Document Studio

Looking for something? Find here!

Meet the Author

Web Geek, Google Developer Expert
A
Amit Agarwal

Amit Agarwal is a Google Developer Expert in Google Workspace and Google Apps Script. He holds an engineering degree in Computer Science (I.I.T.) and is the first professional blogger in India. He is the developer of Mail Merge for Gmail and Document Studio. Read more on Lifehacker and YourStory

Get in touch

Google Add-ons

Do more with your Gmail and GSuite account
G

We build bespoke solutions that use the capabilities and the features of Google Workspace for automating business processes and driving work productivity.

  1. Mail Merge with Attachments
    Send personalized email to your Google Contact with a Google Sheet and Gmail
  2. Save Emails and Attachments
    Download email messages and file attachments from Gmail to your Google Drive
  3. Google Forms Email Notifications
    Send email notifications to multiple people when a new Google Form is submitted
  4. Document Studio
    Create beautiful pixel perfect documents merging data from Google Sheets and Google Forms
  5. Creator Studio for Google Slides
    Turn your Google Slides presentations into animated GIFs and videos for uploading to YouTube