Automated Resume Screening from Gmail to Google Sheets
detail.loadingPreview
Streamline your hiring process by automatically screening resumes received via Gmail. This workflow extracts candidate information, assesses their suitability with AI, and logs the results directly into a Google Sheet.
About This Workflow
Tired of manually sifting through countless resumes? This n8n workflow automates the initial stages of recruitment. It monitors your Gmail for new emails with attachments, extracts the resume content (initially supporting PDFs), and leverages the power of AI (GPT-4o-mini) to analyze each resume. The AI identifies key candidate details like name, email, and LinkedIn profile, and provides a score indicating their suitability. All this valuable data is then neatly organized and appended to a designated Google Sheet, saving you significant time and effort in your candidate sourcing.
Key Features
- Automated Gmail Monitoring: Automatically detects new emails with attachments, perfect for recruitment.
- AI-Powered Resume Analysis: Utilizes advanced AI to extract key information and score candidate suitability.
- Structured Data Extraction: Parses resumes to pull out Name, Email, LinkedIn, and a custom Score.
- Seamless Google Sheets Integration: Appends all analyzed resume data to a specified Google Sheet for easy review.
- PDF Resume Support: Extracts text content directly from PDF attachments.
How To Use
- Configure Gmail Trigger: Set up the 'Trigger on new Email Received' node with your Gmail account and desired filters (e.g., unread emails with attachments).
- Extract Resume Text: Ensure the 'Extract text from PDF File' node is correctly linked to process PDF attachments from your emails.
- Set Up AI Agent: Configure the 'AI Agent to evaluate Resume' node. Provide a clear
systemMessageto guide the AI on what to extract and how to score. Link the AI model ('OpenAI Chat Model (GPT 4o-mini)') to this node. - Define Output Schema: In the 'Structured Output Parser' node, define the JSON schema for the data you want to extract (name, email, linkedin, score).
- Add to Google Sheets: Configure the 'Add Resume Evaluation to Google Sheets' node with your Google Sheet's Document ID and Sheet Name. Map the extracted data from the AI agent and the original resume text to the appropriate columns.
- Establish Connections: Ensure all nodes are connected in the correct order: Gmail -> PDF Extract -> AI Agent -> Output Parser -> Google Sheets.
- Provide Credentials: Authorize your Gmail and Google Sheets accounts within n8n.
Apps Used
Workflow JSON
{
"id": "c0ab35e8-a4db-4349-b9ee-4e91343bfc4c",
"name": "Automated Resume Screening from Gmail to Google Sheets",
"nodes": 17,
"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: c0ab35e8-a4db...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
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.