Can you access Gsuite groups from appsheet

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โ€ฆ

0 2 254
2 REPLIES 2

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.

Top Labels in this Space