Display images in google sheet cell by using file urls from google drive -2021

Display images in google sheet cell by using file urls from google drive - formulas, script and buttons.

Link for script and formulas :

[efraimbasilio]

=image(SUBSTITUTE(TRIM(J11), "open?id", "uc?export=download&id")) - This is the correct formula ...
But please don't forget to share the image folder for the images to be loaded in the google sheet.
Go to you google drive folder and in the image folder click ---> Share

[MatthewScott-xgho]

This is a really good demonstration, but it would be helpful if you could also link the sheet on your website so people can see the finished version.

[jorgehuttherrera]

In order to make it work and display the image you have to share the folder that contains the images

[saurabhyadav]

Great video 👍👍
Create more adavance videos like this...

[RajeshSharma-gudo]

Hi! Nicely explained everything but I am facing the same issue as Donna Johnson. URL converted into thumbnail but it doesn't appear in the image cell. Please help. Thanks.

[kerinahrgang]

After several times of trying with no photo appearing, I looked at the formula in the photo frame area. I changed the formula to

=image(SUBSTITUTE(TRIM(J11), "thumbnail?id", "uc?export=download&id"))

since there was no "open?id" in cell J11. The photo appeared!

[alexanderseguraaltamira]

Does anybody has an idea what the image is not shown in the range, eventhough I am using the correct formulas? Do we have to configure something in the J3:J9 range?

[saadelias]

Fixed it!!!!

Hi, I did everything exactly, corrected this formula as well '=image(SUBSTITUTE(TRIM(J11), "open?id", "uc?export=download&id"))'. Even though it is not showing the What could be the reason???? it is not showing any errors as well. Please someone help.

[unuskpm]

Hi Tek Rayz, Image not showing even after applied formulas in Image Sheet for URL Edit. please help

[jedsantos]

This helped me! Thank you so much! I’m also looking for a way to easily print a Google Sheet range to PDF. Maybe you have a solution? Thanks again!

[bobijuliansah]

This is awesome!, thank you so much !

[mohdshahjahan]

would you pla give a funtion code for editing or modifing searched data

[wajahat]

I am getting this error, how to i can fix this ?
Exception: Unexpected error while getting the method or property getFolderById on object DriveApp.

[chatchavaditssimaraks]

hi sir - when i paste the image formula into cell .. the formula become "=image(SUBSTITUTE(TRIM(J11), "open?id", üc?export=download&id"))"))" .. there are extra "))" which i cannot remove

[jhunplerazon]

hi sir, i don't know why the formula =image(SUBSTITUTE(TRIM(J11), "open?id", üc?export=download&id")) didn't work for me huhu