Automate PII Removal from CSVs in Google Drive
detail.loadingPreview
Automatically detect and remove Personally Identifiable Information (PII) from CSV files uploaded to Google Drive. This workflow ensures data privacy by using OpenAI to identify sensitive columns and then creating a PII-free version of your file.
About This Workflow
This automated workflow streamlines the critical task of data privacy by intelligently removing Personally Identifiable Information (PII) from your CSV files. It seamlessly monitors a designated Google Drive folder for new CSV uploads. Upon detection, it leverages the power of OpenAI's advanced language models to analyze the file's structure and identify columns containing sensitive data. Once PII columns are pinpointed, the workflow automatically creates a new version of the CSV file with these columns removed, saving the sanitized file back to Google Drive. This ensures your data is compliant with privacy regulations and reduces manual effort in data preparation and anonymization.
Key Features
- Real-time Google Drive Monitoring: Automatically triggers on new CSV files added to a specified Google Drive folder.
- AI-Powered PII Detection: Utilizes OpenAI's intelligence to accurately identify columns containing PII.
- Automated PII Column Removal: Creates a new CSV file with identified PII columns automatically removed.
- Configurable Folder Watch: Easily set up which Google Drive folder to monitor.
- Secure Data Handling: Maintains data privacy throughout the automated process.
How To Use
- Connect Google Drive: Authorize n8n to access your Google Drive account.
- Specify Google Drive Folder: Configure the "Google Drive Trigger" node to watch a specific folder for new CSV files.
- Connect OpenAI: Set up your OpenAI API credentials in n8n.
- Define PII Analysis Prompt: The "OpenAI" node is pre-configured with a prompt to identify PII columns. You can adjust this prompt if needed for specific use cases.
- Review and Test: Execute the workflow with a test CSV file in your monitored Google Drive folder. Check the "processed" folder for the PII-removed version.
Apps Used
Workflow JSON
{
"id": "61ea8ca1-9ed0-48dc-85b6-46b5a99ac848",
"name": "Automate PII Removal from CSVs in Google Drive",
"nodes": 14,
"category": "Operations",
"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: 61ea8ca1-9ed0...
About the Author
Free n8n Workflows Official
System Admin
The official repository for verified enterprise-grade workflows.
Statistics
Related Workflows
Discover more workflows you might like
Google Sheets to Icypeas: Automated Bulk Domain Scanning
This workflow streamlines the process of performing bulk domain scans by integrating your Google Sheets data directly with the Icypeas platform. Automate the submission of company names from your spreadsheet to Icypeas for comprehensive domain information, saving valuable time and effort.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.