Automated AI Resume Screening and Google Sheets Entry - n8n Workflow

HR professionals who handle high volumes of applications.
Recruiting agencies looking for automated pre-screening.
Companies seeking advanced n8n templates for data processing.
Technical teams wanting to integrate OpenAI and Google Sheets in an n8n workflow.

This powerful n8n workflow transforms tedious resume screening into an efficient, AI-driven process. The core problem solved is manually reviewing and inputting candidate data. By leveraging an n8n trigger (a submission form) and specialized n8n node capabilities (PDF extraction and LangChain integration), the system automatically pulls key personal and professional details. It then uses the OpenAI Chat Model to generate a professional summary and, crucially, act as an 'HR Expert' to score the candidate against a predefined job profile.

All results—raw data, summary, and AI score—are seamlessly recorded in Google Sheets, making this n8n workflow an essential tool for modern recruiting operations. This sophisticated n8n template dramatically reduces the time spent on initial candidate assessment.

This n8n workflow streamlines the entire hiring pipeline, starting with a powerful n8n trigger.

1. Form Submission: The n8n workflow begins with the Form Submission n8n trigger, where candidates submit their details and upload their PDF resume file.


2. File Handling and Extraction: The workflow simultaneously uploads the resume to Google Drive for secure storage and uses the Resume Extraction n8n node to convert the binary PDF file into extractable text.


3. AI Data Extraction: Two separate LangChain Information Extractor n8n node steps (Personal Info and Qualification) process the extracted text. These nodes structure disparate resume content into specific JSON fields (e.g., email, skills, job history).


4. Data Merge and Summarization: The extracted data is combined using the Merge n8n node. The Summarizer n8n node (using the OpenAI Chat Model) then generates a concise, 100-word professional candidate summary.


5. Profile Definition: A Set n8n node ('wanted profile') defines the exact qualifications and skills required for the open position.


6. AI Evaluation: The HR Expert n8n node, operating under the instruction of the job profile and guided by a Structured Output Parser n8n node, assesses the candidate. It assigns a quantitative rating (1-10) and provides detailed hiring insights (Consideration).


7. Database Logging: Finally, the Google Sheets n8n node uses all the structured data, including the AI’s vote and reasoning, to append a new row to a designated spreadsheet. This completes the fully automated screening process implemented by this n8n workflow.

To utilize this powerful n8n workflow, follow these steps:

1. Import the n8n template: Copy the provided JSON code and paste it into your n8n instance using the 'New' -> 'Import from JSON' function.


2. Google Drive & Sheets Credentials: You must configure credentials for Google Drive and Google Sheets. Click on the corresponding n8n node (e.g., 'Upload to google drive') and authenticate your Google account to grant n8n access to your Drive and Spreadsheet files. Ensure the specified document ID for the Google Sheets n8n node is correct.


3. OpenAI Credentials: Set up your OpenAI API key credentials for the 'OpenAI Chat Model' n8n node. This connection powers all the extraction, summarization, and HR evaluation steps.


4. Configure the Trigger: Activate the 'On form submission' n8n trigger. After saving and activating the workflow, you can access the public form URL to test submissions.


5. Define the Profile: Adjust the 'wanted profile' n8n node content to reflect the specific job description you are currently hiring for.

This n8n workflow relies on several specialized n8n node types for complex data handling and AI interaction:

On form submission (Form Trigger n8n node): Serves as the initial n8n trigger, capturing candidate details and the PDF resume file. Key configuration includes defining required fields like First Name, Email, and Resume file.
Resume extraction (Extract From File n8n node): Converts the binary PDF file content into raw text, which is essential for subsequent AI processing.
Personal Info / Qualification (LangChain Information Extractor n8n node): These nodes use structured schemas and specific prompts to pull targeted data points (e.g., skills, city, job history) from the raw resume text.
Summarizer (LangChain Chain Summarization n8n node): Generates a concise, 100-word professional summary based on the merged extracted data, acting as an input for the final AI evaluation.
HR Expert (LangChain Chain LLM n8n node): This is the core logic engine. It uses the gpt-4o-mini model (via the OpenAI Chat Model connection) to compare the candidate summary against the 'wanted profile' defined in a preceding n8n node, outputting a score and reasoning.
Structured Output Parser (n8n node): Ensures the AI’s response from the HR Expert n8n node is strictly formatted into vote and consideration fields.

• Google Sheets (n8n node): The final action, appending all extracted candidate data and AI evaluation scores into a designated spreadsheet for tracking.