{"product_id":"n8n-workflow-triage-parent-incidents-with-gemini-sheets-slack","title":"n8n Workflow: Triage Parent Incidents with Gemini, Sheets \u0026 Slack","description":"\u003ch3\u003eInstantly triage parent incidents end-to-end with n8n + Gemini + Google Sheets + Slack\u003c\/h3\u003e\n\u003cp\u003eGet a fully automated incident intake workflow that collects parent complaints via an \u003cstrong\u003en8n Form\u003c\/strong\u003e, enriches them with \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e student data, classifies each case using \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e (text + optional image), logs everything to Sheets, and alerts your team in \u003cstrong\u003eSlack\u003c\/strong\u003e—with a \u003cstrong\u003eWhatsApp\u003c\/strong\u003e fallback when the student ID lookup fails.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a parent submission\u003c\/strong\u003e from an n8n Form, including contact details, student ID, incident description, and an optional attachment image.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a unique ticket ID\u003c\/strong\u003e and attempts to \u003cstrong\u003elook up the student\u003c\/strong\u003e in the Google Sheets spreadsheet named \u003cstrong\u003estudent_info\u003c\/strong\u003e using the submitted student ID.\u003c\/li\u003e\n  \u003cli\u003eIf the student ID lookup fails, it \u003cstrong\u003elooks up by parent mobile\u003c\/strong\u003e in the same Google Sheets data and \u003cstrong\u003esends a WhatsApp message\u003c\/strong\u003e asking the parent to recheck the student ID.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates the attachment\u003c\/strong\u003e as JPG\/PNG; if missing or invalid, it substitutes a blank image for the AI analysis pipeline.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies the complaint with Google Gemini\u003c\/strong\u003e, producing a structured output including category\/subcategory, \u003cstrong\u003eseverity (P0–P3)\u003c\/strong\u003e, regulatory risk, a brief summary, and attachment findings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs\/updates the ticket\u003c\/strong\u003e in the Google Sheets spreadsheet \u003cstrong\u003etickets-issues\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts a detailed alert to Slack\u003c\/strong\u003e with the AI results and ticket information.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eShows a confirmation page\u003c\/strong\u003e to the submitter with the generated ticket ID and the AI-assigned priority\/subcategory.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomating intake and triage of \u003cstrong\u003eschool parent complaints\u003c\/strong\u003e with consistent priority and categorization.\u003c\/li\u003e\n  \u003cli\u003eReducing manual back-and-forth when \u003cstrong\u003estudent IDs are incorrect\u003c\/strong\u003e by prompting via \u003cstrong\u003eWhatsApp\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eCentralizing incident history in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e while keeping teams informed through \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n Form\u003c\/strong\u003e for submissions\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e lookup in \u003cem\u003estudent_info\u003c\/em\u003e and logging to \u003cem\u003etickets-issues\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e for category\/subcategory, severity (P0–P3), regulatory risk, and summary\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e for detailed incident alerts\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWhatsApp\u003c\/strong\u003e message when ID lookup fails\u003c\/li\u003e\n  \u003cli\u003eWorkflow nodes\/logic: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eform\u003c\/strong\u003e, \u003cstrong\u003eslack\u003c\/strong\u003e, \u003cstrong\u003ewhats app\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46105996460211,"sku":"N8N-19963","price":39.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/vPIk52wyJhazcNuJXHKoJ_7NSDslYh.png?v=1790500096","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-triage-parent-incidents-with-gemini-sheets-slack","provider":"N8N Commerce","version":"1.0","type":"link"}