This guide is for the official SheetOps add-on. Install it to manage Google Workspace at spreadsheet speed.
Resetting shared student laptops before standardized testing, clearing stale user caches, or powerwashing returning fleet devices in the Google Admin Console requires navigating individual device profiles. SheetOps lets IT administrators issue bulk remote commands including Remote Powerwash, Wipe Users, and Reboot across entire device rosters directly from Google Sheets.
Google Workspace allows administrators to send cloud-queued instructions directly to enrolled Chrome OS hardware:
REMOTE_POWERWASH: Performs a factory reset, removing all data including user profiles, device policies, and enrollment policies. The device reverts to a factory state with no enrollment unless it is subject to forced or auto-enrollment.WIPE_USERS: Clears all local user profile data and cache while preserving device policies and enterprise enrollment.REBOOT: Instantly restarts active devices upon their next network check-in.SheetOps interacts with the Google Admin Directory REST API's issueCommand endpoint to queue commands in parallel across hundreds of selected devices.
| Operational Feature | Admin Console UI | GAM CLI | SheetOps |
|---|---|---|---|
| Command Execution | One device at a time from detail pages | Terminal commands piped through CSV | Instant spreadsheet dropdown selection |
| Multi-Command Flexibility | Cannot mix commands in a single view | Requires separate terminal scripts per action | Assign different commands per row in one sheet |
| Status Feedback | No inline batch receipt | Terminal stdout scrollback | Real-time change log with command audit string |
| Post-Execution Safety | No cell state tracking | CLI history only | Auto-clears command cell after queueing |
In Google Sheets, go to Extensions → SheetOps → Chrome OS Devices:
Serial Number column.Locate the Remote Command (or Command) column:
Wipe Users: Erases user profiles while keeping device policies and domain enrollment intact.Remote Powerwash: Factory resets the device, removing all data, device policies, and enrollment policies (re-enrolls automatically if forced/auto-enrollment is enabled).Reboot: Triggers a restart on target laptops.Mark the checkboxes in the Apply Changes column for all hardware rows requiring remote instructions.
SheetOps dispatches issueCommand API calls:
Wipe Users across OUs 24 hours before standardized testing to eliminate cached login tokens and temporary files.Remote Powerwash as student laptops are checked in. If forced re-enrollment is configured, the laptop will automatically re-enroll when powered on and connected to Wi-Fi.Reboot command across your kiosk inventory sheet.REMOTE_POWERWASH removes all user profiles, device policies, and enrollment policies, reverting the Chromebook to an unenrolled factory state unless the device is configured for forced or auto-enrollment in your Google Workspace admin settings. If forced re-enrollment is enabled, the device will automatically re-enroll upon connecting to the network. If you only want to clear local user profiles and caches while keeping device policies and domain enrollment intact, use WIPE_USERS instead.
Commands execute the moment the device connects to the internet and checks in with Google's servers. If the device is currently offline or asleep, the command stays queued until it is powered on.
Yes. You can set some rows to Reboot and other rows to Remote Powerwash in the same spreadsheet. SheetOps processes each row according to its selected command.
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.