Classify QA/QC compliance issues with Google Gemini, GitHub, 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 17 nodes and runs when a chat message arrives. Along the way it connects Google Gemini Chat Model, GitHub, HTTP Request and Google Sheets and 1 more.
How it runs
Trigger: When a chat message arrives.
- Set Query Metadata (Edit Fields (Set)): sets 4 fields: query, session_id, timestamp…
- If: checks a condition and branches into true / false
- QA/QC Compliance Agent (AI Agent): runs an AI agent, with model: Google Gemini Chatbot; 2 tools (Get QA Document, Fetch QA Knowledge Files); output parser: Parse Structured Output
- Normalize Compliance Data (Edit Fields (Set)): sets 12 fields: classification, severity_score, requirement_violated…
- Check Manual Review Requirement (If): checks a condition and branches into true / false
- Append Manual Review to Sheets (Google Sheets): append
- Route by Classification (Switch): routes items into 4 branches
- Send Review Alert Email (Gmail): uses Gmail
- Append QA Decision to Sheets (Google Sheets): append
- Check Escalation Requirement (If): checks a condition and branches into true / false
…plus 2 more steps. See the full node list below.
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 (11)
- Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Github Tool
n8n-nodes-base.githubTool - Http Request Tool
n8n-nodes-base.httpRequestTool - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Switch
n8n-nodes-base.switch - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow answers QA/QC compliance and non-conformance questions from a controlled GitHub knowledge base using Google Gemini, then classifies findings (Compliant/Observation/Minor/Major), logs an audit record to Google Sheets, and emails…