How do I make Appscript Web App less brittle for use commercially
I've been playing around with the appscript web app thingy and thought I could use it for commercial purposes among a group of say 15 users. However, I get this sporadically:
In the incognito window on the top it works fine. It's logged in as the owner of the app which is me but not really me because I have another account for stuff like this. On the top, is my normal chrome which is logged in as me and as the owner of the account. This is how I set it up
And this is the sharing thing on the my projects
Finally, it draws from this google sheet which for now only I have access to, so hopefully that means no one else can access the data with permission which hopefully means anyone can open it but no one can get access to my precious data necessary to actually use the sheet unless they have access. Of course, in case I'm wrong I have to obscure the url. Anyway, how do I prevent this "Sorry, unable to open the file at this time" error which happens randomly.
It looks like what you are experiencing is an ongoing issue which many users have reported on Google Issue Tracker here and it stems from multiple accounts being logged in.
I suggest you star ★ the issue above and eventually add a comment saying that you are affected by it.