{"product_id":"n8n-elevator-ticket-triage-with-google-sheets-gemini","title":"n8n Elevator Ticket Triage with Google Sheets \u0026 Gemini","description":"\u003ch3\u003eAutomatically triage elevator complaints, create tickets in Google Sheets, and notify the right people via WhatsApp + Gmail—using Google Gemini inside n8n\u003c\/h3\u003e\n\u003cp\u003eThe \u003cstrong\u003en8n Elevator Ticket Triage with Google Sheets \u0026amp; Gemini\u003c\/strong\u003e workflow receives elevator issues through webhooks, uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to classify and structure diagnostics, assigns the best available technician from a roster in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and keeps tickets, service logs, and parts inventory synchronized—then notifies technicians and clients via \u003cstrong\u003eWhatsApp\u003c\/strong\u003e and \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIngests complaints (1st POST webhook):\u003c\/strong\u003e receives an elevator complaint, looks up the elevator record and recent service history in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGemini-driven triage:\u003c\/strong\u003e sends the complaint to \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to determine \u003cstrong\u003eseverity (P1–P3)\u003c\/strong\u003e, \u003cstrong\u003erequired technician skill level\u003c\/strong\u003e, and a \u003cstrong\u003etechnician-ready summary\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChooses an available technician:\u003c\/strong\u003e selects a technician from a Google Sheets roster using skill level, territory, and current workload; generates a ticket ID and \u003cstrong\u003eSLA deadline\u003c\/strong\u003e, plus a dispatch message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates and updates records in Sheets:\u003c\/strong\u003e appends a new ticket to the \u003cstrong\u003eTickets\u003c\/strong\u003e sheet, updates the elevator’s current status, and either:\n    \u003cul\u003e\n      \u003cli\u003emarks the technician “\u003cstrong\u003eOn Job\u003c\/strong\u003e” and sends the dispatch via \u003cstrong\u003eWhatsApp\u003c\/strong\u003e plus a confirmation email via \u003cstrong\u003eGmail\u003c\/strong\u003e, or\u003c\/li\u003e\n      \u003cli\u003eemails an \u003cstrong\u003eunassigned-ticket alert\u003c\/strong\u003e when no technician is available.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses technician reports (2nd POST webhook):\u003c\/strong\u003e retrieves the ticket, elevator details, and the parts catalog from Google Sheets, then uses Gemini to extract \u003cstrong\u003eroot cause\u003c\/strong\u003e, \u003cstrong\u003ework performed\u003c\/strong\u003e, \u003cstrong\u003eparts used\u003c\/strong\u003e, \u003cstrong\u003esafety flags\u003c\/strong\u003e, and \u003cstrong\u003eclosure status\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCloses the loop in Google Sheets:\u003c\/strong\u003e appends a service log and updates the elevator registry (keeping operations and inventory in sync).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDispatching elevator technicians faster for \u003cstrong\u003eP1–P3\u003c\/strong\u003e incidents with skill-based assignment.\u003c\/li\u003e\n  \u003cli\u003eTurning technician notes into \u003cstrong\u003estructured diagnostics\u003c\/strong\u003e and consistent service logs.\u003c\/li\u003e\n  \u003cli\u003eManaging high-volume elevator operations without losing ticket history, SLA deadlines, or parts usage.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/stack:\u003c\/strong\u003e if, code, Gmail, webhook, WhatsApp, sticky note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets for tickets, elevator registry, technician roster, service logs, and parts catalog.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI triage:\u003c\/strong\u003e Google Gemini for severity classification and structured diagnostics extraction.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46160840622259,"sku":"N8N-20426","price":74.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/UJ1OMxlCOjUVSiJ9VTZN_HDOjTmhr.png?v=1791190960","url":"https:\/\/buyflowscripts.com\/products\/n8n-elevator-ticket-triage-with-google-sheets-gemini","provider":"N8N Commerce","version":"1.0","type":"link"}