Automate Resume Screening: Gmail, Gemini AI, Airtable to Sheets

This workflow streamlines the recruitment process for HR professionals and recruiters by automatically detecting new job application emails in Gmail with PDF resume attachments. It extracts the job title from the email subject, matches it against open positions stored in an Airtable base, and uploads the resume to a Google Drive folder for secure storage.

Next, it constructs a detailed prompt incorporating job requirements from Airtable and sends the resume to Google's Gemini AI for intelligent analysis. The AI extracts key candidate details like name and phone number, assigns a match score, and generates a concise explanation of strengths and fit.

Finally, all data—including candidate info, AI score, feedback, and a direct download link to the resume—is appended as a new row in a Google Sheets spreadsheet. This enables easy tracking, sorting, and collaboration on applicants. Benefits include massive time savings, reduced bias through AI evaluation, centralized data management, and scalability for high-volume hiring. Ideal for startups, agencies, or enterprises handling hundreds of applications.