Automate Google Drive Permissions Audit to Google Sheets

• Regularly audit Google Drive files for permission settings
• Identify documents shared with external users or publicly
• Automate reporting of access control risks to stakeholders
• Maintain compliance with data protection regulations
• Streamline document management and security processes

Scheduled trigger initiates the workflow daily Fetch recently modified documents from Google Drive Filter documents based on sharing permissions Normalize and aggregate data for reporting Append results to a new Google Sheet Send an email report summarizing findings

1. 1
   Import the workflow template into n8n
2. 2
   Configure Google Drive, Google Sheets, and Gmail credentials
3. 3
   Set the desired schedule for the trigger
4. 4
   Adjust any parameters as needed for your organization
5. 5
   Activate the workflow to start auditing permissions