Automated Job Application Screening with AI and Email

This workflow streamlines the recruitment process by automating the screening and scoring of job applications received via Gmail. It monitors a designated email inbox for new applications with attachments, extracts relevant candidate information from CV PDFs using Google Gemini AI, retrieves job details from Airtable based on a code found in the email subject, and employs AI to evaluate how well the candidate matches the job requirements. The structured data—including applicant details and scoring—is then stored in Airtable for easy review and decision-making. This workflow significantly reduces manual labor, speeds up the screening process, and ensures consistent evaluation of candidates.

Steps Breakdown:

1. The process begins with a Gmail trigger that watches for new emails containing attachments, indicating a job application.

2. The email subject is regex-parsed to extract the job code, which is used to find the corresponding job posting in Airtable.

3. The attached CV PDF is processed to extract raw text.

4. Google Gemini AI analyzes the CV text, extracting key applicant details such as name, email, skills, and experience.

5. Using the extracted data, the workflow compares the applicant’s profile against job requirements with an AI model that scores the candidate from 1-100 and provides a brief rationale.

6. The final structured applicant profile, score, and notes are saved into the Airtable Applications table.

Practical Use Scenario:

This workflow is ideal for HR teams or recruiters managing high volumes of job applications through email. It automates the initial screening, ensuring only the most suitable candidates are shortlisted for further evaluation, thus optimizing the recruitment workflow and saving valuable time.