{"product_id":"n8n-museum-microclimate-excursion-alerts-openai-jira-slack","title":"n8n Museum Microclimate Excursion Alerts (OpenAI, Jira, Slack)","description":"\u003ch3\u003eKeep your museum environment in check—automated microclimate excursion alerts every 30 minutes\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors museum microclimate sensors, detects meaningful temperature and relative-humidity excursions against prior readings stored in Postgres, and—when risk is detected—uses OpenAI to produce a structured conservation-risk assessment. It then creates a Jira task, posts a Slack alert, and archives JSON evidence to Google Drive.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003eRuns on a 30-minute schedule\u003c\/strong\u003e to sweep configured museum zones and fetch current sensor readings via a vendor HTTP API.\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003eLoads prior state from Postgres\u003c\/strong\u003e for the same zones, then computes \u003cstrong\u003eper-zone deltas\u003c\/strong\u003e for temperature and relative humidity.\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003eFilters for meaningful excursions\u003c\/strong\u003e using your configured RH and temperature change thresholds (only readings that exceed limits proceed).\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003eFor each changed reading, calls \u003cstrong\u003eOpenAI (Chat model via the “Information Extractor”)\u003c\/strong\u003e to extract a \u003cstrong\u003estructured conservation-risk assessment\u003c\/strong\u003e including evidence and a recommended response window.\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003eCalculates a severity score\u003c\/strong\u003e from the AI risk output and measured deltas, assigning a route: \u003cstrong\u003ewatch, urgent, or critical\u003c\/strong\u003e.\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003eDepending on route, \u003cstrong\u003ecreates a Jira issue\u003c\/strong\u003e, \u003cstrong\u003eposts to Slack\u003c\/strong\u003e, and\/or \u003cstrong\u003euploads a JSON evidence file to Google Drive\u003c\/strong\u003e.\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003eWrites a fresh snapshot back to Postgres\u003c\/strong\u003e to maintain an auditable record for the next run.\u003c\/p\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\u003cp\u003eAutomatic conservation triage when museum temperature\/RH drifts beyond acceptable thresholds.\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003eAuditable incident reporting with Google Drive JSON evidence and a persistent Postgres snapshot history.\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003eOperational visibility for facilities or collections teams via Slack, plus Jira tickets for tracked follow-up.\u003c\/p\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003eIntegrations \/ credentials:\u003c\/strong\u003e Sensor vendor HTTP API, \u003cstrong\u003ePostgres\u003c\/strong\u003e, \u003cstrong\u003eOpenAI\u003c\/strong\u003e, \u003cstrong\u003eJira\u003c\/strong\u003e, \u003cstrong\u003eSlack\u003c\/strong\u003e, \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e.\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003en8n nodes used (as listed):\u003c\/strong\u003e if, set, code, jira, merge, slack.\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003eBuilt for n8n automation engineers and SaaS operators who need reliable, threshold-based microclimate excursion detection with AI-assisted risk extraction.\u003c\/p\u003e\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45967492612275,"sku":"N8N-19274","price":29.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/lfVIA4zZHBsmb9vxETPfU_NfSI7th7.png?v=1788685470","url":"https:\/\/buyflowscripts.com\/products\/n8n-museum-microclimate-excursion-alerts-openai-jira-slack","provider":"N8N Commerce","version":"1.0","type":"link"}