# CV screening via form: AI extracts data and saves to Google Sheets
This workflow automates initial candidate screening by processing CVs submitted through a web form. Using n8n with LangChain and Google Gemini AI, it extracts personal data and qualifications from PDF resumes, evaluates alignment with job requirements stored in Google Sheets, and assigns a fit score. Results are logged in Google Sheets, and original CVs are saved to Google Drive.
## Who it´s for
- HR specialists looking to speed up resume processing.
- Recruitment agencies handling high volumes of applicants.
- Companies integrating AI into hiring workflows.
- Talent acquisition managers in mid-sized and large organizations.
## What the automation does
- Triggers on form submission with CV upload (via webhook).
- Extracts personal info, experience, skills, and contacts from PDF using Google Gemini AI and LangChain.
- Summarizes candidate profile and compares it to job role criteria from Google Sheets.
- Generates a match score based on alignment.
- Logs structured candidate data into Google Sheets.
- Stores the original CV file in a designated Google Drive folder.
## What´s included
- Ready-to-use n8n workflow.
- Trigger logic for form_submission_webhook.
- Integrations with Google Sheets, Google Drive, Google Gemini, and HTTP API.
- Basic setup and adaptation guide.
## Requirements for setup
- n8n instance (cloud or self-hosted).
- Google Workspace account with access to Google Sheets and Google Drive.
- Configured API connection to Google Gemini.
- Web form with webhook integration for candidate submissions.
## Benefits and outcomes
- Reduces time per resume screening to seconds.
- Minimizes human bias in initial filtering.
- Centralized candidate database in Google Sheets.
- Easy adjustment of job criteria directly in the spreadsheet.
- Scalable processing for high-volume recruitment.
- Automatic archiving of CVs in cloud storage.
## 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