Automated Resume Review System Using OpenAI + Google Sheets

Automated Resume Review System using OpenAI streamlines the resume submission process by capturing user information, extracting key details from uploaded resumes, and generating concise summaries of qualifications. It enables HR to efficiently evaluate candidates by assigning ratings and insights, all while storing data in Google Sheets for easy tracking and record-keeping. This workflow enhances decision-making and reduces manual effort in the hiring process.

7/8/2025
17 nodes
Complex
manualcomplexformtriggerlangchaingooglesheetssticky notegoogle driveextractfromfileadvancedfilesstorage
Categories:
Complex WorkflowManual TriggeredData Processing & Analysis
Integrations:
FormTriggerLangChainGoogleSheetsSticky NoteGoogle DriveExtractFromFile

Target Audience

Target Audience


- HR Professionals: Streamline the resume review process and improve hiring efficiency.
- Recruiters: Enhance candidate evaluation with automated insights and structured data.
- Small Business Owners: Simplify recruitment without needing extensive HR resources.
- Automation Enthusiasts: Learn to integrate AI and automation tools in workflows.
- Job Seekers: Understand how their resumes are processed and evaluated by HR systems.

Problem Solved

Problem Solved


This workflow automates the resume submission and evaluation process, addressing the following issues:
- Time Consumption: Reduces the time HR spends on manual resume reviews.
- Inconsistent Evaluations: Provides a standardized scoring system based on candidate qualifications.
- Data Management: Automatically organizes candidate information in Google Sheets for easy tracking and analysis.
- Quality of Hire: Enhances the quality of hiring decisions through AI-driven insights and structured data.

Workflow Steps

Workflow Steps


1. Form Submission: Candidates submit their resumes through a form, providing personal details and uploading their CVs.
2. File Upload: The uploaded resume is saved to Google Drive for record-keeping.
3. Resume Extraction: The system extracts text from the PDF resume to retrieve personal information, qualifications, and job history.
4. Information Extraction: Personal details (name, email, etc.) and qualifications (education, job history, skills) are extracted using AI algorithms.
5. Merging Data: Extracted information is combined into a structured format for easier evaluation.
6. Summarization: A concise summary of the candidate's qualifications is generated, highlighting key attributes.
7. Evaluation by HR Expert: An HR expert reviews the summary, assigns a rating (1-10), and provides insights on the candidate's fit for the role.
8. Data Storage: All candidate information, including the evaluation, is appended to a Google Sheet for further analysis and tracking.

Customization Guide

Customization Guide


- Modify Form Fields: Adjust the form fields to collect additional information relevant to your hiring process.
- Change Evaluation Criteria: Update the scoring system or evaluation prompts in the HR Expert node to align with your organization's specific requirements.
- Personalize Summarization Prompts: Tailor the summarization prompts to reflect the language and tone preferred by your organization.
- Integrate Additional Tools: Expand the workflow by integrating other tools or services that enhance the recruitment process, such as email notifications or additional data analytics platforms.
Automated Resume Review System Using OpenAI + Google Sheets - N8N Workflow Directory