{"product_id":"n8n-weather-alerts-workflow-for-hospitable-guests-weatherapi-data-table","title":"n8n Weather Alerts Workflow for Hospitable Guests (WeatherAPI + Data Table)","description":"\u003ch3\u003eKeep your Hospitable guests informed—automatically—when rain or strong winds are coming.\u003c\/h3\u003e\n\u003cp\u003eThis n8n Weather Alerts Workflow checks \u003cstrong\u003eWeatherAPI.com\u003c\/strong\u003e every day for the next 24 hours at your Hospitable property location, and proactively messages the most relevant guest through the \u003cstrong\u003eHospitable\u003c\/strong\u003e Public API when severe conditions are expected—while preventing repeat sends with an \u003cstrong\u003en8n Data Table\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 daily at 17:00\u003c\/strong\u003e using a schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches a 2-day hourly forecast\u003c\/strong\u003e from WeatherAPI.com, then evaluates whether \u003cstrong\u003erain and\/or strong wind thresholds\u003c\/strong\u003e are met within the next 24 hours.\u003c\/li\u003e\n  \u003cli\u003eIf severe weather is expected, it queries the \u003cstrong\u003eHospitable Public API\u003c\/strong\u003e for upcoming and in-progress reservations and selects \u003cstrong\u003ethe single eligible in-house or arriving-today guest\u003c\/strong\u003e (or flags the situation as \u003cstrong\u003eambiguous\/unsendable\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003eUses an \u003cstrong\u003en8n Data Table\u003c\/strong\u003e to enforce a \u003cstrong\u003e48-hour no-repeat rule\u003c\/strong\u003e, then generates a guest-ready message with a \u003cstrong\u003enatural time phrase\u003c\/strong\u003e (e.g., “tonight” or “tomorrow morning”).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIn LIVE mode\u003c\/strong\u003e, it claims a log row, posts to the reservation conversation via the Hospitable API, and records whether the send was \u003cstrong\u003econfirmed\u003c\/strong\u003e, \u003cstrong\u003efailed\u003c\/strong\u003e, or \u003cstrong\u003eunknown\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmails the host via SMTP\u003c\/strong\u003e in \u003cstrong\u003eDRY_RUN\u003c\/strong\u003e mode and whenever the workflow cannot send safely (e.g., no conversation available, overlapping stays, table claim failure, or an unconfirmed send).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSend timely guidance before a \u003cstrong\u003erainfront\u003c\/strong\u003e impacts check-in or daily comfort.\u003c\/li\u003e\n  \u003cli\u003eNotify guests about \u003cstrong\u003estrong wind forecasts\u003c\/strong\u003e that may affect outdoor plans.\u003c\/li\u003e\n  \u003cli\u003eReduce support tickets by communicating weather expectations automatically with \u003cstrong\u003econtrolled repeat logic\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eEscalate to the host via email when messaging cannot be completed reliably.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeatherAPI.com\u003c\/strong\u003e: HTTP Query Auth using the \u003ccode\u003ekey\u003c\/code\u003e parameter.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHospitable\u003c\/strong\u003e: HTTP Bearer token via the Hospitable Public API.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSMTP\u003c\/strong\u003e: host notification emails when LIVE sending isn’t safe or confirmed.\u003c\/li\u003e\n  \u003cli\u003eWorkflow nodes\/logic: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003edata table\u003c\/strong\u003e, \u003cstrong\u003ehttp request\u003c\/strong\u003e, \u003cstrong\u003eemail send\u003c\/strong\u003e, and a \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup\u003c\/h3\u003e\n\u003cp\u003eCreate credentials for \u003cstrong\u003eWeatherAPI.com\u003c\/strong\u003e, \u003cstrong\u003eHospitable\u003c\/strong\u003e, and \u003cstrong\u003eSMTP\u003c\/strong\u003e, then deploy the workflow. In LIVE mode it sends; in DRY_RUN it emails the host for review.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46217931456691,"sku":"N8N-20800","price":4.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/7C23CaUSzMog7eyMi1PKG_i5vm3uxI.png?v=1791883810","url":"https:\/\/buyflowscripts.com\/products\/n8n-weather-alerts-workflow-for-hospitable-guests-weatherapi-data-table","provider":"N8N Commerce","version":"1.0","type":"link"}