AI-Powered Hiring: Automated CV Analysis and Evaluation from Gmail to Sheets
detail.loadingPreview
This workflow automates the initial screening of job applications by detecting new CVs in Gmail, saving them to Google Drive, and using AI to extract information and score candidates against job descriptions stored in Google Sheets. It streamlines recruitment, saving HR teams significant time and effort.
About This Workflow
This n8n workflow revolutionizes your hiring process by automating the laborious initial stages of CV analysis and candidate evaluation. Triggered by new job applications arriving in your Gmail inbox, it intelligently identifies genuine CVs, extracts their content, and securely stores the documents in Google Drive. Leveraging the power of OpenAI, the workflow then compares the candidate's qualifications against specific job descriptions (pulled from Google Sheets), assigns a compatibility score, and even drafts personalized email responses. This end-to-end automation significantly reduces manual workload, accelerates time-to-hire, and ensures a consistent, data-driven approach to candidate shortlisting, allowing your HR team to focus on strategic tasks rather than administrative overhead.
Key Features
- Automated CV Ingestion: Automatically monitors Gmail for new job applications with attached CVs, downloading them for processing.
- AI-Powered Email Classification: Utilizes OpenAI to intelligently classify incoming emails, ensuring only legitimate job applications proceed through the workflow.
- Secure Document Management: Saves all received CVs directly to a designated Google Drive folder for organized, centralized storage.
- Intelligent Candidate Evaluation: An AI agent extracts key information from CVs and scores candidates (0-10) based on predefined job descriptions sourced from Google Sheets.
- Automated Communication Drafts: Generates draft email replies for candidates, speeding up initial communication following evaluation.
How To Use
- Install n8n: Ensure you have n8n installed. This workflow requires a self-hosted n8n instance for full integration with Gmail, OpenAI, and Google services.
- Obtain API Keys: Get your OpenAI API Key.
- Enable Google APIs: In the Google Cloud Console, enable the Google Sheets API and Google Drive API for your project.
- Create OAuth 2.0 Client ID: Set up an OAuth 2.0 Client ID and Secret in Google Cloud. This will be used for your Gmail, Google Drive, and Google Sheets credentials in n8n.
- Configure Credentials in n8n:
- Add a new Gmail OAuth2 credential.
- Add a new OpenAI API Key credential.
- Add a new Google Drive OAuth2 credential.
- Add a new Google Sheets OAuth2 credential.
- Authorize n8n to access these services using the generated credentials.
- Customize Gmail Trigger: In the 'Gmail: Watch for new CV' node, review and adjust the filters (
q,labelIds,readStatus) to match how you receive job applications. - Customize Google Sheets (Retrieve Job Offer Details): Update the 'Retrieve Job Offer Details (Google Sheets)' node with your specific Google Sheet Document ID and Sheet Name containing your job offer titles and descriptions. The workflow expects columns like 'Title offer' and 'Description'.
- Customize Google Drive (Save Resume): Adjust the 'Save Resume to Google Drive' node to specify the target Google Drive folder where CVs should be saved. The example uses 'CV - HR'.
- Activate Workflow: Once all configurations are complete and credentials are set up, activate the workflow. It will now automatically monitor your specified Gmail inbox for new CVs and process them.
Apps Used
Workflow JSON
{
"id": "a249e627-3045-4695-877b-9ee105346234",
"name": "AI-Powered Hiring: Automated CV Analysis and Evaluation from Gmail to Sheets",
"nodes": 29,
"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: a249e627-3045...
About the Author
DevOps_Master_X
Infrastructure Expert
Specializing in CI/CD pipelines, Docker, and Kubernetes automations.
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.