Automate CV screening and applicant scoring from Gmail to Airtable with AI

Description

How It Works
Trigger
Watches for new emails with attachments in a Gmail label.
Extract Data
Extracts job code from the email subject (e.g., FN-001)
Extracts raw text from the attached CV (PDF)
AI Parsing
Uses Google Gemini to parse the CV and extract:
Name
Email
Years of experience
Skills
Job Lookup
Uses the extracted job code to retrieve job details from Airtable.
AI Scoring
Compares applicant data with job requirements
Scores from 1–100
Generates a brief reasoning summary (in Bahasa Indonesia)
Log to Airtable
Saves applicant data, score, and AI notes to the "Applications" table.

Setup Instructions
Prepare Airtable Base
Job Posts Table
Columns: Job Code, Job Title, Required Skills, Minimum Experience, Job Description
Applications Table
Columns: Applicant Name, Email, Score, Notes
Include a linked field to the Job Posts table
Add Credentials in n8n
Gmail
Google AI (Gemini)
Airtable
Configure Nodes
Trigger: Set Gmail filter (e.g., label:job-applications)
Extract Job Code: Verify regex format, default is ([A-Z]{2}-\d{3})
Airtable Nodes: Select your base and table in:
"Find Job Post..."
"Save Applicant..."
Activate Workflow
Save and enable the workflow
New applications will be processed automatically