{"product_id":"ai-job-application-screening-in-n8n-openai-google-sheets-gmail","title":"AI Job Application Screening in n8n: OpenAI + Google Sheets\/Gmail","description":"\u003ch3\u003eAuto-screen job applications with AI inside n8n (OpenAI + Google Sheets\/Gmail)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow collects job applications from an n8n form, stores resumes in Google Drive, evaluates candidates against your job requirements using an OpenAI chat model, and emails HR the AI recommendation—along with updated status in Google Sheets—for quick human review.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eReceives applications\u003c\/b\u003e via an \u003cb\u003en8n form trigger\u003c\/b\u003e, capturing candidate details, cover letter, and a \u003cb\u003ePDF resume\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCreates a candidate record\u003c\/b\u003e with a unique \u003cb\u003eCandidate ID\u003c\/b\u003e and \u003cb\u003euploads the resume to Google Drive\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLogs everything in Google Sheets\u003c\/b\u003e by appending candidate information plus the \u003cb\u003eGoogle Drive link\/file ID\u003c\/b\u003e into a “Candidates” sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eExtracts resume text\u003c\/b\u003e by downloading the PDF from Google Drive and converting it into text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAI screening using OpenAI\u003c\/b\u003e by sending the resume text and your \u003cb\u003ejob requirements\u003c\/b\u003e to an \u003cb\u003eOpenAI chat model\u003c\/b\u003e, producing a JSON screening recommendation and score.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eValidates \u0026amp; updates results\u003c\/b\u003e by parsing the AI JSON output, then writing \u003cb\u003eAI Score\u003c\/b\u003e, \u003cb\u003eScreening Result\u003c\/b\u003e, and \u003cb\u003eHR Remarks\u003c\/b\u003e back into the candidate row.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eRoutes decisions\u003c\/b\u003e into \u003cb\u003eStrong Match\u003c\/b\u003e, \u003cb\u003eReview Required\u003c\/b\u003e, or \u003cb\u003eLow Match\u003c\/b\u003e based on configurable score thresholds, updating the candidate’s workflow phase\/status in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eEmail notifications to HR\u003c\/b\u003e through \u003cb\u003eGmail\u003c\/b\u003e with the AI recommendation so HR can review and proceed.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eStreamline recruitment screening by auto-triaging high-volume applications in \u003cb\u003en8n\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003eStandardize candidate evaluation using consistent \u003cb\u003eOpenAI\u003c\/b\u003e-based scoring tied to your job requirements.\u003c\/li\u003e\n  \u003cli\u003eKeep HR in the loop with automated \u003cb\u003eGmail\u003c\/b\u003e updates and an auditable record in \u003cb\u003eGoogle Sheets\u003c\/b\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations\/Nodes:\u003c\/b\u003e \u003cb\u003eSet\u003c\/b\u003e, \u003cb\u003eCode\u003c\/b\u003e, \u003cb\u003eGmail\u003c\/b\u003e, \u003cb\u003eSwitch\u003c\/b\u003e, \u003cb\u003eSticky Note\u003c\/b\u003e, \u003cb\u003eForm Trigger\u003c\/b\u003e (plus configured Google Drive\/Sheets and OpenAI credentials).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eKey outputs:\u003c\/b\u003e Google Drive resume link\/file ID, AI JSON screening recommendation, AI Score + Screening Result, and HR email via Gmail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSetup requirements:\u003c\/b\u003e credentials for \u003cb\u003eGoogle Drive\u003c\/b\u003e, \u003cb\u003eGoogle Sheets\u003c\/b\u003e, \u003cb\u003eGmail\u003c\/b\u003e, and \u003cb\u003eOpenAI (Chat Completions)\u003c\/b\u003e; then configure company name, HR email, job title, job requirements, and match score thresholds.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45837250396339,"sku":"N8N-18288","price":71.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/WkJPC_0hAdt2TkzS_i4Kb_JzNAivZe.png?v=1786792551","url":"https:\/\/buyflowscripts.com\/products\/ai-job-application-screening-in-n8n-openai-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}