Streamline Job Applications with n8n, Ollama & Google Sheets

Revolutionize Your Hiring Process with n8n, Ollama & Google Sheets Workflow

Effortlessly manage your job applications with this sophisticated n8n workflow that integrates Ollama, Google Sheets, and Gmail. Streamline the entire recruitment process, from receiving applications to candidate evaluations, all while ensuring top candidate engagement and seamless approvals for standout applicants.

What this workflow does

• Application Collection: Begins with candidates submitting their contact details, screening questions, and PDF CVs through an easy-to-use n8n form.
• Email Confirmation: Immediately acknowledges application receipt by sending a confirmation email to the candidate via Gmail.
• CV Analysis: Automates text extraction from PDF CVs and evaluates content against job requirements using the cloud-based Ollama nemotron-3-ultra model, creating a structured JSON for further analysis.
• Data Management: Cleanses and standardizes Ollama's JSON output, maintaining coherent fields like scores, fit level, and skill sets for consistent downstream processing.
• High-fit Candidate Processing: Directly flags candidates with an "Alto" fit level by updating Google Sheets and sending an email with approve/reject actions to the hiring reviewer via Gmail.
• Feedback & Alerts: Updates candidates’ status in Google Sheets post-reviewer decision and manages rejections and error alerts efficiently through Gmail notifications.

Use cases

• HR Departments: Streamline candidate management and enhance decision-making efficiency by integrating automated evaluations into your existing recruitment strategies.
• Recruitment Agencies: Simplify high-volume application processing and ensure prompt communication with candidates and review committees.
• SaaS Operators: Deploy automation to manage and evaluate internal job applications, reducing manual effort and improving candidate experience.

Technical details

• Nodes Used: if, set, code, gmail, sticky note, form trigger
• Integrations: Leverages Gmail for communication, Google Sheets for data storage, and Ollama for advanced AI-based CV evaluation.