Screen and Score Resumes from Gmail to Google Sheets with AI
This workflow streamlines the process of screening job applications. It triggers when a new email with a PDF resume attachment is received in Gmail. The workflow then extracts text and key candidate details from the resume using AI, evaluates and scores the candidate based on predefined criteria, and finally logs all the candidate's information, including their score, into a Google Sheet for easy management.
Apps Used:
Gmail
Google Sheets
OpenAICategories:
How It Works
- 1When a new email with a PDF attachment is received in Gmail
- 2Extract the text content from the PDF attachment using OCR
- 3Use AI to extract the candidate's Name, Email, LinkedIn, and Skills from the extracted text
- 4Use AI to score the candidate based on their extracted skills and experience
- 5Add a new row to a Google Sheet with the candidate's Name, Email, LinkedIn, and Score
Related Templates
Automate CV Screening with AI: Gmail to Google Sheets HR System
This workflow automates the CV screening process for HR professionals. It triggers when a new email with a CV attachment is received in Gmail. It then extracts the resume text using AI, evaluates the candidate's fit for a job using an LLM, and logs the results, including a score, into a Google Sheet. Finally, it sends a confirmation email to the applicant.
AI Resume Screening & Evaluation for HR with AI & Google Workspace
This workflow automates the screening and evaluation of job applications. When a candidate submits their application, their CV is uploaded to Google Drive. The system then uses AI to extract candidate information from the CV, retrieves the relevant job description from Google Sheets and Google Drive, and evaluates the candidate against the job requirements. Finally, it stores the results in Google Sheets and sends conditional notifications via Gmail or Slack.
Screen Resumes & Send Follow-ups with AI, Google Sheets & Gmail
This workflow automates resume screening. When a new resume (PDF) is submitted via a Google Form, its content is extracted and analyzed by AI. Based on the AI's evaluation and a set score threshold, the candidate is either accepted or rejected. The outcome is logged to the appropriate Google Sheet, and a personalized follow-up email (invite or rejection) is sent via Gmail.
Automate Resume Screening with Gmail, AI, and Airtable to Google Sheets
This workflow monitors a Gmail inbox for new emails containing PDF resume attachments. It extracts the job title from the email subject and matches it against open positions stored in Airtable. The resume file is then uploaded to Google Drive, and its content is sent to an AI for analysis, scoring the candidate, extracting key details, and providing feedback. All results, including candidate information, AI score, and a resume download link, are then appended as new rows in Google Sheets.
Automated Resume Scoring and Email Labeling with AI
This workflow automates the resume screening process. It triggers when a new email with a resume attachment is received in Gmail. The workflow extracts candidate details from the PDF resume, retrieves a relevant job profile from Notion, and uses an AI to score the resume's fit. The results are then updated in a Google Sheet, and the original email is labeled for easy tracking.
Process Logistics Orders from Gmail with AI and Google Sheets
This workflow triggers when a new email containing an inbound order is received in Gmail. It then uses an AI model to extract key order details such as PO number, delivery date, SKU ID, and quantity from the email body. Finally, the extracted information is automatically added as a new row to a specified Google Sheet for logistics tracking.