Automate CV Screening and Applicant Scoring from Gmail to Airtable with AI

### How It Works 1. **Trigger** Watches for new emails with attachments in a Gmail label. 2. **Extract Data** - Extracts job code from the email subject (e.g., `FN-001`) - Extracts raw text from the attached CV (PDF) 3. **AI Parsing** Uses Google Gemini to parse the CV and extract: - Name - Email - Years of experience - Skills 4. **Job Lookup** Uses the extracted job code to retrieve job details from Airtable. 5. **AI Scoring** - Compares applicant data with job requirements - Scores from 1-100 - Generates a brief reasoning summary (in Bahasa Indonesia) 6. **Log to Airtable** Saves applicant data, score, and AI notes to the Applications table. ### Setup Instructions 1. **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 2. **Add Credentials in n8n** - Gmail - Google AI (Gemini) - Airtable 3. **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... 4. **Activate Workflow** - Save and enable the workflow - New applications will be processed automatically