Google Workspace Admin Dashboard for Sheets

Problem Context

Sysadmins manage Google Workspace (GWS) for large organizations like universities. They rely on Google Sheets add-ons like OkGoldy and BulkyDuce to create users, manage groups, and handle daily requests. These tools suddenly stopped working, forcing them back to manual CSV/GAM CLI methods, which are slow and error-prone.

Pain Points

The add-ons they depended on (OkGoldy, BulkyDuce) are broken, leaving them with no GUI alternative. GAM (Google Admin CLI) is too technical for their workflow, and native GWS admin console lacks bulk operations. They waste hours on manual tasks that should be automated, and broken tools disrupt their entire workflow.

Impact

Downtime in user/group management means delayed access for employees/students, lost productivity, and frustration. Sysadmins spend 5+ hours/week on manual workarounds instead of strategic IT tasks. If a tool fails during onboarding (e.g., new semester), it creates chaos across the organization.

Urgency

This is a mission-critical issue—without a working GUI, admins can’t efficiently manage accounts, groups, or permissions. Every day without a solution means more manual labor, higher error rates, and risk of compliance violations (e.g., unauthorized access). They need a replacement now.

Target Audience

Sysadmins in higher education, enterprises, and government organizations using Google Workspace. IT teams at universities, hospitals, and corporations with 1,000+ users face the same problem. Smaller businesses with GWS also struggle but may lack budget for enterprise tools.

Solution Approach

A Google Sheets add-on that replaces broken tools like OkGoldy/BulkyDuce with a modern, reliable GUI for GWS management. It syncs directly with Google Workspace’s API to create users, manage groups, and handle permissions—all from a familiar Sheets interface. No CLI, no CSV exports, just point-and-click admin tools.

Key Features

1. Group Management: Add/remove members from GWS groups with drag-and-drop.
2. Permission Controls: Set OU (Organizational Unit) permissions and app access via dropdowns.
3. Audit Logs: Track changes (e.g., ‘User X added to Group Y’) in a timestamped sheet.

User Experience

Admins open Google Sheets, click the add-on, and see a familiar grid for users/groups. They edit cells (e.g., ‘First Name’, ‘Group Membership’) and hit ‘Apply’—changes sync to GWS instantly. No terminal commands, no waiting for CSVs. They get real-time feedback (e.g., ‘Success: 5 users updated’) and can revert mistakes with one click.

Differentiation

Unlike GAM CLI (too technical) or native GWS console (clunky), this is a *GUI-first- tool built for admins. It’s faster than manual CSV work, more reliable than broken add-ons, and easier than training staff on CLI. The Sheets integration means zero onboarding—admins already know how to use it.

Scalability

Starts with core features (users/groups) but adds modules over time: SSO integration, Slack alerts for changes, and API access for custom scripts. Pricing scales with team size (e.g., $29/user for <10 admins, $19/user for 50+). Enterprises can white-label it for their IT teams.

Expected Impact

Admins save 5+ hours/week on manual tasks and eliminate errors from CSV/GAM work. Organizations avoid downtime during critical periods (e.g., student onboarding). The tool becomes a ‘must-have’ for GWS admins—without it, their workflows break. Teams can focus on security/compliance instead of spreadsheets.