Document compliance audit
Every quarter the accounting team checked 100+ contractors by hand: each must have three required documents in Google Drive, filed by Year → Quarter → Contractor → Project. Hundreds of folders, checked manually, a high risk of missing one — three days of work.
- Pulls the current list of projects from Google Sheets
- Scans the Drive folder structure
- Verifies each of the three required files is present
- Logs every missing document
- Builds a discrepancy report and sends the manager the link
Result: 3 days → 5 minutes, on a schedule.
100% accuracy — the system never tires and never skips a file.