Scheduled Google Drive Access Audit

# Daily Google Drive permissions audit: report to Sheets and email

This workflow automates data security monitoring in Google Drive by regularly checking file-sharing permissions and promptly identifying risks — such as public links or external access. Ideal for organizations and professionals who need to minimize data leaks and comply with security policies.

## Who it´s for
- Google Workspace administrators responsible for data security
- Information security teams conducting access audits
- Department leads managing document sharing controls
- Freelancers and small businesses using Google Drive and aiming to reduce leakage risks

## What the automation does
- Runs on a schedule (e.g., daily)
- Fetches recently modified files (Docs, Sheets, Slides) from Google Drive
- Filters files shared with external users or via public links
- Normalizes and aggregates permission data
- Appends results to a new sheet in a designated Google Spreadsheet
- Generates a readable report with direct links to flagged files
- Sends the report via Gmail to responsible parties

## What´s included
- Ready-to-use n8n workflow
- Trigger and handler logic based on cron_schedule
- Integrations with Google Drive, Google Sheets, and Gmail
- Basic text instructions for setup and adaptation

## Requirements for setup
- n8n account (cloud or self-hosted)
- Google account with read access to Google Drive files
- Access to a Google Spreadsheet for logging results
- Configured Gmail account for sending reports

## Benefits and outcomes
- Reduced risk of confidential data leaks
- Immediate detection of unsafe sharing practices
- Automated violation logging without manual audits
- Simplified internal compliance and reporting
- Support for building a culture of secure file handling

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat