The Gopher for Chrome Add-on for Sheets provides a powerful way to manage and gain insight into Chrome Devices enrolled on a G Suite domain. The features described below are available to trial or paid (basic or premium) users of Chrome Gopher.
Thanks to the power of Google Data Studio, several of Gopher for Chrome's key auto-refreshing reports can now be displayed as rich, shareable and embeddable dashboards.
Before you start, some gotchas to look out for:
- Before you will be able to use Data Studio connectors, you must accept the Google Data Studio terms of service from Google's UI.
- Some third-party Chrome Extension, such as UBlock Origin, Securly, and NetOp, are known to cause interference with the Data Studio Connector to template workflow. We believe this results from the blockage of Google Analytics traffic. If you encounter "System error" for all graphs in your templates, you may need to disable these extensions and redo the connector setup steps.
- We have had at least two reports of Windows 10 users with 64-bit Chrome version 66 who had "Server error" issues that resolved when they performed the setup from a Chromebook or Mac.
To get started, navigate to the reports tab in the Gopher for Chrome Add-on for Sheets, then select Data Studio > Connectors and preview the options available. Each connector relies on the existence of the relevant Aggregate device report within the Sheet. If the required report is not enabled, clicking Enable will navigate you to the Aggregate reports slide-out, where you can spawn and configure the report to auto-refresh (recommended).
Clicking on a given connector will copy the spreadsheet URL to your clipboard and navigate you a configuration page for the relevant Data Studio Connector, where you will need to paste the URL and confirm the required tab for the report. We also recommend you give your connector a clear title, so you can identify it in the future, and that you select Use template by default.
Next, you'll see the pre-defined connector fields and a button to Create Report. Clicking it will generate a templated report using your Chrome Gopher data.
Daily Activity by OU
This report allows for exploration of device fleet utilization across organizational units, time, and day of week.
Auto Update Expiration by OU
This report allows for exploration of device Auto Update Expiration date (based on Google-reported device model) across organizational units and time.
Chrome Version by OU
This report allows for exploration of major Chrome version (based on Google-reported value) for devices across organizational units.
Documentation will be updated accordingly.
Important reference documentation