Can appsheet read my gsuite groups?
I have a sheet with these columns, where the values in the safety team Group are actual groups in gsuite
LOCATION Safety Team Group
is there a way I can lookup if the signed in user is a member of a safety team?
|110|rosafety|
|910|corpsafety|
|130|mhsafety|
|140|mdsafey|
|150|ldsafety|
I donโt want to have to create all my safety groups in appsheet that I already have in gsuiteโฆ
Hi @llheath!
I havenโt worked with G suite groups, but I would guess that the key question is Can the G suite group information that your want in your app be pulled into a Google spreadsheet? If the answer is โYesโ then I think youโre in business.
I have an app where data from a public Google spreadsheet is pulled into my appโs G sheet via IMPORTRANGE() and then accessed inside the app. Perhaps you can do something like that with your groups.
You could try this extension-
https://gsuite.google.com/marketplace/app/ok_goldy/939946549872
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |