Remove personally identifiable information (PII) from CSV files with OpenAI
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 9 nodes and runs on Google Drive events (file created). Along the way it connects Google Drive and OpenAI.
How it runs
Trigger: On Google Drive events (file created).
- Get filename (Split Out): splits a list into separate items
- Google Drive: download
- Merge: merges the data from its input branches
- Extract from File: extracts data from a file
- Remove PII columns (Code): runs custom JavaScript code
- OpenAI: uses OpenAI
- Upload to Drive (Google Drive): create from text
- Get result (Split Out): splits a list into separate items
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Google Drive
n8n-nodes-base.googleDrive - Extract from File
n8n-nodes-base.extractFromFile - OpenAI
@n8n/n8n-nodes-langchain.openAi - Merge
n8n-nodes-base.merge - Split Out
n8n-nodes-base.splitOut - Code
n8n-nodes-base.code
From the author
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:…