Automate CV Screening and Applicant Scoring from Gmail to Airtable with AI
This workflow automatically processes new job applications received via Gmail. It extracts the job code and applicant's CV from email attachments, uses AI to parse the CV for key information, and retrieves job requirements from Airtable. Finally, it uses AI to score the applicant against the job and logs all details, including a summary, back into Airtable.
Apps Used:
Gmail
Airtable
AICategories:
How It Works
- 1When a new email with a PDF attachment is received in Gmail
- 2Extract job code from the email subject
- 3Extract text from the attached PDF CV
- 4Use AI to parse the CV text for name, email, years of experience, and skills
- 5Search Airtable for job details using the extracted job code
- 6Use AI to compare applicant data with job requirements, generate a score, and a summary
- 7Add a new record to Airtable with the applicant's name, email, score, and AI notes
Related Templates
Automate Resume Screening with Gmail, AI, and Airtable to Google Sheets
This workflow monitors a Gmail inbox for new emails containing PDF resume attachments. It extracts the job title from the email subject and matches it against open positions stored in Airtable. The resume file is then uploaded to Google Drive, and its content is sent to an AI for analysis, scoring the candidate, extracting key details, and providing feedback. All results, including candidate information, AI score, and a resume download link, are then appended as new rows in Google Sheets.
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.
Screen and Score Resumes from Gmail to Google Sheets with AI
This workflow streamlines the process of screening job applications. It triggers when a new email with a PDF resume attachment is received in Gmail. The workflow then extracts text and key candidate details from the resume using AI, evaluates and scores the candidate based on predefined criteria, and finally logs all the candidate's information, including their score, into a Google Sheet for easy management.
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.
Automated Resume Scoring and Email Labeling with AI
This workflow automates the resume screening process. It triggers when a new email with a resume attachment is received in Gmail. The workflow extracts candidate details from the PDF resume, retrieves a relevant job profile from Notion, and uses an AI to score the resume's fit. The results are then updated in a Google Sheet, and the original email is labeled for easy tracking.
Automate Invoice Processing from Email to Airtable with AI
This workflow automates the processing of incoming invoices. It triggers when a new email with an invoice attachment is received, extracts key information using OCR and AI, and then populates a designated Airtable base with the extracted invoice data for tracking and management.