Automated PII Removal for Your CSV Files in Google Drive
detail.loadingPreview
Securely process your CSV files by automatically identifying and removing Personally Identifiable Information (PII) directly from your Google Drive. This workflow leverages the power of OpenAI to ensure your sensitive data remains protected.
About This Workflow
This workflow automates the critical task of safeguarding sensitive data within your CSV files stored in Google Drive. Upon detecting a new CSV file, it intelligently analyzes the data using OpenAI to pinpoint columns containing PII such as names, emails, or addresses. These identified PII columns are then systematically removed, and a new, sanitized version of the CSV is automatically uploaded back to your Google Drive in a designated 'processed' folder. This ensures your data remains compliant and secure without manual intervention.
Key Features
- Real-time Monitoring: Automatically detects new CSV files added to a specified Google Drive folder.
- Intelligent PII Detection: Utilizes OpenAI's advanced AI to accurately identify columns containing PII.
- Automated Data Sanitization: Removes identified PII columns from the CSV data.
- Seamless Google Drive Integration: Downloads original files and uploads processed files directly to your Google Drive.
- Customizable Storage: Uploads sanitized files to a designated Google Drive folder for easy access.
How To Use
- Connect Google Drive: Authenticate your Google Drive account within n8n.
- Set Up Google Drive Trigger: Configure the 'Google Drive Trigger' node to watch a specific folder for new CSV files.
- Connect OpenAI: Authenticate your OpenAI account in n8n.
- Configure OpenAI Node: Set up the 'OpenAI' node with a system prompt instructing it to identify PII columns and output only the column names.
- Map Data: Use the 'Google Drive' download node to get the content of the triggered file and the 'Extract from File' node to prepare the data.
- Process and Remove PII: The 'Remove PII columns' code node will process the data, using the PII column names from OpenAI to remove them from your CSV.
- Upload Processed File: Configure the 'Upload to Drive' node to save the sanitized CSV to a designated 'processed' folder in your Google Drive.
Apps Used
Workflow JSON
{
"id": "5f16c230-884f-4f83-bd2c-223c40b38b89",
"name": "Automated PII Removal for Your CSV Files in Google Drive",
"nodes": 6,
"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: 5f16c230-884f...
About the Author
AI_Workflow_Bot
LLM Specialist
Building complex chains with OpenAI, Claude, and LangChain.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
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.