How can I allow an image response in Forms to show the image in the Excel spreadsheet?

To add a signature to your Form, you can install a third-part add-on like "Signature":

If you need something like the add-on, so you need a Form that let you create every time a signature, you have to create your own add-on by using the Google Apps Script Platform.

Otherwise if you already have the image of the signature (created with other services), and you only need to upload that image every time you compile the form and show it in the responses spreadsheet, you can use a simple script.

Currently, I have an image upload in my form, but when the data gets put into excel, the image upload displays as a drive link to the image. I would like the actual image to show in the cell of the spreadsheet. Do you happen to know how to do this, other than manually entering each one (not feasible for my business)?

Here is a simple example:

- Go on the Form Editor page

- In the image upload question click on View Folder

 You need to change the visibility of the folder that contains all the images:

- Right click on the folder that contains all the images > Share > Change to anyone with the link > Done

Now you need to add a new column in the responses spreadsheet that will show the image of the drive link.

So choose the column where you want to show the images, for example the column C, and place this formula in the first row of that column, so in my case in C1:

In this formula, "Image" is the column header name so you can change it if you want. 

Another thing you need to change is the column where are stored the drive links.

In my example they are stored in column B, so in the formula you need to change the B2:B part with your column range, for example C2:C, E2:E ecc.

Now every time you submit the form, the signature image will appear in the sheet.