Anonymize & Reformat Cvs With Gemini Ai, Google Sheets & Apps Script 4708 – n8n Workflows – Free Template

What This Workflow Does

This n8n workflow automates the process of anonymizing and reformatting CVs (résumés) using Google Gemini AI. It extracts data from CV files stored in Google Drive, processes them through artificial intelligence to remove personal identifiers, reformats the content according to your specifications, and stores the results back in Google Sheets for easy review and management.

How It Works

The workflow begins by monitoring Google Drive for new CV files using a Drive trigger. When files are detected, the extractFromFile node pulls the content from each document. The data is then processed through Google Gemini AI, which intelligently anonymizes sensitive information while preserving relevant professional details. The workflow splits large batches of CVs for efficient processing, reformats the anonymized content according to your preferred structure, compares datasets to track changes, and finally stores everything in Google Sheets for centralized management and analysis.

Use Cases

• Prepare CVs for blind recruitment processes by removing names, addresses, and other identifying information while maintaining qualifications and experience
• Standardize CV formats across your organization to ensure consistency in how candidate information is presented and evaluated
• Bulk process large volumes of job applications by automatically anonymizing and reformatting submissions according to your hiring guidelines
• Create anonymized candidate databases for research purposes or to reduce unconscious bias in the initial screening stages
• Generate structured candidate data from unstructured CV documents for integration with applicant tracking systems and HR platforms

Nodes Used

• Google Drive Trigger: Monitors your Google Drive for new CV files
• Google Drive: Retrieves and manages files from your Drive storage
• Extract From File: Pulls text content from CV documents
• Google Gemini AI: Processes and anonymizes CV content using artificial intelligence
• Split In Batches: Divides large datasets into manageable chunks for processing
• Google Sheets: Stores anonymized and reformatted CV data
• Code: Executes custom JavaScript for data transformation
• HTTP Request: Makes external API calls if needed
• Compare Datasets: Tracks and compares changes between original and anonymized versions
• n8n Agent: Orchestrates complex automation sequences
• Sticky Note: Adds workflow documentation and notes

Prerequisites

• An active n8n account with workflow creation permissions
• Google account with access to Google Drive and Google Sheets
• Google Gemini API credentials configured in n8n
• Proper authentication and permissions set up for Google Drive, Google Sheets, and Apps Script
• CV files stored in an organized folder within Google Drive
• Basic understanding of workflow automation and data processing

Difficulty Level

This workflow is suitable for intermediate to advanced users. While the template provides a complete automation setup, customization may require knowledge of Google Sheets formulas, JavaScript code modifications, and AI prompt engineering to achieve specific anonymization requirements. Beginners can use it as-is but may need support for advanced customizations.

This workflow template is shared under the n8n fair-code license. Free to use and modify.