💡 New script: drive-cleanup-auditor (Drive storage audit reports in Sheets)

[github-actions[bot]]

Summary

Generates a Google Sheets report of large files, files not accessed in N days, and files with duplicate names across Drive, helping users reclaim storage. Runs on a configurable schedule and writes results to a designated spreadsheet with columns for file name, size, last accessed, owner, and folder path. Read-only — never deletes or modifies files.

Market Signal

Google One storage limits and Drive storage pricing make cleanup a persistent concern for all users. Google's built-in storage manager is interactive-only and doesn't generate exportable reports. No open-source GAS tool produces structured Sheets-based audit reports. The combination of Drive API's file listing capabilities with Sheets output creates a uniquely useful automation that bridges two Google services — the same cross-service pattern that makes this project's existing scripts valuable.

User Signal

The project currently has no script that helps users understand or manage their existing Google Workspace data. All three current scripts create or sync data — none audit what's already there. A cleanup auditor addresses the complementary need: not "automate new work" but "manage what you have." This broadens the project's value proposition from automation-only to automation + visibility.

Technical Opportunity

Uses DriveApp for file listing and SpreadsheetApp for report output — both mature, well-documented GAS services. Follows the calendar-to-sheets pattern (data → Sheets rows). Must handle GAS's 6-minute execution limit with pagination/continuation tokens using ScriptProperties. Config shape: [{folderId (optional, defaults to root), spreadsheetId, sheetName, ageThresholdDays, sizeThresholdMB}]. The batching pattern used by gmail-to-drive-by-labels (process N items per run) is directly reusable.

Assessment

Dimension	Score	Rationale
Feasibility	high	Read-only operation; uses mature GAS services; pagination pattern already proven
Impact	med	Universal need but less frequent than email/calendar automation; broadens catalog scope
Urgency	med	Steady demand; no competitive threat forcing action; strong "nice to have"

Adversarial Review

Strongest objection: Google One already shows storage usage and has a "clean up" feature. The GAS 6-minute execution limit may not be enough for large Drives.

Rebuttal: Google One's tools are interactive and manual — no structured report, no history tracking, no sorting/filtering in Sheets. The Sheets output enables team review, prioritized cleanup, and week-over-week tracking. The 6-minute limit is manageable with pagination: process N files per run, store a continuation token in ScriptProperties, and complete the scan over multiple trigger executions — the same batch pattern used by gmail-to-drive-by-labels.

Suggested Next Step

Design the report schema (columns, sort order, dedup detection algorithm) and implement paginated Drive scanning in src/drive-cleanup-auditor/src/index.js with continuation state stored in ScriptProperties.