What This Workflow Does
This workflow automates the auditing of Google Drive file permissions to help you maintain access control and security across your organization. It runs on a daily schedule, systematically checks file sharing settings, and generates detailed reports in Google Sheets for easy review and compliance tracking.
How It Works
The workflow begins with a scheduled trigger that runs automatically each day at your specified time. It then connects to Google Drive to retrieve files and their current permission settings. The data flows through filter nodes to identify permission anomalies or access issues, which are then organized and formatted in Google Sheets for documentation. Results can optionally be sent via email notifications, and the workflow processes files in batches to handle large volumes efficiently.
- Scheduled daily execution via Scheduled Trigger node
- Retrieves Google Drive files and permission details
- Filters and identifies permission-related security concerns
- Aggregates results for comprehensive audit reporting
- Creates Google Sheet records for compliance documentation
- Sends email summaries to stakeholders
Use Cases
- Enterprise compliance teams auditing file sharing policies across company Google Drive accounts daily
- IT departments monitoring for unauthorized external access to sensitive company documents
- Legal firms tracking client document sharing permissions to maintain confidentiality requirements
- Healthcare organizations ensuring HIPAA-compliant access controls on patient records and files
- Non-profits verifying donor information and grant-related documents remain properly restricted
Nodes Used
- Schedule Trigger – Initiates workflow on daily schedule
- Google Drive – Retrieves files and permission information
- Google Sheets – Stores audit results and creates reports
- Filter – Identifies permission anomalies and access concerns
- Split in Batches – Processes large file volumes efficiently
- Aggregate – Combines permission data for comprehensive reporting
- Set – Configures data variables and transformations
- Gmail – Sends email notifications with audit summaries
- Split Out – Distributes data to multiple processing paths
- No Op – Placeholder for conditional logic flows
- Sticky Note – Provides workflow documentation and notes
Prerequisites
- Active n8n instance or cloud account
- Google account with access to Google Drive and Google Sheets
- Gmail account for sending audit notifications
- Proper Google API credentials configured in n8n
- At least one Google Drive with files to audit
- A Google Sheet where audit results will be stored
Difficulty Level
Intermediate. This workflow requires basic knowledge of n8n node connections and Google service integration. Users should be comfortable configuring OAuth credentials for Google services and understanding basic filtering logic. Some customization of filter conditions may be needed based on your specific permission audit requirements.
This workflow template is shared under the n8n fair-code license. Free to use and modify.
Leave a Reply