Do I have to share the data source access

[Frank_Li]

Hi all,

I created an app and invite users (some are in the same organization and some outside).
The source data is all from the Google Sheets.
The problem is that I have to share the source Google Sheets with other users or not if I deploy the APP.

Thanks

[Frank_Li]

I am currently creating the APP under the testing environment (before deployment).
It seems that every actions, like edit data, the history record on Google Sheets all shows one user, the APP owner.

[Marc_Dillon · Accepted solution]

I’m not sure what you’re asking, but you should know about this option:

Frank_Li:

like edit data, the history record on Google Sheets all shows one user, the APP owner.

That would mean the above setting is set to “as app creator”.

[Frank_Li]

Thanks @Marc_Dillon ,
You are right. The key is the ‘Access Mode’ setting.
If we set as app creator, we do not have to share the source sheets but the edit history on the sheets will show the owner only.
However, we have to give access to the source sheets if we set as app user. This means other users will use their own credentials to access the source data but the Google Sheet history will record them.

Thanks.

[Frank_Li]

and I think this meet the Google Rules. The Google Sheet History function only records the users who have access to it.

[Koichi_Tsuji]

Frank_Li:

However, we have to give access to the source sheets if we set as app user. This means other users will use their own credentials to access the source data but the Google Sheet history will record them.

This is wrong.
Sert as app user is prepared for “Private table” function under Appsheet.