Audit Google Drive File Permissions for Access Control

This n8n workflow automates the auditing of recently active Google Drive files to identify those with excessively open permissions, such as 'anyone with the link' or sharing with external domains. It runs on a daily schedule, using advanced Google Drive search to fetch modified files and their permission settings. Results are filtered for risky shares, formatted into rows, and appended to a new sheet in a designated Google Sheets document. An audit report is then emailed to the user for review and action.

The primary benefit is improved security posture by proactively reminding teams about forgotten open permissions, reducing risks of data leaks or unauthorized access. It's ideal for organizations handling sensitive data in Health & Fitness sectors, like client records or proprietary workout plans, where compliance with access controls is crucial. This prevents permission creep from collaborative work turning into vulnerabilities.

Use cases include routine compliance checks for SMBs, automated security hygiene for marketing teams sharing assets, or IT admins monitoring Drive usage. Easy to customize: adjust search params for recency, filter criteria for specific domains, or schedule frequency. Integrates seamlessly with Google Workspace, saving hours of manual audits weekly and ensuring consistent reporting.