Automated CV Screening with OpenAI and Supabase

Name: Automated CV Screening with OpenAI and Supabase
Rating: 5 (5 reviews)
Author: Free N8N

Intermediate

19 nodes connected

detail.loadingPreview

Free N8N Temples

143 views

0 downloads

AutomationAICV ScreeningDocument ProcessingOpenAIRecruitmentSupabase

Automates CV screening using OpenAI for analysis and Supabase for structured data storage, providing matching scores and suitability insights.

About This Workflow

This workflow automates the resume screening process using OpenAI for analysis and Supabase for structured data storage. It is ideal for recruitment agencies, HR professionals, and hiring managers looking to automate the initial screening of CVs, especially when handling large volumes of applications.

The workflow downloads CVs from a direct link, extracts text data from PDF or DOC files, sends the data and job description to OpenAI for analysis (generating a matching score, summary, and suitability insights), and finally saves the structured analysis in Supabase.

Key Features

Automated File Download: Fetches CVs directly from a provided URL (e.g., Supabase storage, Dropbox).
PDF/Document Text Extraction: Extracts text content from PDF and other document formats.
AI-Powered Analysis: Leverages OpenAI's GPT-4o-mini model to analyze CVs against job descriptions.
Structured JSON Output: Receives analysis results in a predefined JSON schema format.
Customizable Prompts and Schemas: Allows for flexible configuration of OpenAI prompts and response JSON schemas.
Data Storage: Intended for saving results in Supabase for further processing or integration.

How To Use

Setup: Ensure you have an OpenAI API credential configured in n8n.
Configure Set Variables node:
- Update file_url with the direct link to the CV you want to process.
- Update job_description with the relevant job description.
- Adjust the prompt to tailor the AI's evaluation criteria.
- Review and modify the json_schema if your output requirements change.
Connect Nodes: The workflow is pre-configured with the following flow:
- When clicking ‘Test workflow’ (Manual Trigger)
- Set Variables (Defines input parameters like CV URL, job description, prompt, and JSON schema)
- Download File (Fetches the CV using the provided URL)
- Extract Document PDF (Extracts text from the downloaded PDF)
- OpenAI - Analyze CV (Sends extracted text and job description to OpenAI for analysis)
- Parsed JSON (Parses the JSON response from OpenAI)
Run the Workflow: Trigger the workflow by clicking 'Test workflow'.

Apps Used

CV Screening

Document Processing

OpenAI

Recruitment

Supabase

Workflow JSON

{
  "id": "dce6d1e4-516e-45d2-86d1-5b1bf0e87aa5",
  "name": "Automated CV Screening with OpenAI and Supabase",
  "nodes": 19,
  "category": "Automation",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.