Google Workspace™ Marketplace Certified

Bulk Manage Google Workspace
at Spreadsheet Speed

A visual, sheet-based alternative to the Google Workspace Admin Console. Bulk create, update, and sync users, groups, and org units in clicks—without writing command-line scripts or wrestling with raw CSV imports.

Free tier included • No credit card required

Zero Scripting Required
Immediate Safety Highlights
Secure Google OAuth API Sync
SheetOps Workspace Sync
Sync Config|Status: Connected
A (Email)B (Role)C (Status)
1[email protected]AdminActive
2[email protected]Manager *Active *
3[email protected]MemberActive
4[email protected]MemberSuspended *
Ready to Sync (3 changes detected)

Why workspace administration feels so painful

Managing directory entries at scale forces you to choose between two equally frustrating options.

Option A: The Click-Heavy Console

Google Workspace Admin Console is fine for a single change, but performing bulk tasks (like onboarding 50 new hires or updating 12 groups) is tedious.

Workspace Admin Console Loading...
1Click Directory > Users
2Click "Add New User" > Fill form details
3Click Save > Wait for API response (3s)
Repeat 49 more times...
Time wasted: ~2 hours of mind-numbing clicking.

Option B: The Command Line Cliff

Command line interfaces (like GAM) are fast but dangerous. There are no safety nets—one minor syntax mistake or mismatched column headers can suspension-lock the wrong accounts instantly.

Terminal (bash) Syntax warning
$ gam csv users.csv gam update user ~Email ou ~OU suspend ~Status
ERROR: Field 'suspend' expected Boolean value, got 'Suspended' on line 42. Execution halted.
Did it run half of the updates, or none? Hitting Enter triggers anxiety.
Risk: One typo can disrupt operations for an entire department.

See SheetOps in action

Interactive Simulator: Trigger Google Workspace directory updates directly from spreadsheet rows.

SetupStart by clicking "1. Simulate Edits" above. This mocks changing a user's name and suspending an account in the grid.
SheetOps Users Spreadsheet
EmailFirst NameLast NameStatusApply ChangesChange Log
1[email protected]JohnDoeActive
2[email protected]JaneSmithActive
3[email protected]BobJonesActive
4[email protected]AliceWilliamsActive
5

Complete Workspace Administration, Simplified

SheetOps bridges the gap between directory APIs and spreadsheets to give you total control.

Users Management

Perform batch user directory lifecycle edits without navigating complex Google Admin Console menus.

  • Onboard & offboard employees in batches — import, create, suspend, or delete accounts in one sync.
  • Manage multiple email aliases in a single cell.
  • Reset user passwords in bulk with automatic cell-clearing for security.

Google Groups Sync

Update high-volume mailing lists and membership permissions in one sync.

  • Update distribution lists instantly — add or remove hundreds of members and external partners without clicking through menus.
  • Update member permissions and directory roles (Owner, Manager, Member).
  • Track and modify group-level aliases.

Organizational Units (OUs)

Keep your directory structure organized with instant parent-child unit mapping.

  • Map structures visually — create nested OUs in bulk by listing parent paths and names (e.g., /Sales/US) directly in cells.
  • Bulk move users across nested OU tree paths.
  • Rename deep OUs without breaking current user profiles.

Smart Filters & Exports

Extract exactly the records you need instead of downloading full CSV directories.

  • Generate org reports instantly — export users grouped by direct manager chains or status filters.
  • Filter users by status (active, suspended, delegated admin).
  • Download OU structures directly into Google Sheets.

A visual safety net for command-line speed

Enjoy the productivity of command-line scripts with the safety and clarity of a visual grid.

Command Line (GAM CLI)

Fast, but error-prone and code-heavy

# Bulk suspend users from CSV
$ gam csv users.csv gam update user ~Email OU "/Suspended Users" suspended true
Error: Path not found. (Did it suspend any users? No logs.)
  • Zero Dry-Runs — Commands execute immediately in the cloud with no preview.
  • Anxious Execution — A single column typo can update thousands of records incorrectly.
  • Requires Scripting — Admin team members must learn terminal syntax and token secrets.

SheetOps Workspace Sync

Visual, controlled, and collaborative

SheetOps Sheet✓ Validation Checked
[email protected]Suspended *Queue [✓]
[email protected]Active✓ Synced
  • Visual Verification — Changes highlight in pastel yellow before you sync.
  • Selective Sync — Use standard checkboxes to choose exactly which rows sync and which remain unchanged.
  • Delegate with Confidence — Safe, collaborative spreadsheet rows allow HR and support staff to run updates without CLI training.

Simple, Transparent Pricing

Start completely free to evaluate, then upgrade to support unlimited updates. No credit card required.

Free Tier

Evaluate SheetOps with no limits on read ops

$0/ forever
  • 20 free writes per sync (creates, updates, deletes) to test all features.
  • Unlimited read operations & exports from Google Workspace.
  • Smart filters & directory search queries forever.
Popular

Premium Plan

For administrators and HR managers

$25/ month

Or $199 billed annually (~$16.50/mo)

  • Unlimited bulk writes, updates, and organizational creations.
  • Automated safety checks & delta validation highlights.
  • Priority email support directly from engineering.

Frequently Asked Questions

Everything you need to know about security, change tracking, and licenses.

Yes, absolutely. SheetOps runs entirely within the secure Google Apps Script runtime. Your OAuth access credentials never leave Google’s infrastructure. Your directory details flow directly between your Google Spreadsheet and the Google Workspace Admin Directory APIs. We never store, proxy, or inspect your user lists or company data on external servers.
When you import a directory segment, SheetOps creates a hidden, read-only baseline sheet to store the original state. As you edit user names, roles, or organizational units, the add-on dynamically compares your active sheet with this baseline. Changed values are immediately highlighted in pastel yellow so you can review what changes will run in the cloud.
Yes. The SheetOps schema contains designated columns for email aliases and mailing list roles. You can bulk-update aliases by typing comma-separated values in the Aliases column. Group roles (Owner, Manager, Member) are controlled via a simple dropdown list, and sync back to your groups in seconds.
No local files, terminal CLI tools, or browser extensions are required. SheetOps is a certified Google Workspace Add-on. You install it directly from the Google Workspace Marketplace. Once installed, it is instantly available inside any spreadsheet on Google Sheets, across any desktop operating system.
No. Licensing is per administrator seat (the Google Workspace account running the SheetOps add-on). You can manage a directory of 10,000 users with a single $25/month SheetOps license.