{"product_id":"ai-job-applicant-scoring-in-n8n-airtable-drive-openai","title":"AI Job Applicant Scoring in n8n: Airtable, Drive \u0026 OpenAI","description":"\u003ch3\u003eInstantly score job applications with OpenAI inside n8n—then move candidates forward automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow captures job applications from an n8n form, stores CVs in Google Drive and details in Airtable, uses OpenAI to score CV fit, and automatically routes candidates into \u003cstrong\u003eInterviewing\u003c\/strong\u003e or \u003cstrong\u003eNo hire\u003c\/strong\u003e. For shortlisted candidates, it generates interview questions, collects questionnaire responses, emails personalized follow-ups, and books a 30-minute phone screen in Google Calendar.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCollect applications:\u003c\/strong\u003e Receives candidate details and an uploaded PDF CV via an n8n form submission.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStore CVs and records:\u003c\/strong\u003e Uploads the PDF to \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, creates a share link, and creates an applicant record in \u003cstrong\u003eAirtable\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtract and score CV fit:\u003c\/strong\u003e Downloads the CV from Google Drive, extracts the PDF text, then uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e (with an Airtable lookup for the position description) to produce a job-description fit score and a short reason.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStage routing:\u003c\/strong\u003e Updates Airtable with the score; if the score is \u003cstrong\u003e≥ 0.7\u003c\/strong\u003e, sets stage to \u003cstrong\u003eInterviewing\u003c\/strong\u003e, otherwise sets stage to \u003cstrong\u003eNo hire\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerate interview questions:\u003c\/strong\u003e For shortlisted candidates, uses OpenAI (with Airtable job description and candidate context) to generate \u003cstrong\u003efive\u003c\/strong\u003e interview questions and presents them via a second n8n form.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCapture answers and follow up:\u003c\/strong\u003e Saves questionnaire responses back to Airtable, then drafts a personalized follow-up email using OpenAI and sends it via \u003cstrong\u003eSMTP\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBook the phone interview:\u003c\/strong\u003e Uses OpenAI with a \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e tool to schedule a \u003cstrong\u003e30-minute\u003c\/strong\u003e phone interview for the next day, writes the meeting time to Airtable, and stores phone-screening questions.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomating screening for SaaS recruiting workflows using Airtable + Google Drive + OpenAI\u003c\/li\u003e\n  \u003cli\u003eReducing manual triage by automatically scoring CVs against a role description\u003c\/li\u003e\n  \u003cli\u003eShortlisting candidates, sending tailored emails, and booking phone screens without spreadsheets\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e if, set, form, airtable, email send, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Drive (CV storage), Airtable (position + applicant records), OpenAI (scoring + questions + email drafting), Google Calendar (30-minute scheduling), SMTP (email delivery)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45824201392307,"sku":"N8N-18177","price":12.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/tnINr6xD5U0nHX-ovxkW8_wLtOpBwG.png?v=1786612038","url":"https:\/\/buyflowscripts.com\/products\/ai-job-applicant-scoring-in-n8n-airtable-drive-openai","provider":"N8N Commerce","version":"1.0","type":"link"}