{"product_id":"n8n-elevator-callback-triage-openai-notes-telegram-gmail-alerts","title":"n8n Elevator Callback Triage: OpenAI Notes + Telegram\/Gmail Alerts","description":"\u003ch3\u003eDetect new elevator callback issues and certificate expiry—automatically triaged with OpenAI + sent to Telegram and Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow polls your elevator monitoring\/callback API every 30 minutes, compares results to a saved state in an n8n Data Table, extracts structured fault details from technician notes using OpenAI, and sends \u003cstrong\u003eurgent Telegram alerts\u003c\/strong\u003e for newly detected callbacks with entrapment risk plus \u003cstrong\u003eGmail compliance notices\u003c\/strong\u003e when inspection certificates enter a \u003cstrong\u003e14-day expiry window\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a 30-minute schedule\u003c\/strong\u003e via a scheduled trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches current unit status\u003c\/strong\u003e from your elevator monitoring\/callback API (including the latest callback IDs and certificate expiry data).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads the prior snapshot\u003c\/strong\u003e from an \u003cstrong\u003en8n Data Table\u003c\/strong\u003e and compares per \u003cem\u003eelevatorId\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects newly opened callbacks\u003c\/strong\u003e by finding newly appearing callback IDs vs. the previously stored list.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFlags certificates that are imminent\u003c\/strong\u003e when they just entered the \u003cstrong\u003e14-day-to-expiry\u003c\/strong\u003e window.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses OpenAI to extract structured details\u003c\/strong\u003e from technician notes for each newly detected event, including \u003cem\u003efaultType\u003c\/em\u003e, \u003cem\u003eentrapment risk\u003c\/em\u003e, and \u003cem\u003eestimated down duration\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends Telegram alerts\u003c\/strong\u003e to the on-call mechanic when \u003cem\u003eentrapment risk\u003c\/em\u003e is true.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends Gmail notices\u003c\/strong\u003e to the property manager for expiring inspection certificates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpserts updated state\u003c\/strong\u003e (latest callback IDs + certificate flag) back into the n8n Data Table so alerts trigger only on changes.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRapid escalation when technician notes indicate potential entrapment risk for a newly opened elevator callback.\u003c\/li\u003e\n  \u003cli\u003eProperty manager compliance tracking for inspection certificates nearing expiry.\u003c\/li\u003e\n  \u003cli\u003eReduced alert fatigue by notifying only on newly detected events (no repeated messages for unchanged callback lists).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled trigger\u003c\/strong\u003e, \u003cstrong\u003eHTTP request\u003c\/strong\u003e to your elevator monitoring API\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n Data Table\u003c\/strong\u003e for state tracking (elevatorId, buildingName, lastKnownCallbackIdsJson, certExpiryIso, certFlagged, lastCheckedAt)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e for structured extraction from technician notes\u003c\/li\u003e\n  \u003cli\u003eLogic and routing with \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, and \u003cstrong\u003emerge\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003etelegram\u003c\/strong\u003e for on-call mechanic alerts and \u003cstrong\u003egmail\u003c\/strong\u003e for compliance messages\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45949984866483,"sku":"N8N-19180","price":66.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/2ozM24xFaki5P8JRc53yu_6Dqhi2Bz.png?v=1788512721","url":"https:\/\/buyflowscripts.com\/products\/n8n-elevator-callback-triage-openai-notes-telegram-gmail-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}