Curated

(5/5)

Remove Personally Identifiable Information (PII) from CSV Files with OpenAI

Remove PII from CSV Files This workflow monitors a Google Drive folder for new CSV files, identifies and removes PII columns using OpenAI, and uploads the sanitized file back to the drive. It requires Google Drive and OpenAI integrations with API access enabled.

Integrations Used (2)

Google Drive

OpenAI

Workflow Structure (9 nodes)

100%

Google Drive Trigger

Google Drive

Langchain.open Ai

OpenAI

Split Out

Get filename

Split Out

Get result

Extract From File

Extract from File

Merge

Code

Remove PII columns

Google Drive

Upload to Drive

Node Types:

trigger

action

default

logic

code

Requires credentials

Prerequisites

Required Credentials (2)

Google Drive

Used by: Google Drive Trigger, Google Drive +1 more

Docs

OpenAI

Used by: OpenAI

Docs

Complexity

Complex

Advanced features used. Requires n8n experience.

Setup time: ~35 min

Score: 56/100

Custom Code

Conditional Logic

When to Use This Workflow

Real-time Response

React instantly when events happen - new orders, form submissions, or API calls.

Zero delay between trigger and action for time-sensitive workflows.

Time Savings

Replace repetitive manual tasks with reliable automation.

Reclaim hours every week for higher-value work.

Error Reduction

Eliminate human error from routine processes with consistent automation.

Improve accuracy and reliability across your workflows.

workflow.json

{
  "meta": {
    "instanceId": "2f9460831fcdb0e9a4494f0630367cfe2968282072e2d27c6ee6ab0a4c165a36"
  },
  "nodes": [
    {
      "id": "ff4e8706-09a0-4bf1-86c1-dfb65f55ccb3",
      "name": "Google Drive Trigger",
      "type": "n8n-nodes-base.googleDriveTrigger",
      "position": [
        20,
        -140
      ],
      "parameters": {
        "event": "fileCreated",
        "options": {},
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
...