Audit Google Drive file permissions for access control managemen
This n8n template reviews and audits recently active Google Drive files and reports on files with excessively open permissions. This shows how you can automa...
🔌 Nodes & Integrations Used (3)
📖 Implementation & Setup Guide
This n8n template reviews and audits recently active Google Drive files and reports on files with excessively open permissions. This shows how you can automate simple compliance tasks for access control management.
File Sharing Permissions are routinely abused when access needs and scopes expand to many colleagues, clients and users. Often, granting excessively open permissions means you can get back to work rather than deal with numerous access request notifications. Whilst sometimes justified, the problem is that the permissions are rarely reverted to a safer setting at a later date when it is no longer needed.
This template serves to improve your security posture by giving frequent reminders of these open files so that they can be actioned and not forgotten about.
**See example Audit Report here:** [https://docs.google.com/spreadsheets/d/1V2aiLhp3_nH7EBniMn7D0kFHg7-A5NjpDZXMhb4F5UI/edit?gid=503992967](https://docs.google.com/spreadsheets/d/1V2aiLhp3_nH7EBniMn7D0kFHg7-A5NjpDZXMhb4F5UI/edit?gid=503992967)
How it works * A scheduled trigger runs everyday to generate a new audit report. A new sheet is created in a designated Google Sheets document to store the day's results. * The Google Drive node is used with Advanced Search params to fetch recently modified files for the user with each file result containing the current permission settings. * The results are filtered for those with publicly accessible "anyone with link" and sharing with external users via domain. * The results are then manipulated into rows so that we can append them to the Sheet we created earlier. * The audit Google Sheet is updated with the results and an audit report is sent to the user to action.
How to use * Set the scheduled trigger to a more appropriate interval which works for you or your organisation. * Consider using allowlists for organisations you frequently share with to reduce the number of false positives. * The results can be forwarded to other security or analytical products as required.
Requirements * Google Drive for Document Management * Google Sheet for Reports and Data Collection * Gmail to Email Reports
Customising the workflow * Not using Google? Apply the same approach using Microsoft Sharepoint or Dropbox. * If your security policies require it, you could automate fixing the file permissions as a proactive action instead and notify the user later.
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
Audit_Google_Drive_file_permissions_for_access_control_managemen.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related Email & Outreach Workflows
View All in Email & Outreach →Abandoned cart recovery for Shopify via Gmail Google Sheets T
Who is this for? This template is ideal for solo store owners, eCommerce marketers, automation beginners, or anyone using Shopify and Gmail who wants to reco...
Add new leads in Lemlist from Airtable
This workflow allows you to add new leads in Lemlist from Airtable. !workflow-screenshot Airtable node: This node lists all the emails that are stored in you...
Add Subscriber and Send Email Campaign
Production-ready n8n automation template for Add Subscriber and Send Email Campaign built by AhiXLight. Seamlessly connects Sendy with 3 configured nodes.
Add new contacts from HubSpot to the email list in Mailchimp
This workflow adds new HubSpot contacts to the Mailchimp email list. Prerequisites - HubSpot account and HubSpot credentials - Mailchimp account and Mailchim...