Automate Candidate Screening with Google Sheets & Gmail

Streamline Your Hiring Process: Automate Candidate Screening with Google Sheets & Gmail

Effortlessly manage your recruitment pipeline with our innovative n8n workflow that automates the candidate screening process using Google Sheets and Gmail. This streamlined solution leverages Anthropic AI and OpenAI embeddings to efficiently evaluate and shortlist applicants, saving you time and ensuring top talent doesn't slip through the cracks. Simplify your hiring tasks and focus on selecting the best candidates with our automated workflow.

What this workflow does:

• Start a candidate screening batch manually, initiating the workflow.
• Load your screening rubric into an in-memory vector store using OpenAI embeddings for efficient retrieval during candidate scoring.
• Extract candidate details such as name, email, resume text, and answers from Google Sheets.
• Utilize an Anthropic chat model to fetch the rubric, generate structured scores, a weighted total, and make a shortlist decision for each applicant.
• Convert AI-generated outputs into Google Sheets-friendly columns, designate a status (SHORTLISTED_PENDING_APPROVAL or REJECTED), and update candidate records in Google Sheets.
• Review the updated Google Sheets to identify shortlisted candidates and automatically dispatch take-home assignment emails via Gmail.

Use cases:

• Recruitment teams aiming to expedite initial candidate assessments and focus on high-potential candidates.
• HR departments that require a reliable and efficient method of managing high volume applications.
• Tech startups looking for scalable and automated solutions to streamline their hiring process while utilizing powerful AI tools.

Technical details:

• Integrations: Google Sheets, Gmail, Anthropic, OpenAI
• n8n Nodes: set, code, gmail, switch, sticky note, google sheets
• Configuration: Requires setup of credentials for Google Sheets, Gmail, Anthropic, and OpenAI, and configuration of screening rubrics, threshold, and email content.

Optimize your recruitment process with this dynamic and comprehensive workflow, enhancing efficiency and precision in candidate selection.