Cleanse Personal Identifiable Information Automatically | Google Drive -> Extract -> OpenAI -> Drive

Workflow Overview: Automated PII Cleansing from Google Drive Files This workflow automates the detection and removal of Personally Identifiable Information (PII) from CSV files. When a new file is uploaded to a designated Google Drive folder, the workflow automatically processes it, uses AI to identify sensitive data columns, removes them, and saves a sanitized version of the file to a different folder. Technologies Used - Google Drive: Used as the trigger source for new files and the destination for the processed, clean files. - OpenAI: Provides the AI model (GPT-4o-mini) that analyzes the data to identify PII. - n8n: The automation platform that connects these services and coordinates the entire data cleansing process. Automation Value This workflow provides significant value by creating an automated data privacy pipeline. It addresses the critical business need for data compliance and security (e.g., GDPR, CCPA) by: - Eliminating Manual Work: It replaces the time-consuming and error-prone manual task of inspecting spreadsheets for sensitive information like names, emails, and phone numbers. - Reducing Human Error: By automating the redaction process, it minimizes the risk of accidentally sharing or storing sensitive data. - Enhancing Security: It ensures that data used for analysis, sharing, or further processing is automatically scrubbed of PII, creating a more secure data environment by default. AI Integration The OpenAI integration is the core intelligent component of this workflow. Instead of relying on a predefined list of column names to remove, the AI dynamically analyzes the structure and content of each new file. - The AI is given the column headers and a sample row of data from the uploaded CSV. - Based on this context, the AI model (gpt-4o-mini) intelligently identifies which columns contain PII. This allows it to recognize sensitive data even with unconventional column names (e.g., identifying "Customer\_Contact" as PII).