How to Automate Google Drive Permission Audits?
Description
Keep shared files under control with a daily Google Drive audit that finds risky sharing and sends a clear report. Ideal for IT and operations teams that need quick visibility on who has access without manual checks.
A scheduled run creates a fresh tab in a Google Sheets report, pulls recently changed Google Docs, Sheets, and Slides, and reads their sharing settings. Items that are public or shared with outside domains are flagged. The flow removes the owner from the results, breaks down each permission into simple rows, and writes them to the new sheet. After logging the data, Gmail sends a summary with a link to the report so someone can take action.
Setup is simple if you use Google Drive, Google Sheets, and Gmail. Point the sheet node to your report spreadsheet, set the run time, and adjust the date range or allowed domains if needed. Teams usually cut review time from hours to minutes and can run daily or weekly checks depending on risk. This is useful for client facing teams, agencies, and any group that shares files often.
Tools Required
What this workflow does?
- Daily schedule creates a new report tab with the current date
- Google Drive query scans files changed in the last 24 hours
- Filters highlight public link sharing and external domain access
- Owner permissions are excluded to focus on real exposure
- Permissions are split and normalized into clean sheet rows
- Rows are appended to Google Sheets for an auditable log
- Gmail sends a one time email summary with the report link
- Batch processing handles each file safely and at scale
What are the benefits?
- Reduce manual review from 2 hours to 10 minutes per day
- Automate over 90 percent of permission checks on recent files
- Lower access risk by flagging public and external shares fast
- Improve report accuracy by removing owner entries and duplicates
- Connect Google Drive, Google Sheets, and Gmail in one flow
How to set this up?
- Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
- You'll need accounts with Google Drive, Google Sheets and Gmail. See the Tools Required section above for links to create accounts with these services.
- In n8n Cloud, open the Google Drive node named Get Recently Active Documents. In the Credential to connect with menu, click Create new credential and follow the on screen steps to connect your Google Drive with OAuth2.
- Open the Google Sheets nodes Create New Sheet and Append to New Sheet. For each, create a new Google Sheets OAuth2 credential and authorize access. Use a clear credential name so your team can recognize it later.
- Open the Gmail node Send Email Report. Create a new Gmail OAuth2 credential and allow the send email scope. Save the credential with a descriptive name.
- In Create New Sheet, confirm the spreadsheet ID points to your audit workbook. Keep the sheet title formula with the date so a new tab is created each run.
- In Get Recently Active Documents, adjust the query if you want a longer time window. For example, change days to 7 to scan the last week.
- Open the Has Shared with External Users filter and review conditions. Add or remove allowed domains to match your company policy.
- Check the Filter Out Owner of Document node to ensure owner emails are excluded from the report.
- In the Gmail node, set the To address to your distribution list or security inbox. Update the subject and message if needed.
- Set the Schedule Trigger to the hour your team prefers. Save the workflow and enable it.
- Run a manual test once. Confirm a new tab appears in your Google Sheets workbook and that rows list file name, id, and permission details.
- Verify that an email arrives from Gmail with a link to the report tab. If it does not, recheck the Gmail credential and recipient address.
- Troubleshooting: If no files appear, loosen the date filter. If permission data is missing, reauthorize Google Drive with the correct scopes. If the sheet fails to update, verify spreadsheet permissions for your Google Sheets account.
Need help or want to customize this?
Ask in the Futurise Pro Community.
Similar Templates
These templates were sourced from publicly available materials across the web, including n8n’s official website, YouTube and public GitHub repositories. We have consolidated and categorized them for easy search and filtering, and supplemented them with links to integrations, step-by-step setup instructions, and personalized support in the Futurise community. Content in this library is provided for education, evaluation and internal use. Users are responsible for checking and complying with the license terms with the author of the templates before commercial use or redistribution.Where an original author was identified, attribution has been provided. Some templates did not include author information. If you know who created this template, please let us know so we can add the appropriate credit and reference link. If you are the author and would like this template removed from the library, email us at info@futurise.com and we will remove it promptly.
