{"product_id":"n8n-weather-risk-alerts-for-airtable-outdoor-bookings-slack","title":"n8n Weather Risk Alerts for Airtable Outdoor Bookings + Slack","description":"\u003ch3\u003eProtect outdoor bookings with automated weather risk alerts (Airtable + Slack + WhatsApp)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow checks your upcoming \u003cstrong\u003econfirmed outdoor bookings in Airtable\u003c\/strong\u003e, pulls location-specific forecasts from \u003cstrong\u003eOpen-Meteo\u003c\/strong\u003e, calculates a weather risk level, and then sends \u003cstrong\u003eSlack\u003c\/strong\u003e alerts (and \u003cstrong\u003eWhatsApp\u003c\/strong\u003e customer messages for severe risk) while updating the booking record to prevent repeat notifications.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily on a schedule\u003c\/strong\u003e to keep risk coverage up to date.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearches Airtable\u003c\/strong\u003e for bookings that are confirmed, marked as \u003cem\u003eoutdoor\u003c\/em\u003e, and fall within your configured \u003cstrong\u003elookahead window\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGeocodes each booking location\u003c\/strong\u003e using Open-Meteo Geocoding.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches a date-specific forecast\u003c\/strong\u003e from the Open-Meteo Forecast API.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates risk level\u003c\/strong\u003e (none, moderate, severe) based on configured thresholds using:\n    \u003cul\u003e\n      \u003cli\u003erain probability\u003c\/li\u003e\n      \u003cli\u003eexpected precipitation\u003c\/li\u003e\n      \u003cli\u003emaximum wind speed\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003eIf risk is \u003cstrong\u003emoderate\u003c\/strong\u003e: posts an \u003cstrong\u003einternal Slack alert\u003c\/strong\u003e and updates the booking’s \u003cstrong\u003erisk_level\u003c\/strong\u003e in Airtable.\u003c\/li\u003e\n  \u003cli\u003eIf risk is \u003cstrong\u003esevere\u003c\/strong\u003e and the customer hasn’t been notified yet:\n    \u003cul\u003e\n      \u003cli\u003esends a \u003cstrong\u003eWhatsApp\u003c\/strong\u003e message to the customer\u003c\/li\u003e\n      \u003cli\u003eposts a Slack alert to the owner\u003c\/li\u003e\n      \u003cli\u003esets \u003cstrong\u003ecustomer_notified\u003c\/strong\u003e and marks the record as \u003cstrong\u003esevere\u003c\/strong\u003e in Airtable\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003eIf risk is \u003cstrong\u003esevere\u003c\/strong\u003e and the customer was already notified: posts a “still severe” update to Slack and updates \u003cstrong\u003erisk_level\u003c\/strong\u003e without messaging the customer again.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eOutdoor tours, events, or rentals that need proactive weather warnings for guests.\u003c\/li\u003e\n  \u003cli\u003eOps teams managing multiple locations who want automated, record-based escalation in Airtable.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators using n8n to reduce no-shows by notifying customers only when conditions are severe.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow nodes:\u003c\/strong\u003e if, set, code, Slack, Airtable, WhatsApp.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAPIs:\u003c\/strong\u003e Open-Meteo Geocoding and Open-Meteo Forecast.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAirtable fields\u003c\/strong\u003e expected: customer_name, customer_number, location, booking_date, is_outdoor, status, customer_notified, risk_level.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46008777048243,"sku":"N8N-19492","price":41.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/PgG3OKnm3Zet70fFHm-aL_mZBjdKM0.png?v=1789204342","url":"https:\/\/buyflowscripts.com\/products\/n8n-weather-risk-alerts-for-airtable-outdoor-bookings-slack","provider":"N8N Commerce","version":"1.0","type":"link"}