Automate CV Screening & AI Scoring from Gmail to Airtable

This workflow streamlines the recruitment process by monitoring a specific Gmail label for new job applications with CV attachments. Upon receiving an email, it extracts the job code from the subject (e.g., FN-001), pulls raw text from the PDF CV, and uses Google Gemini AI to parse key details like applicant name, email, years of experience, and skills.

Next, it queries an Airtable 'Job Posts' table using the job code to fetch requirements such as required skills and minimum experience. Gemini then compares the applicant's profile against these criteria, generating a score from 1-100 and a reasoning summary in Bahasa Indonesia. Finally, all data—including score and notes—is saved to the 'Applications' table in Airtable, linked to the job post.

Benefits include massive time savings for recruiters, reducing manual screening from hours to seconds per applicant, minimizing bias with AI consistency, and centralizing data for easy tracking. Ideal for HR teams, staffing agencies, or companies handling high-volume applications in Indonesia or multilingual environments. Setup requires Gmail, Gemini, and Airtable credentials, with customizable regex for job codes.