AppSheet and Google Admin

[kharmon]

I am a newbie when it comes to APIs and App Script. 

What is the best way to pull information into my app from Google Workspace? Specifically, I want to pull in Chromebook information - last known IP, most recent user, last synced, etc. into one or two of the views that already display some Chromebook and student information.

Thanks!

[WillowMobileSys]

---

@kharmon wrote:

I want to pull in Chromebook information - last known IP, most recent user, last synced, etc.

---

I think we need more details to give the best advice.  What are you trying to accomplish?  Why IP address?

The above sounds like you want to retrieve network details from the Chromebook the app is running on?  That is not directly supported.

If you have some sort of tool that captures those details from the students usage of the Chromebooks AND that tool provides a REST API, then you can create a Bot in the AppSheet app that calls to that API and grabs the details that way.

---

@kharmon wrote:

What is the best way to pull information into my app from Google Workspace?

---

I'm not clear on how Workspace fits into the other info you are asking about.   BUT...Google has several API's available that an AppSheet app could tap into to get additional information.  There are also some built in integrations - such as for Calendars,  File/Image folders, User Groups/Management, etc.  More description of what you want to build might help here as well. 

[kharmon]

Hello!

I built an app for Chromebook inventory/who they are assigned to, daily loaners check out process, and a few other data points. I would like to pull in some of the data about all of our chromebooks from Google admin into the app. So if I click on an assigned Chromebook in the app, I want to see last known IP, most recent user, and last time it synced with Google admin, all these are available in Google admin. 

I found apps scripts examples of this but I can't get the API to call the info correctly. And I don't know how to integrate an apps script with the app sheet. I was thinking if I could pull the Chromebook info into a Google sheet, I could integrate that with my app, and run the apps script on a time trigger. It wouldn't be the most updated info but it would be close. 

[kharmon]

We use the last known IP address to know if it was used at home or on our network. These are student Chromebooks (k-12 district).