Audit interview feedback & report via Slack with GPT-4o-mini and Google Sheets

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 provides real-time Slack feedback to interviewers, logs AI errors for transparency, and recommends training if the feedback quality is low. What This Template Does (Step-by-Step) - ⚡ Manual Trigger – Runs the workflow manually to start evaluation. - 📋 Fetch Raw Feedback Data (Google Sheets) – Reads all feedback entries (Role, Stage, Interviewer Email, Feedback Text, rownumber). - 🧠 AI Quality Evaluator (Azure GPT-4o-mini) – Processes feedback into structured JSON across 5 dimensions. - 🔍 Analyze Feedback Quality (LLM Chain) – Applies scoring rules (Specificity, STAR, Bias-Free, Actionability, Depth) and outputs structured JSON. - ✅ Validate AI Response – Ensures AI output isn’t undefined or malformed. - 🚨 Log AI Errors (Google Sheets) – Records invalid AI responses for debugging and auditing. - 🔄 Parse AI JSON Output (Code Node) – Converts AI JSON text into structured n8n objects with error handling. - 🧮 Calculate Weighted Quality Score (Code Node) – Computes final weighted score (0–100), generates flags, formats vague phrases, and preserves context. - 💾 Save Scores to Spreadsheet (Google Sheets) – Updates the original feedback row with Score, Flags, and AI JSON. - 💬 Send Feedback Summary to Interviewer (Slack) – Sends interviewers a structured Slack report (score, flags, vague phrases, STAR improvement tips). - 🎯 Check if Training Needed – Applies threshold logic: if score < 50, route to training recommendations. - 📚 Send Training Recommendations (Slack) – Delivers STAR method guides and bias-free interviewing resources to low scorers.

Prerequisites - Google Sheets (RawFeedback + Error Log Sheet) - Azure OpenAI API credentials (for GPT-4o-mini) - Slack API credentials (for sending feedback & training notifications) - n8n instance (cloud or self-hosted)

Key Benefits ✅ Automated interview feedback quality scoring ✅ Bias detection and vague feedback flagging ✅ Real-time Slack feedback to interviewers ✅ Error logging for AI reliability tracking ✅ Training recommendations for low scorers ✅ Audit trail maintained in Google Sheets

Perfect For - HR & Recruitment teams ensuring structured interviewer feedback - Organizations enforcing STAR method & bias-free hiring - Teams seeking continuous interviewer coaching - Companies needing audit-ready records of interview quality