Automated AI-Powered CV Parsing with Google Gemini
detail.loadingPreview
This workflow automates the extraction of key candidate information from CVs (PDFs) stored in Google Drive. Leveraging Google Gemini AI, it intelligently parses unstructured text and populates a structured Google Sheet database, saving HR teams significant manual effort.
About This Workflow
Streamline your recruitment process with this robust n8n workflow designed for automated CV parsing. It monitors designated Google Drive folders for new resumes, intelligently extracts vital candidate data using the powerful Google Gemini AI model, and then seamlessly updates your Google Sheets candidate database. The workflow includes deduplication logic to ensure only new, unprocessed CVs are handled, along with comprehensive logging. This solution transforms unstructured resume data into actionable insights, drastically reducing manual data entry and accelerating your hiring pipeline.
Key Features
- Google Drive Integration: Automatically detects and retrieves new CVs (PDFs) uploaded to specified Google Drive folders.
- Intelligent AI Parsing: Utilizes Google Gemini's advanced natural language processing capabilities via an AI Agent to accurately extract targeted information (e.g., contact details, experience, skills) from CV text.
- Deduplication & Logging: Prevents reprocessing of previously analyzed CVs and maintains a detailed log of all processed documents in Google Sheets.
- Structured Data Output: Transforms unstructured CV content into organized, ready-to-use data within Google Sheets, perfect for building candidate databases.
- Scalable Batch Processing: Efficiently handles multiple CVs, allowing for streamlined processing of large volumes of applications.
How To Use
- Configure Google Drive Trigger: Point the trigger to the specific Google Drive folder where new CVs (PDFs) will be uploaded.
- Set Up Google Sheets: Create two Google Sheets: one for logging processed documents and another to serve as your candidate database where extracted CV fields will be updated. Configure credentials for both.
- Customize AI Agent: Access the "AI Agent - get targeted elements from text" node. Edit the prompt to precisely define the specific fields (e.g., Name, Email, Phone, Company, Role, Skills) you wish to extract from the CV text.
- Google Gemini Credentials: Ensure your Google Gemini Chat Model node has the correct API key/credentials configured.
- Refine Cleaning Logic: Adjust the "Clean output" code nodes to format the extracted data as needed before it's written to Google Sheets.
Apps Used
Workflow JSON
{
"id": "3c152f48-6fc1-4511-a52e-b959026a3443",
"name": "Automated AI-Powered CV Parsing with Google Gemini",
"nodes": 25,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 3c152f48-6fc1...
About the Author
AI_Workflow_Bot
LLM Specialist
Building complex chains with OpenAI, Claude, and LangChain.
Statistics
Related Workflows
Discover more workflows you might like
Google Sheets to Icypeas: Automated Bulk Domain Scanning
This workflow streamlines the process of performing bulk domain scans by integrating your Google Sheets data directly with the Icypeas platform. Automate the submission of company names from your spreadsheet to Icypeas for comprehensive domain information, saving valuable time and effort.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.