Evaluate interview & update scores with Azure GPT-4o-mini and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 7 nodes and runs on Google Sheets events. Along the way it connects Google Sheets and Azure OpenAI Chat Model.
How it runs
Trigger: On Google Sheets events.
- AI Questionnaire Evaluator (AI Agent): runs an AI agent, with model: Azure OpenAI GPT-4 Model
- Parse AI Evaluation Results (Code): runs custom JavaScript code
- Lookup Candidate Profile Data (Google Sheets): uses Google Sheets
- Calculate Combined Scores (Edit Fields (Set)): sets 1 field: Questionarie Score
- Update Candidate Database (Google Sheets): append or update
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - Azure OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatAzureOpenAi - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set
From the author
Description Automatically score candidate questionnaire responses using Azure OpenAI (GPT-4o-mini), combine them with existing evaluations from Google Sheets, and keep your candidate database up to date—all in near real time. Get consistent, structured scores…