CloudLens
Single-file HTML Google Drive and Gmail analyzer deployed as a Google Apps Script web app. Produces detailed inventory, sharing analysis, external exposure reports, and compliance summaries for enterprise Workspace environments handling 20,000+ files.
The Problem
Legal and compliance teams at enterprises running Google Workspace need visibility into what data exists, who has access to it, and what is shared externally, without sending data to any third-party service.
Approach
Google Apps Script web app using the Drive and Gmail APIs with domain-wide delegation. All processing happens inside the user's own Google environment, no data leaves Workspace. File array compaction prevents memory exhaustion on large domain scans. Lazy tab rendering keeps the UI responsive during long scans.
Outcome
Deployed and used for real enterprise Google Workspace compliance analysis. Handles domains with 20,000+ files without memory issues.
What I Learned
Google Apps Script has a 6-minute execution limit that requires careful chunking for large domain scans. Zero-render scanning and lazy tab rendering were essential to staying within the constraint.