{"product_id":"n8n-candidate-screening-automation-gmail-llama-to-sheets","title":"n8n Candidate Screening Automation: Gmail + Llama to Sheets","description":"\u003ch3\u003eAuto-screen candidates from Gmail PDFs—extract details with NVIDIA NIM and log them into Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically processes candidate resumes from Gmail (including Indeed application emails): it extracts structured candidate info using the \u003cstrong\u003eNVIDIA NIM\u003c\/strong\u003e LLM, uploads the resume to \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, deduplicates and appends records to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, then sends acceptance or rejection emails and tracks recruiter decisions and candidate replies.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors Gmail every minute\u003c\/strong\u003e for new messages with \u003cstrong\u003ePDF attachments\u003c\/strong\u003e (and supports a manual\/local-PDF test path).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes input metadata\u003c\/strong\u003e (sender and role info) and extracts text from each resume PDF.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses NVIDIA NIM (chat completions)\u003c\/strong\u003e to parse structured fields: name, email, phone, LinkedIn, portfolio, previous company, and position.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUploads the original resume PDF\u003c\/strong\u003e to Google Drive, then combines the Drive link with AI-parsed candidate data.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicates in Google Sheets\u003c\/strong\u003e by checking the “Candidates” tab for existing emails, then appends a new candidate row with a Drive hyperlink.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes recruiter decisions\u003c\/strong\u003e by reading Google Sheets rows marked \u003cem\u003eApprove\/Reject\u003c\/em\u003e, sending an acceptance questionnaire or rejection email via Gmail when no email has been sent.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates status back to Google Sheets\u003c\/strong\u003e with email status and a processing timestamp.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors Gmail for candidate replies\u003c\/strong\u003e to the questionnaire and uses NVIDIA NIM to extract the response content.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRecruiting teams that receive resumes via \u003cstrong\u003eGmail\u003c\/strong\u003e and want consistent, structured candidate records in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators running lightweight screening pipelines without building a full ATS.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers demonstrating an end-to-end workflow: \u003cstrong\u003eGmail + NVIDIA NIM + Google Drive + Sheets + email updates\u003c\/strong\u003e.\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\/logic:\u003c\/strong\u003e if, code, gmail, merge, webhook, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Gmail (PDF intake, sending questionnaire\/rejection, reply monitoring), Google Drive (resume storage), Google Sheets (Candidates tab dedup + decision tracking)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI extraction:\u003c\/strong\u003e NVIDIA NIM chat completions API for candidate field extraction and reply parsing\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46326535487667,"sku":"N8N-21723","price":62.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/7Y3YNkPP06axj598p1uXz_NTPtA2Mt.png?v=1793352099","url":"https:\/\/buyflowscripts.com\/products\/n8n-candidate-screening-automation-gmail-llama-to-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}