# AI CV screening from web form: rating, email alerts, and Google Sheets logging
This automation streamlines the initial candidate screening process by receiving job applications with CVs in PDF via a web form, extracting text, analyzing fit using Google Gemini AI, storing results in Google Sheets, and notifying HR. It significantly reduces manual effort and accelerates early-stage recruitment.
## Who it´s for
- HR specialists automating initial candidate screening
- Recruitment agencies handling high volumes of applications
- Tech companies hiring engineers against strict technical criteria
- Employers integrating AI into hiring workflows
## What the automation does
- Receives a job application with a PDF CV via Google Forms
- Converts the PDF file into plain text using built-in parsing
- Sends the resume data to Google Gemini AI via LangChain for analysis
- Generates an AI compatibility score (e.g., 8/10) and summary recommendation
- Logs candidate details (name, email, salary expectations, LinkedIn, AI score) in Google Sheets
- Sends an email alert to HR with candidate profile and AI insights
- Automatically confirms application receipt to the candidate via Gmail
## What´s included
- Ready-to-use n8n workflow
- Trigger logic for form submissions
- Integrations with Google Forms, Google Sheets, Gmail, and Google Gemini API
- Basic textual setup guide
## Requirements for setup
- n8n instance with workflow execution capabilities
- Google account with enabled APIs: Gmail, Google Sheets, Google Drive (for temporary storage)
- Google Gemini API key
- Configured Google Form supporting file uploads
- LangChain compatibility within the n8n environment
## Benefits and outcomes
- Reduces recruiter workload during initial screening
- Speeds up application processing to seconds per candidate
- Creates a centralized candidate database in Google Sheets with AI ratings
- Minimizes subjectivity in early-stage selection
- Enhances candidate experience with instant confirmation emails
- Enables scalable, consistent evaluation across applicants
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet