Parse CVs from Emails with OCR & AI for Notion Database
This workflow monitors a Gmail inbox for new emails containing PDF attachments, which are assumed to be candidate CVs. It extracts text from the PDF using OCR and then structures the data using an AI LLM. Finally, the processed candidate information is used to create or update an entry in a specified Notion database.
Apps Used:
Gmail
PDF OCR Reader
OpenAI
NotionCategories:
How It Works
- 1When a new email with a PDF attachment is received in Gmail.
- 2Extract text from the PDF attachment using OCR.
- 3Use AI to structure the extracted text, identifying key candidate information.
- 4Add or update a page in a Notion database with the structured candidate data.
Related Templates
AI-Powered Candidate Screening and Evaluation with Airtable
This workflow automates the candidate screening process. It triggers when a new application is submitted via Google Forms, including a PDF resume upload. The workflow extracts text from the resume, stores it in Google Drive, and uses AI (OpenAI) to evaluate the candidate against job requirements fetched from Airtable. Finally, it creates a new candidate record in Airtable with the evaluation results and sends an email notification to HR if the candidate is deemed suitable.
Automate CV Screening & Candidate Validation from New Emails
This workflow automatically screens and validates candidate CVs received via email. It triggers on new emails with attached PDFs, extracts text from the CVs, uses AI to parse key candidate information, checks for required fields, and then either saves valid CVs to Google Drive or sends an email notification to HR for invalid submissions.
Extract Data from Documents with Dynamic AI Prompts using Google Sheets
This workflow is triggered when a new row is added to a Google Sheet containing a document link. It processes the document (e.g., a PDF resume) by extracting its text content. Using prompts fetched from another Google Sheet, an AI extracts specific fields of information. Finally, the extracted data is updated back into the original Google Sheet row.
Classify Incoming Emails & Extract Structured Data with AI
This workflow automatically processes newly received emails. It uses AI to classify the email content and any extracted text from attachments into predefined categories. If an email is identified as a job application, AI extracts specific structured data (e.g., name, study, age) from the email and its attachments, which can then be used to update a CRM.
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.
AI-Powered CV Extractor: Google Drive to Google Sheets with Slack Notification
This workflow monitors a Google Drive folder for newly uploaded PDF resumes. It automatically extracts text from the PDF using OCR and then utilizes AI (GPT-4) to extract structured candidate information, such as name, job title, and experience. The extracted data is then used to update an existing row or add a new row in a Google Sheet serving as a candidate database. Finally, the hiring team is notified via Slack with a summary of the new or updated candidate profile.