Automate Candidate Analysis & Ranking with Jotform and Gemini AI

This n8n workflow streamlines the candidate evaluation process by automatically analyzing and ranking job applicants based on their Jotform submissions. It leverages Google Gemini AI to process candidate data, provides a human-in-the-loop approval step, and logs results to Google Sheets, with email notifications for successful candidates.

What it does

1. Triggers on New Jotform Submissions: Listens for new candidate applications submitted via Jotform.
2. Analyzes Candidate Data with AI: Sends the candidate's application data to a Google Gemini AI Agent for analysis and ranking.
3. Stores Raw Data: Saves the raw Jotform submission data into a Google Sheet.
4. Conditional Approval: Checks if the AI analysis result contains a specific approval keyword (e.g., "APPROVED").
5. Notifies Approved Candidates: If the candidate is approved by the AI, an email is sent to the candidate informing them of the next steps.
6. Logs AI Analysis to Google Sheets: Appends the AI agent's analysis and ranking to a Google Sheet for record-keeping.

Prerequisites/Requirements

• n8n Account: A running n8n instance.
• Jotform Account: A Jotform account with a form configured for job applications.
• Google Sheets Account: A Google Sheets spreadsheet to store candidate data and AI analysis.
• Google Gemini AI (via Langchain integration): Access to Google Gemini through the n8n Langchain integration. This typically requires a Google Cloud Project and API key.
• Gmail Account: A Gmail account for sending automated emails.

Setup/Usage

1. Import the workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Credentials:
   • Jotform Trigger: Set up your Jotform API credentials and select the form you want to monitor.
   • Google Sheets: Configure your Google Sheets credentials (OAuth2 is recommended) and specify the spreadsheet and sheet names for both data storage nodes.
   • Google Gemini Chat Model: Configure your Google Gemini credentials (usually an API key).
   • Gmail: Set up your Gmail credentials (OAuth2 is recommended).
3. Customize AI Agent:
   • Open the "AI Agent" node.
   • Review and adjust the "System Message" and "User Message" to guide the AI on how to analyze and rank candidates effectively. Ensure the AI's output format is consistent for the "If" node to correctly identify approved candidates.
4. Adjust "If" Node Condition:
   • The "If" node currently checks for a specific string (e.g., "APPROVED") in the AI's output. Adjust this condition ({{ $json.output.includes("APPROVED") }}) to match the expected approval indicator from your AI agent.
5. Customize Email Content:
   • Open the "Gmail" node.
   • Modify the "To", "Subject", and "Body" fields to personalize the email sent to approved candidates. Use expressions to dynamically insert candidate information from the Jotform submission.
6. Activate the Workflow: Once configured, activate the workflow to start processing new Jotform submissions.