LinkedIn
Twitter
Thank you for the suggestion, but sadly that is not an option. We donโt have Google Workspace, which in this case would mean extra 2 x 12$ per month just for a shared folder (shared folders option starts from Business Standard plan). We currently donโt need any of the other functionality that comes with the package. Seems very forced, this.
Also reading this article: https://help.appsheet.com/en/articles/4474114-understanding-cloud-object-stores
Where is stated: "If the table data source is a Google Sheet, the image and file data is stored on Google Drive in a folder that is collocated with the Google Sheet. "
Would make sense to me that if my Public app uses the Sheet in the location of my Secure app then the files and pictures are stored in the Drive where the Sheet is located. But it doesnt work so! 
Hi @Mari_Ermann
Yes, this is a limitation, but it all depends on perspective: from what I understand, AppSheet focuses on โinternal enterprise usersโ. Because most of time the users will have a business standard plan or similar, this doesnโt really look forced to me. I face similar concern when it comes to scanning, which is the only feature I need for some apps.
As I said, this is just about perspective 
About your point:
If your concern is about accessing same data, you could use Google Apps Script (GAS) in order to update both โroot folder contentโ.
This may come tricky, as dealing with additions and deletions will come hard to manage.
However, assuming your public app wonโt delete any data, that could be an excellent workaround.
If you are familiar with Google Apps Script and feel like you are ready to spend some time on it, here are some useful posts thus you could get some inspiration/information:
