Getting Started

SheetOps is a premium Google Sheets™ add-on designed for Google Workspace IT administrators. It allows you to perform bulk operations—such as creating, updating, suspending, archiving, and deleting users, groups, members, and organizational units—directly from your spreadsheet.

Instead of navigating the complex Google Admin Console or writing custom Apps Script code, SheetOps provides a spreadsheet interface with real-time change tracking and validation.

What Can You Bulk Manage with SheetOps?

Bulk User Management: Create, update, suspend, archive, and delete users. Change passwords and manage email aliases in bulk.
Group & Member Administration: Create groups, update names/descriptions, add/remove members, and assign roles (OWNER, MANAGER, MEMBER).
Organizational Unit (OU) CRUD: Create, rename, move, and delete OUs.

How to Install SheetOps from Google Workspace Marketplace

Marketplace Installation: Go to the SheetOps Google Workspace Marketplace Listing and click Install.
Authorize Permissions: Choose your Google Workspace administrator account. You will be prompted to grant the necessary OAuth permissions.

[!IMPORTANT] You must sign in using a Google Workspace account with administrative privileges (e.g., Super Admin or Delegated Admin) for the Admin Directory APIs to function.
Open the Add-on: Create a new Google Sheet, go to Extensions → SheetOps → and select one of the admin modules: Users, Groups, Members, or Org Units.

Why Does SheetOps Require Google Directory API Scopes?

SheetOps requests only the permissions required to manage your directory:

admin.directory.user, admin.directory.group, admin.directory.orgunit: To perform CRUD operations on your workspace directory.
spreadsheets.currentonly: To write data, apply formatting, and set up validation dropdowns within the active sheet only.
script.scriptapp: To create an installable onEdit trigger that tracks spreadsheet edits.
script.external_request: To communicate with the SheetOps backend for license verification.

Understanding the SheetOps Onboarding and Trigger Security

When you launch SheetOps for the first time:

An Onboarding Dialog will prompt you to initialize the add-on.
Clicking Get Started sets up an installable onEdit trigger linked to your email (triggerUser).
Only the triggerUser can check the Apply Changes checkboxes to run API updates, preventing security issues if the sheet is shared.

SheetOps Quota Limits and License Management

SheetOps operates on a freemium model:

Unlimited Reads: Exporting users, groups, members, and organizational units is 100% free and unlimited.
20 Free Writes: Free accounts are limited to 20 successful write operations (creations, updates, or deletions combined).
Upgrading: Once you reach the 20-write threshold, further operations are blocked. A popup dialog will guide you to upgrade to a premium license.

Frequently Asked Questions (FAQ)

What is the Google Workspace bulk user creation limit in SheetOps?

The Google Apps Script runtime environment has a 6-minute execution limit. For bulk user creation, SheetOps can safely create 100–200 users per batch. If you have thousands of users to create, check the 'Apply Changes' checkboxes in batches of 150 rows.

Is SheetOps safe to use on my Google Workspace domain?

Yes. SheetOps runs entirely within the Google Apps Script container of your spreadsheet. It requests OAuth access to your Admin Directory to perform actions on your behalf, and does not store or transmit your directory data to third-party servers.

Why do cells turn yellow in SheetOps?

Yellow highlights are a safety feature called visual diffs. Whenever you edit a cell in the sheet, SheetOps detects the edit, compares it against a hidden reference sheet, and highlights it yellow. This shows you exactly what changes will be sent to the API when you apply changes.

Last updated: June 16, 2026