Automated CV screening and data extraction with AI-powered analysis
Workflow Description
An automated system that receives resumes through a form submission, analyzes them using OpenAI's advanced models, extracts key information including skills and experience, and logs structured results directly into Google Sheets for streamlined candidate management and quick filtering.
How it works
- 1.Receive uploaded CV files through web form trigger
- 2.Extract and analyze resume content using OpenAI language models
- 3.Parse and structure candidate data from unstructured resume text
- 4.Store all extracted information and assessments in Google Sheets
- 5.Send notification summaries to Twitter/X for team alerts
Use cases
- Automate initial candidate screening and qualification classification
- Reduce manual CV review time by extracting structured data automatically
- Build searchable candidate database with standardized information fields
- Enable consistent evaluation criteria across all incoming applications
Requirements
- Active OpenAI API account with proper authentication credentials
- Google account with permissions to create and modify sheets
- Form endpoint or file upload service integrated with n8n
- Optional: Twitter/X account for notification sharing
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (17)
On form submission
Form Trigger
Merge
Merge
Structured Output Parser
Output Parser Structured
Google Sheets
Google Sheets
Personal Info
Information Extractor
Qualification
Information Extractor
HR Expert
LLM Chain
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Upload to google drive
Google Drive
Resume extraction
Extract From File
wanted profile
Set
Summarizer
Chain Summarization
OpenAI Chat Model
OpenAI