Show images stored in google drive folder

[SanteQuaglieri]

I’ve an AppSheet app (storage is a google sheet file) taking pictures and saving on a google drive folder. 
I’m struggling how to show the images on a Data looker table report. 
It’s not clear to me how to modify the folder url and  concatenate it with the image name in order to show in a data looker table. 

I only found a way to get a single image file link url to work, while I’d need to link the folder and concatenate the image file names. 

thankyou for any support