Automated CV screening and scoring with AI, Gmail, GoogleDrive & Airtable

🚀 HR Resume Screening Workflow — Smart Hiring on Autopilot 🤖

🎯 Overview:

"This workflow builds an AI-powered resume screening system inside n8n. It begins with Gmail and Form triggers that capture incoming resumes, then uploads each file to Google Drive for storage. The resume is downloaded and converted into plain text, where two branches run in parallel: one extracts structured contact details, and the other uses an AI agent to summarize education, job history, and skills while assigning a suitability score. A cleanup step normalizes the data before merging both outputs, and the final candidate record is saved into Google Sheets and Airtable, giving recruiters a centralized dashboard to identify top talent quickly and consistently.”

🔑 Prerequisites:

To run this workflow successfully, you’ll need:

- Gmail OAuth → to read incoming resumes. - Google Drive OAuth → to upload and download resume files. - Google Sheets OAuth → to save structured candidate records. - Airtable Personal Access Token → for dashboards and record-keeping. - OpenAI / OpenRouter API Key → to run the AI summarizer and evaluator.

⚙️ Setup Instructions:

1. Import the Workflow - Clone or import the workflow into your n8n instance. 2. Add Credentials - Go to n8n → Credentials and connect Gmail, Google Drive, Google Sheets, Airtable, and OpenRouter/OpenAI. 3. Configure Key Nodes - Gmail Trigger → Update filters.q with the job title you are hiring for (e.g., "Senior Software Engineer"). - Google Drive Upload → Set the folderId where resumes will be stored. - Google Sheets Node → Link to your HR spreadsheet (e.g., “Candidates 2025”). - Airtable Node → Select the correct base & table schema for candidate records. 4. Test the Workflow - Send a test resume (via email or form). - Check Google Sheets & Airtable for structured candidate data. 5. Go Live - Enable the workflow. It will now run continuously and process new resumes as they arrive.