Automated AI Candidate Screening for HR Efficiency
detail.loadingPreview
This workflow automates initial candidate screening by triggering AI-powered calls from new Google Sheet entries. It uses an AI voice assistant to gather key candidate information, extracts structured data from call transcripts using Google Gemini, and seamlessly updates your Google Sheet with the collected details.
About This Workflow
Revolutionize your recruitment process with this powerful n8n workflow. Designed for HR teams and recruiters, it automatically initiates AI voice calls to candidates whenever a new entry is added to your Google Sheet. The AI assistant engages candidates to collect critical information like total work experience, current and expected CTC, notice period, and work preferences. Following the call, the workflow leverages Google Gemini to intelligently analyze the call transcript, extracting all required data points into a structured format. Finally, this valuable information is automatically updated back into your Google Sheet, providing a real-time, comprehensive candidate profile and significantly reducing manual screening efforts.
Key Features
- Automated Candidate Outreach: Instantly trigger AI-powered voice calls to candidates upon new entries in Google Sheets.
- Intelligent Voice Assistant (Vapi.ai): Utilize an AI voice assistant to conduct natural language conversations and gather essential candidate details.
- AI-Driven Data Extraction (Google Gemini): Automatically process call transcripts with Google Gemini to accurately extract structured information like salary expectations, notice period, and work preferences.
- Standardized Data Collection: Capture consistent data points across all candidates, ensuring a uniform and objective screening process.
- Seamless Google Sheets Integration: Automatically update your master candidate tracking sheet with all collected and parsed data in real-time.
How To Use
- Configure Google Sheets Trigger:
- Connect your Google Sheets account.
- Select your "HR Calling Data" spreadsheet and the specific sheet (e.g., "Sheet1").
- Set the trigger event to "rowAdded" to initiate calls for new entries.
- Set Up "Make a Call" (Vapi.ai):
- Replace
<Token>in the Authorization header with your Vapi.ai API key. - Dynamically pass the candidate's phone number from the Google Sheets trigger node (
{{ $json."Phone No." }}) into thecustomer.numberfield in the JSON body. - Ensure
assistantIdandphoneNumberIdare correctly configured for your Vapi.ai setup.
- Replace
- Configure "Get Call Transcript" (Vapi.ai):
- Replace
<Token>in the Authorization header with your Vapi.ai API key. - Update the URL to dynamically include the call ID from the "Make a Call" node (e.g.,
https://api.vapi.ai/call/{{ $node["Make a Call"].json.id }}).
- Replace
- Connect Google Gemini Chat Model:
- Connect your Google Gemini (PaLM) API credentials.
- The model will process the transcript from the previous node, guided by the Structured Output Parser's schema.
- Utilize Structured Output Parser:
- This node is pre-configured with a comprehensive schema to extract specific HR-related data points. Review the schema and customize if your required data points differ.
- Configure "Update row in sheet":
- Connect your Google Sheets account.
- Map the output fields from the "Structured Output Parser" (e.g.,
{{ $json.output['Current CTC'] }}) to the corresponding columns in your Google Sheet. - Ensure a unique identifier (like "Phone No." from the initial trigger) is used to match and update the correct row.
Apps Used
Workflow JSON
{
"id": "042bc4ac-6345-459d-a6c7-7395e209e0a4",
"name": "Automated AI Candidate Screening for HR Efficiency",
"nodes": 27,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 042bc4ac-6345...
About the Author
Free n8n Workflows Official
System Admin
The official repository for verified enterprise-grade workflows.
Statistics
Related Workflows
Discover more workflows you might like
Google Sheets to Icypeas: Automated Bulk Domain Scanning
This workflow streamlines the process of performing bulk domain scans by integrating your Google Sheets data directly with the Icypeas platform. Automate the submission of company names from your spreadsheet to Icypeas for comprehensive domain information, saving valuable time and effort.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.