If you add a file upload question in your Google Form which allows image format, you can set up Form Publisher to insert those files as images in your generated document. This tutorial will show you how.
timer 15 min.
- Configure a Google Form
- Insert images with File upload question
- Generate a template with images
- Good knowledge of Google Form
- Knowing how to configure Form Publisher
- Knowing how markers work on your template with Form Publisher
- We want to create a profile including an ID photo.
- An employee submits the form and add an ID photo.
- Form Publisher generates the template with the uploaded photo and send it to the HR service
1. Create a Google Form which includes a File upload item
First, configure your Google Form.
From your Google Form, click on the dropdown menu and select the File upload item:
A message appears. Click ‘Continue’:
Then, configure your ‘File upload’ question:
2. Create your template in Google Docs, Sheets or Slides
Open a Google Doc, Spreadsheet or Slide. Then, add the markers you need to personalize your template. We decided in our example to personalize a Google Spreadsheet template:
To know how Form Publisher works with markers, we recommend reading the following article: Standard markers to be reused in your template
3. Configure Form Publisher
Open Form Publisher. If you want to know more, please read the following article: [Step 2] Open Form Publisher
Once you are on your template sidebar, select your template previously configured:
Then, click ‘Matching markers’:
Select ‘Insert as image’ under your File upload question:
Click ‘Next’ and finish your Form Publisher configuration.
4. Submit your Google Form
Click on the eye icon at the top left. Fill out the form and add your image.
You can either upload your image from your computer or from your Google Drive:
An uploaded image appears in your Google Form:
Click ‘Submit’ when you are done:
A message appears saying your response has been recorded:
An email has been sent to the right person with the generated PDF:
Note: All the uploaded files will automatically appear on a new folder in your Drive so that you can retrieve them easily.
Comments
14 comments
Hello, I've had issues where the image would suddenly disappear from the google sheet file I would export it into. The image would stay a day, and then the link would appear with this error. Is this a common error due to google servers generating new ID's for images everyday?
Hi, I'm trying to use this useful functionality but it doesn't seems to work. The generated docs and PDF don't attach or insert any image or link to this. I've tried to use only one image per upload, restricting conditions (only images, name of document without spaces or special characters, max 1mb, etc) but something is wrong, but I don't know what
There's some more info about configuration or how to follow errors or issues to make this possible? Thanks!
experiencing the same failure on images... have double checked config and they're not flowing thru to document.
I'm also experiencing this problem!
Hi,
Could you please contact our support team so that we can help you fix your issue ? And if needed we will update the article.
Having the same issue--the image doesn't insert.
Hi,
Could you please contact our support team so that we can help you fix your issue ? And if needed we will update the article.
Also, if your're trying to import the image in a table in a Google Doc, this is a known issue that we will fix as soon as possible.
My issue was trying to upload the image into a table in Google Docs. I moved the markers outside of the table, and the problem was solved.
Does anyone know how to configure the image files through forms so that they appear a consistent size on the template, regardless of the size of the image?
This is exactly the issue I have. My template is in Docs and I need the user to upload three photos of the same physical dimensions BUT the only way of getting them small enough (passport photo sized, as in the tutorial above) is to reduce the resolution...which gives very poor image quality on the finished document.
Hi,
Thanks for your feedback, we will try to find a solution to that issue as soon as possible, we will keep you updated.
Hi,
I am facing a weird problem, in some cases, the image is not present in the pdf, while the excel file generated from the template has the image shown. Attached below is the generated files both in sheet and pdf format. Is there a specific file format of the image that needs to be followed, need some documentation on this if possible. Tried both .JPG and .png files.
Thanks for your feedback, we will investigate to find what is at the origin of the issue.
experiencing the same issue, image is only shown in sheets, not in PDF or on real printer.
Also if I download the file as Excel xlsx file, it disappears as well
Please advise....
Followed the tutorial and I appear to have the same issue as others. Note: I am using Chrome on a MAC computer.
Issue: My photos all appear in the Sheets version, however 2 of the 3 images disappear when printing. These 2 images are also missing on the generated pdf version.
...Update -
After about 4 hours, both the pdf and the Google Sheet lost all images from them.
Please sign in to leave a comment.