This guide is for the official SheetOps add-on. Install it to manage Google Workspace at spreadsheet speed.
Retiring old Chromebooks, processing student graduation turn-ins, or transferring device licenses one by one in the Google Admin Console takes hours of manual point-and-click effort. SheetOps enables IT administrators and K-12 sysadmins to bulk deprovision hundreds of Chrome OS devices simultaneously from Google Sheets while enforcing mandatory audit reasons.
Device deprovisioning releases enrolled hardware from your organization's Google Workspace domain management. Once deprovisioned, the device no longer enforces domain management policies or kiosk profiles, and depending on the selected reason, can free up an upgrade license seat.
SheetOps executes deprovisioning via the Google Admin Directory API's batchChangeStatus endpoint, grouping hardware actions into high-speed batches of 50 devices per call with comprehensive audit logging.
| Capability | Admin Console UI | GAM CLI | SheetOps |
|---|---|---|---|
| Workflow Interface | Manual multi-page checkbox lists | Terminal scripting with CSV flags | Interactive spreadsheet with visual diffs |
| Batch Throughput | 50 items per page with modal clicks | Custom shell scripts required | 50 devices per automated API call |
| Safety Verification | Single prompt per page | Zero prompt if script flag is passed | Interactive confirmation modal with diff review |
| Reason Enforcement | Dropdown per operation | Requires exact command-line string parameter | In-sheet dropdown validation before applying |
In Google Sheets, navigate to Extensions → SheetOps → Chrome OS Devices:
Serial Number column.In your active spreadsheet:
Retiring Device: Permanently retires aging or damaged devices.Same Model Replacement (RMA): Replaces a defective device with the same model under warranty/RMA.Different Model Replacement: Replaces existing hardware with a different or newer model.Upgrade Transfer: Transfers the Chrome Enterprise upgrade license to another eligible device.Deprovisioning is permanent and removes domain policies from the device. SheetOps strictly requires selecting a Deprovision Reason before applying Deprovisioned status.
Select the checkbox cells in the Apply Changes column for all devices you wish to retire. You can click and drag across multiple rows or select the first cell, hold Shift, click the last cell, and hit Spacebar to check them in bulk.
When the confirmation modal appears, SheetOps alerts you that deprovisioning permanently removes devices from domain management. Confirm the batch action by clicking Yes.
SheetOps dispatches batched requests to the batchChangeStatus API in groups of 50:
Different Model Replacement or Upgrade Transfer is used if your enterprise agreement supports license reallocation.If you select Different Model Replacement, Same Model Replacement (RMA), or Upgrade Transfer under an annual or perpetual license agreement that supports reallocation, the license is returned to your available license pool.
Yes, but re-enrolling a deprovisioned device requires factory wiping the device and performing manual enterprise enrollment with administrator credentials.
Yes. Open Chrome OS Devices → Just the Sheet, paste your serial numbers into the Serial Number column, set the reason and Deprovisioned status, and SheetOps will auto-resolve the underlying device IDs.
Last updated: August 26, 2026

Install SheetOps from the Google Workspace Marketplace today and start performing bulk directory updates, onboarding, and audits directly inside Google Sheets.