Live airport delay dashboard with FlightStats, Google Sheets & Slack alerts

Live Airport Delay Dashboard with FlightStats & Team Alerts

Description - Automates live monitoring of airport delays using FlightStats API. - Stores and displays delay data, with Slack alerts for severe delays to operations/sales teams.

Essential Information - Runs on a scheduled trigger (e.g., hourly or daily). - Fetches real-time delay data from FlightStats API. - Stores data in Google Sheets and alerts teams via Slack for severe delays.

System Architecture - Delay Monitoring Pipeline: - Set Schedule: Triggers the workflow hourly or daily via Cron. - FlightStats API: Retrieves live airport delay data. - Data Management Flow: - Set Output Data: Prepares data for storage or display. - Merge API Data: Combines and processes delay data. - Alert and Display: - Send Response via Slack: Alerts ops/sales for severe delays. - No Action for Minor Delays: Skips minor delays with no action.

Implementation Guide - Import the workflow JSON into n8n. - Configure Cron node for desired schedule (e.g., every 1 hr). - Set up FlightStats API credentials and endpoint (e.g., https://api.flightstats.com). - Configure Google Sheets or Notion for data storage/display. - Test with a sample API call and verify Slack alerts. - Adjust delay severity thresholds as needed.

Technical Dependencies - Cron service for scheduling. - FlightStats API for real-time delay data. - Google Sheets API or Notion API for data storage/display. - Slack API for team notifications. - n8n for workflow automation.

Database & Sheet Structure - Delay Tracking Sheet (e.g., AirportDelays): - Columns: airportcode, delaystatus, delayminutes, timestamp, alertsent - Example: JFK, Severe, 120, 2025-07-29T20:28:00Z, Yes

Customization Possibilities - Adjust Cron schedule for different frequencies (e.g., every 30 min). - Modify FlightStats API parameters to track specific airports. - Customize Slack alert messages in the Send Response via Slack node. - Integrate with a dashboard tool (e.g., Google Data Studio) for live display. - Add email alerts for additional notification channels.