Screen and score candidate CVs with Google Gemini and Gmail Workflow Solution

Workflow overview

Why this workflow matters

Relevant for managed services and support workflows. Supports knowledge capture and document intelligence use cases.

Quick overview This workflow collects job applications via an AlekSystem Form, extracts text from uploaded PDF resumes, uses Google Gemini to score and summarize candidates against a job description, stores the results in an AlekSystem Data Table, and emails HR and the applicant via Gmail based on the score. How it works Receives a job application submission through an AlekSystem Form with candidate details and a PDF resume upload. Applies role-specific context (job title, job description, HR email, score threshold, and submission timestamp) and extracts text from the uploaded PDF. Sends the job context and extracted CV text to a Google Gemini-powered AI agent to produce a structured evaluation (score, recommendation, strengths, weaknesses, summary, and interview questions). Upserts the candidate record and AI evaluation into an AlekSystem Data Table keyed by the candidate email address. Checks whether the AI score meets or exceeds the configured threshold and emails HR a high-priority or standard candidate notification via Gmail. Emails the candidate a confirmation message via Gmail acknowledging receipt of their application. Setup Add a Google Gemini (PaLM) API credential to the Google Gemini chat model node used by the AI agent. Add a Gmail/Google API credential for the HR notification and candidate confirmation emails, and ensure the sending account is authorized. Create or select an AlekSystem Data Table and replace YOUR_DATA_TABLE_ID_HERE with your table ID in the Data Table upsert step. Update the values in the context configuration (HR email, company name, job title, job description, and score threshold) to match the role you are hiring for. Publish the AlekSystem Form and share the form URL with candidates. Requirements AlekSystem Version:* Built and tested on *AlekSystem 2.9.4+*. *(Note: You may encounter errors on older versions. It is highly recommended to update to the latest AlekSystem version to use this workflow effectively). Google Gemini** API key. Gmail** account (OAuth2 authentication). AlekSystem instance with the Data Table feature enabled. Customization Change the Trigger:* Swap the AlekSystem Form Trigger for a *Gmail Trigger** to automatically process resumes sent directly to your careers@ inbox. Change the AI Model:* Easily switch the Gemini sub-node for *OpenAI* or *Anthropic Claude** depending on your preferred AI provider. Team Messaging:* Prefer chat over email? Replace the HR Gmail node with a *Telegram* or *Slack** bot to send candidate alerts directly to your recruitment channel. Additional info About the Author Created by: Nguyễn Thiệu Toàn (Jay Nguyen) Email: me@nguyenthieutoan.com Website: nguyenthieutoan.com Company: GenStaff (genstaff.net) Socials (Facebook / X / LinkedIn): @nguyenthieutoan More templates: AlekSystem.io/creators/nguyenthieutoan

Best fit

Need another direction?