{"product_id":"n8n-gmail-fire-sprinkler-deficiency-router-with-openai-sheets","title":"n8n Gmail Fire Sprinkler Deficiency Router with OpenAI \u0026 Sheets","description":"\u003ch3\u003eTurn fire sprinkler deficiency emails into the right action—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors your \u003cstrong\u003eGmail\u003c\/strong\u003e inbox for fire sprinkler inspection deficiency messages, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to classify severity, then routes critical items for urgent notice while logging every decision to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for AHJ resubmission tracking.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePolls Gmail every 15 minutes\u003c\/strong\u003e for unread emails with subjects matching \u003cem\u003e“deficiency”\u003c\/em\u003e or \u003cem\u003e“sprinkler inspection.”\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts and normalizes\u003c\/strong\u003e the email details—subject, sender address, body text, and received timestamp—for consistent processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates compliance deadlines\u003c\/strong\u003e and flags potential repeat violations (e.g., via keywords found in the email text). Critical items are assigned a \u003cstrong\u003e24-hour\u003c\/strong\u003e deadline; standard items use a \u003cstrong\u003e30-day\u003c\/strong\u003e window.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies severity with OpenAI\u003c\/strong\u003e into: \u003cstrong\u003elife-safety critical\u003c\/strong\u003e, \u003cstrong\u003estandard violation\u003c\/strong\u003e, or \u003cstrong\u003einformational\/cosmetic\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes outcomes automatically\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eLife-safety critical:\u003c\/strong\u003e sends an emergency corrective notice via \u003cstrong\u003eGmail\u003c\/strong\u003e to the building owner including the \u003cstrong\u003e24-hour AHJ filing deadline\u003c\/strong\u003e.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eStandard violations:\u003c\/strong\u003e sends a corrective work-order alert via \u003cstrong\u003eTelegram\u003c\/strong\u003e.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eRepeat standard violations:\u003c\/strong\u003e additionally emails the local fire marshal\/AHJ contact via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAudits every branch\u003c\/strong\u003e by appending a single outcome row to the \u003cstrong\u003eGoogle Sheets “AHJ Compliance Log.”\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eProperty managers who receive deficiency emails and need \u003cem\u003eimmediate\u003c\/em\u003e escalation for life-safety issues.\u003c\/li\u003e\n  \u003cli\u003eFacilities teams that want Telegram alerts for standard corrective work orders.\u003c\/li\u003e\n  \u003cli\u003eAHJ resubmission tracking workflows requiring a consistent compliance log.\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, set, code, gmail, merge, telegram\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Gmail OAuth2, OpenAI API credential for severity classification, Telegram Bot API credential, and Google Sheets logging.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45949979820211,"sku":"N8N-19181","price":3.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/M9Uz84QwnkbMXaQp0Zgkp_quSsv69t.png?v=1788512692","url":"https:\/\/buyflowscripts.com\/products\/n8n-gmail-fire-sprinkler-deficiency-router-with-openai-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}