n8n Resume Screening & Evaluation System with Gemini AI, Google Sheets & Drive

This n8n workflow automates the process of screening and evaluating resumes using Google Gemini AI, integrating with Google Sheets for data management and Google Drive for file storage. It streamlines the HR recruitment process by extracting key information from resumes, summarizing them, and providing structured evaluations.

What it does

This workflow is triggered by a form submission (likely containing resume details or a link to a resume file). Here's a step-by-step breakdown:

1. Triggers on Form Submission: The workflow starts when a new form submission is received. This form is expected to provide the necessary input for the resume screening process.
2. Extracts Resume Content (Implicit): Although not explicitly shown with a direct connection in the JSON, the "Extract from File" node suggests that the workflow is designed to process file attachments, likely resumes, from the form submission or a linked source. It would extract the text content from these files.
3. Summarizes Resume with Gemini AI: The extracted resume content is passed to a "Summarization Chain" node, which uses the Google Gemini Chat Model to generate a concise summary of the resume.
4. Extracts Key Information with Gemini AI: Concurrently or subsequently, an "Information Extractor" node (also powered by Google Gemini Chat Model) processes the resume to pull out specific, structured information (e.g., candidate name, contact, skills, experience).
5. Parses Structured Output: The extracted information is then processed by a "Structured Output Parser" to ensure it conforms to a predefined schema, making it ready for structured storage.
6. Merges Data: The summarized text and the structured extracted information are combined using a "Merge" node, creating a comprehensive data package for each resume.
7. Stores Data in Google Sheets: The merged, processed resume data (summary and extracted information) is then written to a Google Sheet, providing a centralized and organized database of applicants.
8. Manages Files in Google Drive (Implicit): The presence of a "Google Drive" node suggests that the original resume files might be uploaded, organized, or retrieved from Google Drive as part of the process, though its exact position in this specific JSON is not connected.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Google Account: A Google account with access to:
  • Google Sheets: To store the extracted and summarized resume data.
  • Google Drive: Potentially for storing or retrieving resume files.
• Google Gemini API Key: Access to the Google Gemini AI model for summarization and information extraction. This will be configured within the "Google Gemini Chat Model" node's credentials.
• n8n Form Trigger: The n8n Form Trigger node needs to be set up to receive submissions.

Setup/Usage

1. Import the Workflow: Import the provided JSON into your n8n instance.
2. Configure Credentials:
   • Set up your Google Sheets credentials (OAuth 2.0 or API Key) to allow n8n to write data to your specified spreadsheet.
   • Set up your Google Drive credentials (OAuth 2.0) if you intend to use Google Drive for file operations.
   • Configure the Google Gemini Chat Model node with your Google Gemini API key.
3. Configure Form Trigger: Set up the "n8n Form Trigger" node. You'll get a webhook URL that you can use in your external forms (e.g., a Google Form, Typeform, or custom HTML form) to send resume data.
4. Configure Google Sheets Node: Specify the Google Sheet ID and the sheet name where you want the resume data to be stored. Map the incoming data fields from the AI processing to the columns in your Google Sheet.
5. Configure AI Nodes:
   • Summarization Chain: Ensure the prompt for summarization is appropriate for resumes.
   • Information Extractor: Define the schema for the information you want to extract (e.g., name, email, phone, skills, experience, education). This is crucial for the "Structured Output Parser" to work correctly.
   • Structured Output Parser: Verify that the output schema matches the expected format for your Google Sheet.
6. Test the Workflow: Run a test submission through your form to ensure the data is processed correctly by Gemini AI and then written to your Google Sheet.