This guide is for the official SheetOps add-on. Install it to manage Google Workspace at spreadsheet speed.
Locking down misplaced laptops, managing seasonal equipment freezes during school holidays, or re-enabling recovered Chromebooks one by one is time-consuming. SheetOps lets Google Workspace administrators bulk disable and re-enable Chrome OS devices instantly from a spreadsheet interface without losing device enrollment.
Disabling is a reversible security state:
Disabled: The device screen locks immediately and displays a customized administrator lock message (e.g., "This device is disabled by IT. Please return to Building A."). The device maintains its enrollment in your domain and retains its Chrome Enterprise license.Active: Re-enabling the device instantly unlocks the hardware upon connecting to the internet, restoring full user access without requiring re-enrollment.SheetOps processes status transitions using the Google Admin Directory API's batchChangeStatus endpoint in chunks of 50 units per request.
| Management Area | Admin Console UI | GAM CLI | SheetOps |
|---|---|---|---|
| Workflow Speed | Click through individual device modals | Terminal scripting with CSV loops | Spreadsheet dropdown toggles in bulk |
| Safety Verification | Basic single confirmation modal | No visual preview before firing | Yellow delta highlights before applying |
| Batch Handling | Limited by table pagination | Sequential CLI commands | Automated 50-device batch requests |
| Audit Trail | Separate Admin Audit log report | Terminal output | Inline real-time spreadsheet Change log |
In Google Sheets, go to Extensions → SheetOps → Chrome OS Devices:
Active or Disabled) or Organizational Unit.Serial Number column.In the Status column:
Select the checkboxes in the Apply Changes column for the rows you want to update. Use click-and-drag or select the range and press Spacebar.
SheetOps calls batchChangeStatus in groups of 50:
Disabled.Disabled devices and batch-updating them to Active.No. Disabling a device simply pauses its operational state while preserving its current Chrome Enterprise license assignment.
Yes. It will display the custom return instructions configured in your Google Admin Console under Devices → Chrome → Settings → Device settings → Disabled device return instructions.
No. Deprovisioning is permanent. A deprovisioned device must be wiped and manually re-enrolled. Disabling, however, is 100% reversible directly from SheetOps.
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.