n8n Elevator Ticket Triage with Google Sheets & Gemini

Automatically triage elevator complaints, create tickets in Google Sheets, and notify the right people via WhatsApp + Gmail—using Google Gemini inside n8n

The n8n Elevator Ticket Triage with Google Sheets & Gemini workflow receives elevator issues through webhooks, uses Google Gemini to classify and structure diagnostics, assigns the best available technician from a roster in Google Sheets, and keeps tickets, service logs, and parts inventory synchronized—then notifies technicians and clients via WhatsApp and Gmail.

What this workflow does

• Ingests complaints (1st POST webhook): receives an elevator complaint, looks up the elevator record and recent service history in Google Sheets.
• Gemini-driven triage: sends the complaint to Google Gemini to determine severity (P1–P3), required technician skill level, and a technician-ready summary.
• Chooses an available technician: selects a technician from a Google Sheets roster using skill level, territory, and current workload; generates a ticket ID and SLA deadline, plus a dispatch message.
• Creates and updates records in Sheets: appends a new ticket to the Tickets sheet, updates the elevator’s current status, and either:
  • marks the technician “On Job” and sends the dispatch via WhatsApp plus a confirmation email via Gmail, or
  • emails an unassigned-ticket alert when no technician is available.
• Processes technician reports (2nd POST webhook): retrieves the ticket, elevator details, and the parts catalog from Google Sheets, then uses Gemini to extract root cause, work performed, parts used, safety flags, and closure status.
• Closes the loop in Google Sheets: appends a service log and updates the elevator registry (keeping operations and inventory in sync).

Use cases

• Dispatching elevator technicians faster for P1–P3 incidents with skill-based assignment.
• Turning technician notes into structured diagnostics and consistent service logs.
• Managing high-volume elevator operations without losing ticket history, SLA deadlines, or parts usage.

Technical details

• n8n nodes/stack: if, code, Gmail, webhook, WhatsApp, sticky note.
• Integrations: Google Sheets for tickets, elevator registry, technician roster, service logs, and parts catalog.
• AI triage: Google Gemini for severity classification and structured diagnostics extraction.