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}}
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |