automation production
User Groups Management System
Managers make their own group changes through a self-service sheet, with an audit trail.
- Result
- 80% fewer IT tickets
Tech Stack
Google Apps ScriptGoogle Admin SDKGoogle SheetsSlack API
The Problem
Every group membership change went through IT:
- Manager emails IT
- IT creates ticket
- IT logs into Admin Console
- IT makes change
- IT updates ticket
- IT emails manager
Simple changes took days. IT was drowning in routine requests.
The Solution
A self-service platform managers run themselves:
- Request - Managers request changes directly in Sheets
- Validate - System checks permissions and business rules
- Execute - Approved changes happen automatically
- Notify - Stakeholders informed via Slack
- Audit - Complete history for compliance
The Impact
- IT ticket volume reduced 80% for group changes
- Change time from days to minutes
- Full audit trail for compliance
- Managers handle their own group changes
Technical Details
Integration with Google Admin SDK for group operations. Custom permission model ensures managers can only modify their own groups.
Slack integration provides real-time notifications for requests, approvals, and completions.
Built-in safeguards prevent accidental mass deletions or unauthorized escalations.
Want to talk about this work, a role, or a build for your team?
Let's Talk