help guide

123 Toolkit for Chrome OS

Description of 123 Toolkit for Chrome OS

When to use it

Use the Google Spreadsheet™ add-on '123 Toolkit for Chrome OS' to get a list of your Google Chrome OS devices in a Google Spreadsheet™. The add-on ensures that you have a list in the spreadsheet that you can sort / compare or filter device data when you need so. You can also perform (bulk) actions on the Chrome OS devices.

Some example use case; the spreadsheet with the list can be used to:

  • View all Chrome OS devices in the Google Workspace domain

  • Track the status (e.g. OS version, device support end dates, last user, last sync) of your devices

  • Remote powerwash the devices or remotely remove all user profiles from the device

  • Move devices to a new Organisation Unit (OU)

  • Disable (stolen/lost) Chrome OS devices

  • Deprovision devices that you’re no longer managing

How it works

1 - Download Device Data

Click the button 'List devices' to get your current Google Chrome OS devices into this spreadsheet. You need to be a Google Super administrator in your domain. The Google Workspace domain need to have purchased Google Chrome Enterprise upgrade in the past.

2-Manage devices

  • Wipe users if you remotely want to remove all user profiles from the device but want to keep the device policy and enrollment. E.g. in case of reassign the device to a new user which will have the same device policies.

  • Remote powerwash the devices; Removes all data including user profiles, device policies, and enrollment data. Devices are restored to factory state. If forced re-enrollment is turned off, users can use the device without re-enrolling it into your account. E.g. in case of reassign the device to a new user which should have different device policies. Ensure to instruct the user on the re-enrollment process.

  • Disable / enable the selected devices. Disable a device so that no one else can use it. E.g. in case of a stolen device.

  • Deprovision the selected devices in case you no longer want to manage the device. E.g. if device is end-of-life or sent for repair.

3-Insights

Add the sheet 'Insights' to get a dashboard on your Chrome OS device data.

  • By Status

  • By OU

  • By OS version

  • Active devices by last sync

  • Models

Installation

How to add the Google Workspace extension '123 Toolkit for Chrome OS' to your spreadsheet?

Option 1: Installation from the spreadsheet

  1. Start a new Google Spreadsheet in Google Drive. (https://sheets.new)

  2. In the top menu bar of the Google Spreadsheet select Extensions.

  3. Click in the menu “Add-ons” and “ Get add-ons”.

  4. A new pop-up window will show the Google Workspace marketplace.

  5. Search for “123 Toolkit for Chrome OS”.

  6. Click the button “Individual Install”.

Option 2: Installation from the Google Workspace marketplace

Go to the Google Workspace marketplace: https://workspace.google.com/marketplace

  1. Search for “123 Toolkit for Chrome OS

  2. Click the button “Individual Install

  3. Go to Google Drive and start a new Google spreadsheet (https://sheets.new)

  4. You find the add-on In the top menu bar of the Google Spreadsheet 'Extension'.

FAQ - Frequently Asked Questions

Do I need to be a super admin?

Is there a product roadmap available?

Yes, when there is interest. The following commands will be added.

  • move to ou

  • edit meta data about your devices

  • add reason for deprovisioning

Is there a version history overview?