Library / Documents, PDF & OCR
Documents, PDF & OCR
Analyze CVs from Gmail with OpenAI into Google Sheets
When a new Gmail message arrives, OpenAI classifies it as a job application, evaluates the attached CV and records the evaluation in Google Sheets.
What it does
## AI-Powered HR Workflow: CV Analysis and Evaluation from Gmail to Sheets ### 📋 Before you get started, make sure you have: - ✅ n8n installed *(self-hosted required for Gmail + OpenAI + Google integrations)* - ✅ OpenAI API Key - ✅ Google Sheets API enabled in Google Cloud Console - ✅ Google Drive API enabled in Google Cloud Console - ✅ OAuth 2.0 Client ID and Secret created in Google Cloud (required for Gmail, Drive, and Sheets nodes) > Make sure you’ve authorized n8n to access these services using the credentials above before running the workflow.
The steps
- Gmail: Watch for new CV
- Classify Email Type
- OpenAI Model – Email Classifier
- Skip (If not a job application)
- Extract Resume Text (PDF)
- Save Resume to Google Drive
- Retrieve Job Offer Details (Google Sheets)
- AI Agent: Score Resume
- OpenAI Model – Resume Scoring
- Send Confirmation Email
- Parse Resume Evaluation Result
- Save Score to Google Sheets
- Switch
- Save CV to Google Sheets
Similar automations
Documents, PDF & OCRCreate tailored CVs, cover letters and follow-up emails with Claude, Apify and Google45 stepsDocuments, PDF & OCRAnonymize and Reformat CVs with Gemini and Google Sheets14 stepsDocuments, PDF & OCRScreen Job Applicant CVs with OpenAI and Log Results to Google Sheets13 stepsDocuments, PDF & OCRParse CVs from Email into Notion with OpenAI10 steps