Appsheet Database & App Script

[lochtefeldm]

Curious if the following is possible with Appsheets native database format, I know it is via google sheets - but would like to use the database due to other limitations with Google Sheets from a scale & call perspective.

Sync Google Workspace Directory with Appsheet database via app script. Any changes made within appsheet app to a users title, phone, email, company, etc to be synced back to the Workspace Directory. Any new users to the workspace added to the database with a trigger.  

[WillowMobileSys · Accepted solution]

---

@lochtefeldm wrote:

Sync Google Workspace Directory with Appsheet database via app script

---

You couldn't access the AppSheet database directly.  You would interact with the data set through the AppSheet app.  

Additionally, there isn't any pre-built integrations where AppSheet can send/receive Workspace details.

HOWEVER, there likely is a Workspace API of some sort.  If that API supports access to User profile details, then you can use AppSheet automation to send and receive that data.

[Scott_Nesbitt]

This is a dealbreaker for me as I have to be able to use Apps Script to read from the data source.  Could this please be added?