Workflow overview
Why this workflow matters
Helpful for business development and pipeline building. Improves internal consulting operations and productivity.
π€ Smart Interview Assistant: Tailored Questions Based on CV, JD, and Round Watch the demo video below: π Whoβs it for This workflow is designed for: Recruiters* and *Talent Acquisition Specialists** who want to automate candidate interview prep. Hiring Managers** conducting multiple interviews and needing personalized question sets. Technical Interviewers** who want to save time and be well-prepared with relevant questions. βοΈ How it works / What it does The Smart Interview Assistant automates the interview preparation process in a few clicks: Accepts: Multiple resumes (PDFs) Selected job role Chosen interview round Extracts structured data from: The candidateβs CV The corresponding Job Description (JD) Uses GPT-4 to analyze: Candidate profile Role requirements Interview round context Generates: Tailored interview questions Expected answers A summarized interview prep report Sends the report directly to the hiring team via email (SMTP) π Google Drive Structure π Root Folder βββ π jd/ # Stores all job descriptions in PDF format β βββ Backend_Engineer.pdf β βββ Azure_DevOps_Lead.pdf β βββ ... βββ π Positions (Google Sheet) # Maps Job Role β JD File Link π Sample Mapping Sheet: Positions Sheet Columns: Job Role Job Description File URL (pointing to PDF in jd/ folder) π οΈ How to Set Up Step 1: Configure API Integrations β Connect your OpenAI GPT-4 API Key β Enable Google Cloud APIs: Google Sheets API (to read job roles) Google Drive API (to access CV and JD files) β Set up SMTP credentials (for email delivery) Step 2: Prepare Google Drive & Mapping Sheet Create a root folder on Google Drive Inside the root folder: Create a folder named /jd/ and upload all job descriptions (PDFs) Create a Google Sheet named Positions with the following format: | Job Role | Job Description File URL | |-----------------------------|--------------------------------------------| | Azure DevOps Engineer | https://drive.google.com/xxx/jd1.pdf | | Full-Stack Developer (.NET) | https://drive.google.com/xxx/jd2.pdf | Step 3: Build the Application Form Use any form tool (e.g., Typeform, Tally, or custom HTML) that collects: π Resume file (PDF) π§Ύ Job Role (dropdown) π Interview Round (dropdown) Step 4: Resume & JD Extraction π Use Extract from PDF to parse the resume content π Retrieve the JD link from the Positions sheet based on the selected Job Role π Use Download file to pull the PDF for processing Step 5: Analyze with GPT-4 Run both Resume and JD through a Profile Analyzer Agent (GPT-4 with JSON output) Merge results Add manual input or mapping for the Interview Round metadata Step 6: Generate Interview Report Use a second GPT-4 agent (e.g., HR Expert Agent) to: Generate 6β8 tailored interview questions Include expected answers and rationale Step 7: Deliver Final Report Format the content as: π PDF (optional) π¨ Email body Send the report to the recruiter, hiring manager, or interviewer via SMTP β Requirements π OpenAI GPT-4 API Key π Google Drive (for resume and JD storage) π Google Sheet (job role mapping) π¬ SMTP credentials (host, username, password) π§° AlekSystem self-hosted or cloud instance with: PDF Parser Google Sheets node HTTP Download node Email node βοΈ How to Customize the Workflow | Part | Customization Options | |----------------------------|-------------------------------------------------------------| | Form UI | Modify the design, dropdown options, or input validations | | Job Description Source | Replace Google Sheet with Notion, Airtable, or database | | Interview Metadata | Add job level, region, or language preference | | AI Prompt Tuning | Adjust prompt phrasing or temperature in GPT nodes | | Report Format | Generate PDF instead of email body using PDF node | | Delivery Method | Add internal HR portal webhook or generate downloadable link |
Best fit
Categories
Services
Use cases
Need another direction?