Automate Your Google Drive Security Audit
detail.loadingPreview
This n8n workflow automates the process of auditing your Google Drive for external sharing and public links. It generates a comprehensive audit report in a Google Sheet and sends a summary to your inbox, ensuring your data remains secure.
About This Workflow
Gain peace of mind with this powerful n8n workflow designed to proactively manage your Google Drive's security. It intelligently scans your documents, identifies files shared externally or publicly, and compiles this critical information into an organized Google Sheet. A concise email summary is then dispatched to keep you informed of any potential security risks. This automation streamlines the often tedious task of manual auditing, allowing you to quickly identify and address files that require attention, thereby bolstering your organization's data protection strategy.
Key Features
- Automated External Sharing Detection: Identifies files shared with users outside your organization.
- Public Link Monitoring: Flags documents accessible via 'anyone with the link' settings.
- Google Sheets Integration: Generates a detailed audit report directly in a dedicated Google Sheet.
- Email Notification System: Sends timely summaries of audit findings to your inbox.
- Customizable Auditing: Easily adapt the workflow to suit specific team or departmental needs.
How To Use
- Connect Google Drive & Google Sheets: Authorize n8n with your Google account to access Drive and Sheets.
- Configure Google Drive Node: Set up the 'Get Recently Active Documents' node to pull relevant files from your Google Drive.
- Define External Sharing Logic: Adjust the 'Has Shared with External Users' filter to precisely define what constitutes external sharing for your organization (e.g., based on domain).
- Set Up Google Sheets Output: Configure the 'Create New Sheet' node to specify the destination Google Sheet and naming convention for your audit reports.
- Map Data Fields: Use the 'Normalise Fields' node to extract and format necessary file and permission details.
- Configure Email Alerts: Customize the 'Send Email Report' node with your preferred recipient, subject line, and personalized message, including links to the generated audit sheet.
Apps Used
Workflow JSON
{
"id": "0d0ad4be-bb40-4364-b153-236b21658cd5",
"name": "Automate Your Google Drive Security Audit",
"nodes": 27,
"category": "DevOps",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 0d0ad4be-bb40...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Related Workflows
Discover more workflows you might like
Automated PR Merged QA Notifications
Streamline your QA process with this automated workflow that notifies your team upon successful Pull Request merges. Leverage AI and vector stores to enrich notifications and ensure seamless integration into your development pipeline.
Automate Qualys Report Generation and Retrieval
Streamline your Qualys security reporting by automating the generation and retrieval of reports. This workflow ensures timely access to crucial security data without manual intervention.
Visualize Your n8n Workflows: Interactive Dashboard with Mermaid.js
Gain unparalleled visibility into your n8n automation landscape. This workflow transforms your n8n instance into a dynamic, interactive dashboard, leveraging Mermaid.js to visualize all your workflows in one accessible place.