Automate CV Screening with OpenRouter & Google Sheets

Streamline CV Screening with Automation: OpenRouter & Google Sheets Workflow

Transform your recruitment process with our sophisticated CV screening automation workflow using OpenRouter and Google Sheets. Automate the receiving, parsing, and assessment of candidate CVs, while efficiently managing all data through seamless integrations. This workflow enhances your hiring efficiency, ensuring every CV is systematically evaluated and recorded without hassle.

What this workflow does

• Receives candidate CVs through a POST webhook, capturing essential details, including the job ID and the CV file.
• Synchronizes the submission with Google Sheets to fetch relevant job descriptions using the job ID.
• Extracts text from CVs by parsing PDFs directly or converting DOCX/DOC files into Google Docs for exporting as plain text.
• Employs OpenRouter’s Qwen for Vietnamese or Google Gemini for other languages to transform the CV into a structured Candidate Profile JSON.
• Utilizes OpenRouter’s Anthropic Claude Sonnet to compare the structured profile against job requirements, delivering a detailed hiring-manager style review and recommendation.
• Uploads each CV to a specific Google Drive folder based on recommendations and logs results, including Drive links, to Google Sheets.
• Sends a shortlist email or drafts a rejection email using Gmail, ensuring communication is swift and organized.

Use cases

• Recruitment teams aiming to reduce manual tasks in the CV screening process and focus more on talent acquisition.
• Automation engineers looking to integrate advanced AI and machine learning models in HR processes.
• SaaS operators seeking robust solutions for improving organizational efficiencies in candidate evaluations and data management.

Technical details

• Integrates Google Sheets to store and reference job descriptions and results.
• Utilizes Google Drive for strategic document management of all CVs.
• Employs Gmail for automatic email drafting and sending based on screening outcomes.
• Integrates with OpenRouter for advanced CV parsing and candidate profile generation using Qwen and Google Gemini models.
• Leverages nodes such as IF, Set, Code, Gmail, Merge, and Switch to create a dynamic and responsive automation workflow.

Leverage this advanced automation to expedite your candidate screening process, focusing on what's truly important—selecting top talent efficiently.