What it does
Automatically archives or deletes Google Drive files after a specified expiry period based on file metadata or folder location, keeping Drive clean without manual file management.
Why I recommend it
Drive fills with outdated files that nobody deletes. Automated expiry ensures temporary files (drafts, old reports, project files) don’t clutter Drive forever, improving search and organization.
Expected benefits
- Clean, organized Drive
- Easy file discovery
- Reduced storage costs
- Automatic compliance with retention policies
How it works
Daily/weekly scan of Drive folders -> check file created date or custom expiry metadata -> if past expiration (90 days, 1 year, etc.) -> move to archive folder or delete -> optionally notify file owner before deletion.
Quick start
Manually review your Drive and identify file types that should expire (draft documents >6 months, project files after completion, temp files >30 days). Create archive folders, then automate the expiry logic.
Level-up version
Set custom expiry periods per folder (/temp = 30 days, /projects = 1 year after complete). Send 7-day warning before deletion. Allow extension requests. Track storage saved. Generate reports on expired content.
Tools you can use
Storage: Google Drive
Automation: Google Apps Script, Zapier, Make
Metadata: Drive custom properties for expiry dates
Notifications: Email, Slack
Also works with
Cloud storage: Dropbox, OneDrive, Box
Compliance: Retention policy tools
Backup: Google Vault for permanent archives
Technical implementation solution
- No-code: Google Apps Script scheduled trigger -> list files in specified folders -> check created date -> if older than threshold -> move to /archive or delete.
- API-based: Scheduled job -> Drive API list files with date filters -> check against expiry rules (folder-specific) -> move/delete via API -> send notification email -> log actions for audit.
Where it gets tricky
Avoiding accidental deletion of important files, handling shared files (what if collaborators still need it), determining appropriate expiry periods, and managing exceptions for evergreen content.
