This Google Apps Script is designed for Google Workspace Super Admins to fetch a list of Chromebooks managed under their organization's Google Workspace account. It retrieves relevant Chromebook data and populates it into a Google Sheet named "Chromebook list".
Copy this sheet and open it.
Use the "Chromebook Data" menu -> "Fetch Data" to execute the script.
When you run the script for the first time you need to authorise it. Click continue.
The Chromebook data will populate in the "Chromebook list" sheet. If you want to run the script again it will delete previous data automaticly in the "Chromebook list" sheet.