Files & Documents
Automatically Remove Personally Identifiable Information from CSV Files with OpenAI
10 nodes
351
163
Automatic trigger
Workflow Description
Automation that monitors a Google Drive folder for new CSV files, extracts data, uses OpenAI to identify and remove personally identifiable information, and saves the sanitized files back to Google Drive securely.
How it works
- 1.Monitor Google Drive folder for incoming CSV files
- 2.Extract and load data from uploaded files
- 3.Send data to OpenAI for PII detection and removal
- 4.Save cleaned files to Google Drive
Use cases
- Sanitize customer data before sharing with analytics teams
- Prepare datasets for third-party integrations while protecting privacy
Requirements
- Active Google Drive account with folder access
- OpenAI API key with sufficient credits
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Google Drive
OpenAI
Details
Trigger
Automatic trigger
Nodes
10
Apps
2
Views
351
Downloads
163
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (10)
Google Drive Trigger
Google Drive Trigger
Google Drive
Google Drive
Extract from File
Extract From File
OpenAI
OpenAI
Merge
Merge
Upload to Drive
Google Drive
Get filename
Split Out
Get result
Split Out
Remove PII columns
Code
Sticky Note
Sticky Note