Screen Resumes with OpenAI and Google Sheets

# Automated Resume Processing & Evaluation System This workflow streamlines the process of handling resume submissions, extracting key details, summarizing qualifications, and aiding HR in the decision-making process. ## 1. Submission, Saving to Google Drive & Extraction The user submits a resume via a form. The system saves the uploaded file to Google Drive for record-keeping. AI-powered text extraction retrieves personal details, qualifications, and job history from the document. ## 2. Extraction (Personal Info & Qualification) The workflow identifies and extracts key details such as the candidate’s name, contact information, and location. It scans for educational background, certifications, and past work experiences. ## 3. Merge & Summarization The extracted data is merged into a structured format. A concise summary is generated, highlighting the candidate’s most relevant qualifications and experiences. ## 4. Voting, Consideration & Google Sheets HR reviews the summarized profile and assigns a rating (1-10). Hiring insights and comments are recorded for evaluation. All processed data, including extracted details and review scores, are appended to a Google Sheet for tracking and further consideration.