# AI-based PII removal from CSV files in Google Drive on file upload
This automation workflow helps securely process CSV files containing personal data without manual intervention. It uses AI to detect columns with personally identifiable information (PII) and automatically sanitizes the files before saving them. The solution is ideal for organizations aiming to comply with data privacy regulations such as GDPR.
## Who it´s for
- Companies processing user data and requiring automatic anonymization
- Legal teams and DPOs responsible for GDPR and other privacy compliance
- Analysts working with CSV data from external sources that may contain PII
## What the automation does
- Monitors a specified Google Drive folder for new CSV files
- Extracts file content and analyzes data structure
- Uses OpenAI to identify columns containing PII (e.g., emails, names, phone numbers)
- Removes detected PII columns
- Saves the sanitized version to a designated folder
- Can be triggered by file upload or scheduled polling
## What´s included
- Ready-to-use n8n workflow
- Trigger and handler logic based on Google Drive and OpenAI
- Integrations with Google Drive API and OpenAI API
- Basic text instructions for setup and adaptation
## Requirements for setup
- Google Drive account with API access
- OpenAI API key
- Accessible n8n instance (cloud or self-hosted)
## Benefits and outcomes
- Eliminates risk of PII leakage during CSV processing
- Saves time on manual review and data cleaning
- Ensures consistent compliance with privacy requirements
- Enables analysts to work with safe, anonymized datasets
- Reduces workload for DPOs and legal teams
- Automates repetitive tasks without development effort
## 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
No feedback yet