Audit interview feedback & report via Slack with GPT-4o-mini and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 12 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, Azure OpenAI Chat Model and Slack.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Fetch Raw Feedback Data (Google Sheets): uses Google Sheets
- Analyze Feedback Quality (Basic LLM Chain): sends a prompt to an LLM, with model: AI Quality Evaluator (GPT-4o
- Validate AI Response (If): checks a condition and branches into true / false
- Parse AI JSON Output (Code): runs custom JavaScript code
- Log AI Errors (Google Sheets): append
- Calculate Weighted Quality Score (Code): runs custom JavaScript code
- Send Feedback Summary to Interviewer (Slack): uses Slack
- Save Scores to Spreadsheet (Google Sheets): update
- Check if Training Needed (If): checks a condition and branches into true / false
- Send Training Recommendations (Slack): uses Slack
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 (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Azure OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatAzureOpenAi - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Slack
n8n-nodes-base.slack
From the author
Description This workflow automates the evaluation of interviewer feedback using AI. It retrieves raw notes from Google Sheets, processes them through GPT-4o-mini for structured scoring, validates outputs, and calculates weighted quality scores. The system…