image relative drive paths into Google sheets...

(Keith Winston) #1

image relative drive paths into Google sheets cells: I’ve got images identified with relative drive paths by Appsheet in my Google drive, i.e. subdir/image1.jpg

I need to get them into a google sheet with =image(“…”), except that doesn’t seem to work. Does anyone have any experience with this?

(Tony Fader) #2

@Keith_Winston Take a look at this example: - Images in sheets - How to have images show up in your Google Sheet

And the bottom of this article: Images in sheets - How to have images show up in your Google Sheet

(Keith Winston) #3

I got so excited when I saw this: how did I miss it? However, it doesn’t work: if I copy the app, and add a new image, all the old images show up on the sheet, but not the new one. Presumably, that’s because it would need to store my new image on the path provided, at, and I can only assume they aren’t going to allow that (though the URL was constructed that makes it look like it exists, and it shows up in the app?). Anyway, I need to figure all this out for Google Drive images, which is my datastore. But Google Drive seems to have problems with this issue more generally: I haven’t been able to get any Drive-stored images to work with the =image() function, I believe.

(Tony Fader) #4


It’s going to be difficult to get it to work with GDrive image URLs. I’m not sure if it’s even possible to do that.

The example that I linked to above uses a different technique. It uses an appsheet URL to your image. The sheet formula that it uses to create the URL involves sending your app name and the relative image path as URL parameters. You’ll need to modify the app name part of the formula in order to get this to work in your app.