AI Talent Screener - CV Parser, Job Fit Evaluator & Email Notifier
This workflow automates the recruitment pipeline by analyzing job applicant data. It triggers when a new candidate row (including a CV link) is added to Google Sheets. The workflow then downloads the CV, extracts and parses its content using AI, fetches the job description from Google Sheets, and conducts an AI-powered fit evaluation. Finally, it updates the analysis in Google Sheets and sends personalized shortlisting or rejection emails to candidates.
Apps Used:
Google Sheets
Google Drive
OpenAI
GmailCategories:
How It Works
- 1When a new row is added to Google Sheets (containing candidate data and a CV link).
- 2Download the CV file from Google Drive.
- 3Extract all text content from the CV using an OCR reader.
- 4Extract key fields (e.g., name, experience, skills) from the CV text using AI.
- 5Retrieve the relevant job description from another Google Sheet.
- 6Use AI to summarize both the candidate's profile and the job description.
- 7Perform an AI-powered evaluation of the candidate's fit against the job description.
- 8Update the original Google Sheet with the detailed AI analysis and fit score.
- 9Based on the AI evaluation, send a personalized shortlisting or rejection email to the candidate via Gmail.
Related Templates
AI Resume Screening & Evaluation for HR with AI & Google Workspace
This workflow automates the screening and evaluation of job applications. When a candidate submits their application, their CV is uploaded to Google Drive. The system then uses AI to extract candidate information from the CV, retrieves the relevant job description from Google Sheets and Google Drive, and evaluates the candidate against the job requirements. Finally, it stores the results in Google Sheets and sends conditional notifications via Gmail or Slack.
AI-Powered Candidate Screening and Evaluation with Airtable
This workflow automates the candidate screening process. It triggers when a new application is submitted via Google Forms, including a PDF resume upload. The workflow extracts text from the resume, stores it in Google Drive, and uses AI (OpenAI) to evaluate the candidate against job requirements fetched from Airtable. Finally, it creates a new candidate record in Airtable with the evaluation results and sends an email notification to HR if the candidate is deemed suitable.
Extract Data from Documents with Dynamic AI Prompts using Google Sheets
This workflow is triggered when a new row is added to a Google Sheet containing a document link. It processes the document (e.g., a PDF resume) by extracting its text content. Using prompts fetched from another Google Sheet, an AI extracts specific fields of information. Finally, the extracted data is updated back into the original Google Sheet row.
Automate CV Screening with AI: Gmail to Google Sheets HR System
This workflow automates the CV screening process for HR professionals. It triggers when a new email with a CV attachment is received in Gmail. It then extracts the resume text using AI, evaluates the candidate's fit for a job using an LLM, and logs the results, including a score, into a Google Sheet. Finally, it sends a confirmation email to the applicant.
AI-Powered CV Extractor: Google Drive to Google Sheets with Slack Notification
This workflow monitors a Google Drive folder for newly uploaded PDF resumes. It automatically extracts text from the PDF using OCR and then utilizes AI (GPT-4) to extract structured candidate information, such as name, job title, and experience. The extracted data is then used to update an existing row or add a new row in a Google Sheet serving as a candidate database. Finally, the hiring team is notified via Slack with a summary of the new or updated candidate profile.
HR Job Posting and Candidate Evaluation with AI
This workflow automates the recruitment process by collecting candidate applications from a form. It stores applicant data in Airtable, uploads CVs to Google Drive, and uses AI to evaluate candidates against job descriptions. The workflow then schedules interviews and sends personalized email communications to candidates.