Automated PII Removal from CSV Files in Google Drive

• Automatically monitor Google Drive for new CSV files.
• Identify and remove PII columns from sensitive data.
• Streamline data processing workflows for compliance.
• Enhance data privacy and security in file management.

Triggers when a new file is created in a specified Google Drive folder. Downloads the newly created CSV file for processing. Extracts data from the CSV file and identifies PII columns using OpenAI. Removes identified PII columns from the dataset. Uploads the sanitized CSV file back to Google Drive.

1. 1
   Import the workflow template into n8n.
2. 2
   Connect your Google Drive and OpenAI accounts.
3. 3
   Specify the Google Drive folder to monitor for new files.
4. 4
   Test the workflow to ensure it processes files correctly.