LinkedIn
Twitter
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}}
I would suggest that instead of using a spreadsheet formula to generate the other columns, just write those other links with your script as well. That way the value in the cell is a static value.
You may also experiment with some of these options to try and improve the experience in the app.
