n8n Weather Risk Alerts for Airtable Outdoor Bookings + Slack

Protect outdoor bookings with automated weather risk alerts (Airtable + Slack + WhatsApp)

This n8n workflow checks your upcoming confirmed outdoor bookings in Airtable, pulls location-specific forecasts from Open-Meteo, calculates a weather risk level, and then sends Slack alerts (and WhatsApp customer messages for severe risk) while updating the booking record to prevent repeat notifications.

What this workflow does

• Runs daily on a schedule to keep risk coverage up to date.
• Searches Airtable for bookings that are confirmed, marked as outdoor, and fall within your configured lookahead window.
• Geocodes each booking location using Open-Meteo Geocoding.
• Fetches a date-specific forecast from the Open-Meteo Forecast API.
• Calculates risk level (none, moderate, severe) based on configured thresholds using:
  • rain probability
  • expected precipitation
  • maximum wind speed
• If risk is moderate: posts an internal Slack alert and updates the booking’s risk_level in Airtable.
• If risk is severe and the customer hasn’t been notified yet:
  • sends a WhatsApp message to the customer
  • posts a Slack alert to the owner
  • sets customer_notified and marks the record as severe in Airtable
• If risk is severe and the customer was already notified: posts a “still severe” update to Slack and updates risk_level without messaging the customer again.

Use cases

• Outdoor tours, events, or rentals that need proactive weather warnings for guests.
• Ops teams managing multiple locations who want automated, record-based escalation in Airtable.
• SaaS operators using n8n to reduce no-shows by notifying customers only when conditions are severe.

Technical details

• n8n workflow nodes: if, set, code, Slack, Airtable, WhatsApp.
• APIs: Open-Meteo Geocoding and Open-Meteo Forecast.
• Airtable fields expected: customer_name, customer_number, location, booking_date, is_outdoor, status, customer_notified, risk_level.