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

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