Remove PII From CSV Files
detail.loadingPreview
Automatically removes personally identifiable information (PII) from CSV files stored in Google Drive.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This workflow automatically detects new CSV files in a specified Google Drive folder. It then uses OpenAI to analyze the file's structure and identify columns containing Personally Identifiable Information (PII). Finally, it removes these PII columns and uploads a sanitized version of the CSV back to Google Drive.
Key Features
- Monitors Google Drive for new CSV files.
- Utilizes OpenAI to identify PII columns.
- Removes identified PII columns from the data.
- Saves the PII-removed CSV file back to Google Drive.
How To Use
- Import this workflow into your n8n instance.
- Configure the
Google Drive Triggerwith the folder ID containing your CSV files. - Set up Google Drive credentials for reading and writing files.
- Configure OpenAI credentials.
- Ensure the output folder in the
Upload to Drivenode is correctly set. - The workflow will automatically process new CSV files added to the trigger folder.
Apps Used
Workflow JSON
{
"id": "491176d9-d6c6-4953-b7a8-624be4f79dbc",
"name": "Remove PII From CSV Files",
"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: 491176d9-d6c6...
About the Author
DevOps_Master_X
Infrastructure Expert
Specializing in CI/CD pipelines, Docker, and Kubernetes automations.
Statistics
Verification Info
Related Integrations
- Google Sheets + Schedule Trigger(394 workflows)
- Google Sheets + Split Out(277 workflows)
- Google Sheets + Slack(268 workflows)
- Gmail + Google Sheets(245 workflows)
- Google Drive + Google Sheets(203 workflows)
- Form Trigger + Google Sheets(163 workflows)
- Google Drive + Google Drive Trigger(135 workflows)
- Google Drive + Split Out(134 workflows)
- Google Sheets + Telegram(118 workflows)
- Execute Workflow Trigger + Google Sheets(101 workflows)
Related Workflows
Discover more workflows you might like
Google Drive CSV PII Remover
Automatically removes Personally Identifiable Information (PII) from CSV files uploaded to Google Drive.
Get n8n Executions to CSV
Retrieve all n8n workflow executions and convert them to a CSV file.
Extract and Process Product Brochure
Extracts text from a product brochure PDF, creates embeddings, and stores them for querying.
Stripe Checkout Session Metadata Generator
Generates metadata for Stripe checkout sessions based on custom fields.
Extract and Process CV Data
Extracts information from uploaded CVs, processes it, and saves it to Google Sheets.
Parse DMARC Reports
This workflow parses DMARC reports received via IMAP and stores the data in a MySQL database.