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.