Google Drive images. Would like input on if this an ok way to do it

I have a Google apps script that reads a folder with images once a day, and makes a complete list of all it’s inventory in a Google sheet, with links and all. (No need for write functionality in app.)

I have two extra columns that has a formula converting the link to the following below, and it’s working well on my tests.

Is this a sound way to go about it? Are there any pitfalls you can think of?

The images are reloading each time i open the app, which I’m a bit concerned about. Though the thumnail version of the images are lightning fast, which is nice.

Some of the background for doing it this way, is that I want everything for now to be accessed through the Google Drive app as well, so we have a “backup solution” if the app stops working.

https://drive.google.com/uc?id=YOURFILEID&sz=w{{1920}}-h{{1080}}
https://drive.google.com/thumbnail?id=il?id=YOURFILEID&sz=w&sz=w{{1920}}-h{{1080}}

1 4 194
4 REPLIES 4
Top Labels in this Space