{"product_id":"n8n-qa-qc-compliance-classifier-with-gemini-github-sheets","title":"n8n QA\/QC Compliance Classifier with Gemini, GitHub \u0026 Sheets","description":"\u003ch3\u003eQA\/QC compliance decisions—automated with Gemini, GitHub, and Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow answers QA\/QC compliance and non-conformance questions by retrieving evidence from a controlled \u003cstrong\u003eGitHub\u003c\/strong\u003e knowledge base using \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e, classifying results (Compliant\/Observation\/Minor\/Major), logging an audit record to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and escalating to your QA team via email when manual review or CAPA is needed.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a QA question\u003c\/strong\u003e through an n8n chat trigger and captures session metadata (query, session ID, timestamp, and source).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates the input\u003c\/strong\u003e to ensure the query is present and long enough to process.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses Google Gemini (RAG) with GitHub\u003c\/strong\u003e to:\n    \u003cul\u003e\n      \u003cli\u003eList approved QA\/QC documents in a \u003cstrong\u003eGitHub repository\u003c\/strong\u003e,\u003c\/li\u003e\n      \u003cli\u003eRetrieve the most relevant document text,\u003c\/li\u003e\n      \u003cli\u003eGenerate an evidence-grounded, structured assessment.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes the structured output\u003c\/strong\u003e into fields such as classification, severity score, requirement violated, recommended action, escalation\/CAPA flags, manual review flag, and source files.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEscalates when evidence is insufficient\u003c\/strong\u003e: if the agent indicates insufficient evidence, it appends a \u003cem\u003e“Pending Manual Review”\u003c\/em\u003e record to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and emails the QA team.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs and routes outcomes\u003c\/strong\u003e: otherwise, it appends the decision to a Google Sheets audit log and emails the QA team when escalation is required—then marks escalation as sent in the sheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAuto-assess QA\/QC compliance questions against approved documentation stored in \u003cstrong\u003eGitHub\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eClassify non-conformance into \u003cstrong\u003eCompliant\/Observation\/Minor\/Major\u003c\/strong\u003e with an evidence trail.\u003c\/li\u003e\n  \u003cli\u003eTrigger QA team review and CAPA\/escalation workflows when Gemini lacks sufficient evidence.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle AI (Gemini)\u003c\/strong\u003e with model \u003ccode\u003emodels\/gemini-3.5-flash-lite\u003c\/code\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGitHub tool\u003c\/strong\u003e for retrieving approved QA\/QC documents (public repo or configured access)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for audit log entries and escalation status\u003c\/li\u003e\n  \u003cli\u003eRouting logic and notifications using nodes such as \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003eswitch\u003c\/strong\u003e, and \u003cstrong\u003egmail\u003c\/strong\u003e (email to QA team)\u003c\/li\u003e\n  \u003cli\u003eNode includes \u003cstrong\u003esticky note\u003c\/strong\u003e for workflow clarity\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup requirements\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAdd credentials for \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e and ensure the selected model is available.\u003c\/li\u003e\n  \u003cli\u003eConfigure \u003cstrong\u003eGitHub\u003c\/strong\u003e access (or use a public repository).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46066366972083,"sku":"N8N-19740","price":21.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/fiXVY_a5W7-z4dEQczM7b_h6G1Y4PH.png?v=1789895253","url":"https:\/\/buyflowscripts.com\/products\/n8n-qa-qc-compliance-classifier-with-gemini-github-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}