Automated CV Anonymization and Reformatting with Gemini AI & Google Sheets

Overview

This workflow streamlines the process of anonymizing and reformatting CVs by integrating Google Drive, Google Sheets, Gemini AI, and Apps Script. It automates the extraction, processing, and updating of CV data, ensuring privacy and consistency at scale.

Key Features

• Automated File Retrieval: Fetches PDF CVs from Google Drive.
• Data Extraction: Extracts relevant information from each CV file.
• AI-Powered Anonymization: Utilizes Gemini AI to anonymize sensitive data and reformat content.
• Batch Processing: Processes multiple CVs efficiently using batch operations.
• Google Sheets Integration: Updates and manages CV data within Google Sheets for easy tracking and collaboration.
• Custom Scripting: Employs Apps Script and custom code nodes for advanced data cleaning and logging.

Benefits

• Enhanced Privacy: Ensures candidate data is anonymized, supporting compliance and unbiased review.
• Time Savings: Reduces manual effort in CV processing, freeing HR teams for higher-value tasks.
• Consistency: Standardizes CV formatting for easier comparison and evaluation.
• Seamless Integration: Leverages familiar Google Workspace tools for smooth adoption.

Use Cases

• HR teams anonymizing CVs for blind recruitment.
• Agencies processing large volumes of candidate profiles.
• Organizations standardizing applicant data for analytics and reporting.