{"product_id":"jma-weather-delay-triage-n8n-workflow-teams-gmail-alerts","title":"JMA Weather Delay Triage n8n Workflow: Teams \u0026 Gmail Alerts","description":"\u003ch3\u003eJMA Weather Delay Triage: Automated Teams + Gmail Alerts for n8n\u003c\/h3\u003e\n\u003cp\u003eStay ahead of Japan Meteorological Agency (JMA) weather warnings with an n8n workflow that checks the JMA XML feed every 30 minutes, detects changes per prefecture, and routes alerts for approval—then emails affected customers via Gmail. It also tracks shipment and warning state using n8n Data Tables.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns every 30 minutes\u003c\/strong\u003e to load workflow settings plus saved \u003cem\u003ewarning state\u003c\/em\u003e and \u003cem\u003eopen shipments\u003c\/em\u003e from n8n Data Tables.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDownloads the public JMA XML warning feed\u003c\/strong\u003e, posting an error card to \u003cstrong\u003eMicrosoft Teams\u003c\/strong\u003e if the request fails.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses and filters alerts\u003c\/strong\u003e for your watched prefectures, keeping the newest entry per prefecture.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches each entry’s detail XML\u003c\/strong\u003e to extract active warning types and the headline.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompares current vs. previously saved warnings\u003c\/strong\u003e per prefecture to route only \u003cem\u003enewly issued\/changed\u003c\/em\u003e warnings and \u003cem\u003eall-clear\u003c\/em\u003e events, then upserts the latest state back to the warning state table.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMatches warnings to pending shipments\u003c\/strong\u003e: for newly issued warnings, it checks the affected prefecture (and the warehouse prefecture) against open shipments due within the lookahead window.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDrafts messages with OpenAI\u003c\/strong\u003e (a Japanese internal alert and a polite customer email template with placeholders).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts to Microsoft Teams\u003c\/strong\u003e and—when shipments are impacted—creates a Teams card with a \u003cstrong\u003e“Review and send”\u003c\/strong\u003e link to an \u003cstrong\u003en8n approval form\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWaits for staff approval or skip\u003c\/strong\u003e and then sends customer emails via \u003cstrong\u003eGmail\u003c\/strong\u003e, while maintaining tracking of shipment and warning state.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eProactively notifying ops teams when JMA warnings change by prefecture.\u003c\/li\u003e\n  \u003cli\u003eApproving customer communications only when shipments are actually affected.\u003c\/li\u003e\n  \u003cli\u003eReducing manual triage during severe weather events with consistent templates and state tracking.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduler:\u003c\/strong\u003e runs every 30 minutes\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/logic:\u003c\/strong\u003e if, set, xml, code, sort, wait\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Microsoft Teams (alerts + approval link), Gmail (customer emails), OpenAI (drafting)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eState management:\u003c\/strong\u003e n8n Data Tables (warning state + open shipments)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46288984375475,"sku":"N8N-21713","price":32.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/o5TyZZ8-pgXgMzbiTVw-1_xw43ubTA.png?v=1793005375","url":"https:\/\/buyflowscripts.com\/products\/jma-weather-delay-triage-n8n-workflow-teams-gmail-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}