The challenge: files and operational processes had grown beyond informal sharing
An engineering and field operations company with approximately 140 employees had accumulated around 2.8 TB of data across 112 My Drives. Dispersed ownership and storage made it harder to find information consistently and manage retention and access controls.
The organization needed more than a file cleanup. It needed a clearer information structure, governance rules, and automation for recurring operational tasks.
The implementation
Our team helped organize the Google Workspace environment around Shared Drives and governance practices. The source describes work involving Google Vault retention, data loss prevention controls, and six automations using AppSheet and Apps Script.
These components address different layers of the problem:
- Shared Drives provide an organization-centered location for shared business information.
- Vault retention supports defined retention and e-discovery requirements where configured appropriately.
- Data controls help establish how information is handled.
- AppSheet and Apps Script reduce manual steps in repeatable workflows.
The key implementation principle is to align information architecture and automation with how teams actually work. Moving files without clarifying ownership and retention rules can simply reproduce the original disorder in a new location.
Reported impact
The source records the following outcomes:
- Approximately 65% faster information retrieval
- 1.1 TB of duplicate storage eliminated
- Compliance review time reduced to hours
- Approximately $18,000 per year recovered
These figures should be verified against the client's approved measurement method before publication. They are retained from the source and have not been independently audited in this document.
Lessons for organizations using Google Workspace
A governance project should begin with an inventory of where information lives, who owns it, how it is shared, and what retention rules apply. Automation should follow the process review rather than be layered onto unclear ownership and inconsistent data.
For organizations with field teams, multiple departments, or large volumes of shared files, a combination of information architecture, retention configuration, and targeted automation may be more effective than treating each issue as an isolated IT task.
If Google Workspace has become difficult to govern or search, an assessment of storage, ownership, retention, and recurring manual workflows can identify the highest-value improvements.
