Remove personally identifiable information PII from CSV files
What this workflow does - Monitors Google Drive: The workflow triggers whenever a new CSV file is uploaded. - Uses AI to Identify PII Columns: The OpenAI nod...
🔌 Nodes & Integrations Used (4)
📖 Implementation & Setup Guide
What this workflow does - Monitors Google Drive: The workflow triggers whenever a new CSV file is uploaded. - Uses AI to Identify PII Columns: The OpenAI node analyzes the data and identifies PII-containing columns (e.g., name, email, phone). - Removes PII: The workflow filters out these columns from the dataset. - Uploads Cleaned File: The sanitized file is renamed and re-uploaded to Google Drive, ensuring the original data remains intact.
How to customize this workflow to your needs - Adjust PII Identification: Modify the prompt in the OpenAI node to align with your specific data compliance requirements. - Include/Exclude File Types: Adjust the Google Drive Trigger settings to monitor specific file types (e.g., CSV only). - Output Destination: Change the folder in Google Drive where the sanitized file is uploaded.
Setup ### Prerequisites: - A Google Drive account. - An OpenAI API key. ### Workflow Configuration: - Configure the Google Drive Trigger to monitor a folder for new files. - Configure the OpenAI Node to connect with your API - Set the Google Drive Upload folder to a different location than the Trigger folder to prevent workflow loops.
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
Remove_personally_identifiable_information_PII_from_CSV_files.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related Docs, PDF & OCR Workflows
View All in Docs, PDF & OCR →Add articles to a Notion list by accessing a Discord slash comma
This workflow allows you to add articles to a Notion reading list by accessing a Discord slash command. Prerequisites - A Notion account and [credentials](),...
Adobe PDF Services API Automation
Production-ready n8n automation template for Adobe PDF Services API Automation built by AhiXLight. Seamlessly connects HTTP Request, Execute Workflow Trigger, Dropbox with 20 configured nodes.
Adobe PDF Services API Workflow
Production-ready n8n automation template for Adobe PDF Services API Workflow built by AhiXLight. Seamlessly connects HTTP Request, Execute Workflow Trigger, Dropbox with 20 configured nodes.
AI Brand Voice Content Generator
Production-ready n8n automation template for AI Brand Voice Content Generator built by AhiXLight. Seamlessly connects Lm Chat Open Ai, Information Extractor, HTTP Request with 27 configured nodes.