Google Drive CSV PII Remover
detail.loadingPreview
Automatically removes Personally Identifiable Information (PII) from CSV files uploaded to Google Drive.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This workflow automates the process of monitoring a specified Google Drive folder for new CSV files. Upon detecting a new file, it downloads the file, uses OpenAI to identify columns containing Personally Identifiable Information (PII), removes these columns, and then uploads a sanitized version of the CSV file back to a designated Google Drive folder. This ensures data privacy and compliance by stripping sensitive information.
Key Features
- Monitors Google Drive for new CSV files.
- Utilizes OpenAI to intelligently identify PII columns.
- Removes identified PII columns from the CSV data.
- Uploads the sanitized CSV file to a specified Google Drive folder.
- Renames the sanitized file to indicate PII removal.
How To Use
- Configure Google Drive Credentials: Set up your Google Drive OAuth2 API credentials in n8n.
- Configure OpenAI Credentials: Set up your OpenAI API credentials in n8n.
- Set Google Drive Folder: Specify the Google Drive folder to monitor for new CSV files.
- Set Output Google Drive Folder: Specify the Google Drive folder where the sanitized CSV files should be uploaded.
- Import the Workflow: Import this JSON into your n8n instance.
- Run the Workflow: The workflow will trigger automatically when new CSV files are added to the monitored folder.
Apps Used
Workflow JSON
{
"id": "1f196955-7dd2-4269-be71-3a7cf20c5b39",
"name": "Google Drive CSV PII Remover",
"nodes": 0,
"category": "Data Processing",
"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: 1f196955-7dd2...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Verification Info
Related Workflows
Discover more workflows you might like
Remove PII From CSV Files
Automatically removes personally identifiable information (PII) from CSV files stored in Google Drive.
Get n8n Executions to CSV
Retrieve all n8n workflow executions and convert them to a CSV file.
Airtable Receipt OCR Integration
Extracts data from receipts using Mindee OCR and stores it in Airtable.
Parse DMARC Reports
This workflow parses DMARC reports received via IMAP and stores the data in a MySQL database.
Extract and Process Product Brochure
Extracts text from a product brochure PDF, creates embeddings, and stores them for querying.
Community Campaign Data Processor
Processes and updates campaign data from external sources into a PostgreSQL database.