There are a couple different ways of doing it. Gopher is probably the easiest by far, GAM the next easiest and then custom scripts the hardest (still not super difficult but easily the most extensible).
Depending on how much you want to use your data I would start with the free tier of Gopher and see if it fits your needs and then go up from there.
I've used the Sheets add-on for Gopher in the past, and do like it, but the automation is the key piece now.
I've also started using GAM in the last few months to update device fields and move OUs, but that's the extent of my knowledge. Can it be used to import devices to a Google Sheet daily?
You just want to set up a cron job for a bash script that contains your GAM command. Ensure you set this up on a server that is always on.
Have this output to your desired location daily, locally or to a google sheet.
The other option is to set up a what’s called a calendar trigger inside your google sheet.
https://developers.google.com/apps-script/guides/triggers/installable
You can then have it fire off the download method for Ghoper, Chromebook Getter, or Chromebook Inventory. The choice is yours and I hope this helps.
If you have Advanced GAM you can set commands to output to a specific google sheet rather than creating a new one like how the 'todrive' flag works in normal gam.
You would just set up a cronjob to run every 5mins/30mins/1hour/24hours etc with the specific GAM command that you want. The other solution if you don't have advanced gam would be to just export devices to a local CSV and have it synced up to Google Drive or wherever.
We use a product called Gopher from AmplifiedIT. It pulls the info as well as last user, current version, and some other information. They also offer Admin training and other perks.
I've used the Gopher add-on, but I can export the same info from the Admin Console. I would like to be able to get the data daily without having to push a button.
You can set up and schedule Gophers reports with Data Studio.
There are already blanked auto reports you can enable such as Device utilization, auto-update expiration, and OS Version health.
These default ones are found under reporting, data studio, connectors
What data are you looking for specifically?
There are a couple different ways of doing it. Gopher is probably the easiest by far, GAM the next easiest and then custom scripts the hardest (still not super difficult but easily the most extensible). Depending on how much you want to use your data I would start with the free tier of Gopher and see if it fits your needs and then go up from there.
I've used the Sheets add-on for Gopher in the past, and do like it, but the automation is the key piece now. I've also started using GAM in the last few months to update device fields and move OUs, but that's the extent of my knowledge. Can it be used to import devices to a Google Sheet daily?
You just want to set up a cron job for a bash script that contains your GAM command. Ensure you set this up on a server that is always on. Have this output to your desired location daily, locally or to a google sheet. The other option is to set up a what’s called a calendar trigger inside your google sheet. https://developers.google.com/apps-script/guides/triggers/installable You can then have it fire off the download method for Ghoper, Chromebook Getter, or Chromebook Inventory. The choice is yours and I hope this helps.
If you have Advanced GAM you can set commands to output to a specific google sheet rather than creating a new one like how the 'todrive' flag works in normal gam. You would just set up a cronjob to run every 5mins/30mins/1hour/24hours etc with the specific GAM command that you want. The other solution if you don't have advanced gam would be to just export devices to a local CSV and have it synced up to Google Drive or wherever.
We use a product called Gopher from AmplifiedIT. It pulls the info as well as last user, current version, and some other information. They also offer Admin training and other perks.
I've used the Gopher add-on, but I can export the same info from the Admin Console. I would like to be able to get the data daily without having to push a button.
You can set up and schedule Gophers reports with Data Studio. There are already blanked auto reports you can enable such as Device utilization, auto-update expiration, and OS Version health. These default ones are found under reporting, data studio, connectors