n8n Workflow: AI-Powered Job Application Scoring and Feedback Generation

This n8n workflow automates the process of scoring job applications and generating personalized AI feedback using OpenAI and Notion. It listens for new or updated job applications in a Notion database, processes their content, and then uses an AI agent to score the application and write detailed feedback, finally updating the Notion database with the results.

What it does

This workflow streamlines the hiring process by:

1. Monitoring Notion Database: It triggers whenever a new item is created or an existing item is updated in a specified Notion database.
2. Filtering Applications: It checks if the "Status" property of the Notion page is set to "New Application". If not, it does nothing.
3. Extracting Application Data: It takes the content of the Notion page (likely the job application details or resume) and prepares it for AI processing.
4. AI-Powered Scoring and Feedback: It utilizes an OpenAI Chat Model within an AI Agent to:
   • Score the job application based on predefined criteria (implied by the "AI Agent" node).
   • Generate comprehensive feedback for the applicant.
5. Updating Notion: It updates the original Notion page with the generated score and feedback.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Notion Account: A Notion workspace with a database set up to manage job applications.
  • The database should have at least a "Status" property (e.g., a Select or Status type with an option like "New Application") and properties to store the AI-generated "Score" and "Feedback".
• OpenAI API Key: An API key for OpenAI to power the AI Agent and Chat Model. This will need to be configured as an n8n credential.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON workflow.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the "Import from JSON" button and paste the workflow JSON.
2. Configure Credentials:
   • Notion: You will need to set up a Notion credential. This typically involves creating an integration in Notion and granting it access to your job applications database.
   • OpenAI: You will need to set up an OpenAI API Key credential.
3. Configure Notion Trigger (Node 488: "Notion Trigger"):
   • Select your Notion credential.
   • Choose the "Database" you are using for job applications.
   • Configure the "Trigger When" option to "Created or Updated".
4. Configure Notion Node (Node 487: "Notion"):
   • Select your Notion credential.
   • Ensure the "Resource" is set to "Page" and the "Operation" is "Update".
   • Map the "Page ID" to {{ $json.page_id }} from the Notion Trigger.
   • Map the "Score" and "Feedback" properties in your Notion database to the output of the AI Agent node (e.g., {{ $json.score }} and {{ $json.feedback }} after the AI Agent has processed them).
5. Configure AI Agent (Node 1119: "AI Agent") and OpenAI Chat Model (Node 1153: "OpenAI Chat Model"):
   • Select your OpenAI credential for the "OpenAI Chat Model" node.
   • Within the "AI Agent" node, you will need to define the "System Message" and "User Message" to instruct the AI on how to score the application and generate feedback. This is crucial for the AI's performance. For example, you might provide a prompt like:
     • System Message: "You are an expert HR recruiter. Your task is to score job applications on a scale of 1-10 and provide constructive feedback. Focus on skills, experience, and relevance to the job description."
     • User Message: "Here is a job application: {{ $json.page_content }}. Please provide a score and detailed feedback."
     • You might also need to define the output format expected from the AI (e.g., JSON with score and feedback fields) and use a "Code" node (Node 834) or "Set" node (Node 38) to parse this output.
6. Activate the Workflow: Once configured, activate the workflow to start automating your job application process.

This workflow provides a powerful foundation for automating a significant part of your recruitment process, saving time and ensuring consistent, AI-driven feedback.