{"product_id":"automate-cv-screening-with-openrouter-google-sheets","title":"Automate CV Screening with OpenRouter \u0026 Google Sheets","description":"\u003ch3\u003eStreamline CV Screening with Automation: OpenRouter \u0026amp; Google Sheets Workflow\u003c\/h3\u003e\n\u003cp\u003eTransform 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReceives candidate CVs through a POST webhook, capturing essential details, including the job ID and the CV file.\u003c\/li\u003e\n  \u003cli\u003eSynchronizes the submission with Google Sheets to fetch relevant job descriptions using the job ID.\u003c\/li\u003e\n  \u003cli\u003eExtracts text from CVs by parsing PDFs directly or converting DOCX\/DOC files into Google Docs for exporting as plain text.\u003c\/li\u003e\n  \u003cli\u003eEmploys OpenRouter’s Qwen for Vietnamese or Google Gemini for other languages to transform the CV into a structured Candidate Profile JSON.\u003c\/li\u003e\n  \u003cli\u003eUtilizes OpenRouter’s Anthropic Claude Sonnet to compare the structured profile against job requirements, delivering a detailed hiring-manager style review and recommendation.\u003c\/li\u003e\n  \u003cli\u003eUploads each CV to a specific Google Drive folder based on recommendations and logs results, including Drive links, to Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eSends a shortlist email or drafts a rejection email using Gmail, ensuring communication is swift and organized.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRecruitment teams aiming to reduce manual tasks in the CV screening process and focus more on talent acquisition.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers looking to integrate advanced AI and machine learning models in HR processes.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators seeking robust solutions for improving organizational efficiencies in candidate evaluations and data management.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eIntegrates Google Sheets to store and reference job descriptions and results.\u003c\/li\u003e\n  \u003cli\u003eUtilizes Google Drive for strategic document management of all CVs.\u003c\/li\u003e\n  \u003cli\u003eEmploys Gmail for automatic email drafting and sending based on screening outcomes.\u003c\/li\u003e\n  \u003cli\u003eIntegrates with OpenRouter for advanced CV parsing and candidate profile generation using Qwen and Google Gemini models.\u003c\/li\u003e\n  \u003cli\u003eLeverages nodes such as IF, Set, Code, Gmail, Merge, and Switch to create a dynamic and responsive automation workflow.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eLeverage this advanced automation to expedite your candidate screening process, focusing on what's truly important—selecting top talent efficiently.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45633727594675,"sku":"N8N-16777","price":70.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/D8zGz5toy5gICYb-3ZLuc_bb4bcda6af974fd59e8e3e00ba63c0a7.jpg?v=1782983108","url":"https:\/\/buyflowscripts.com\/products\/automate-cv-screening-with-openrouter-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}