Automated Airport Delay Monitoring and Alerts

This n8n workflow automates the monitoring of airport delays by integrating with the FlightStats API and keeping team members informed through Google Sheets and Slack alerts. The process begins with a scheduled trigger that runs hourly, fetching real-time delay data for a specified airport such as JFK. The delay information, including delay minutes and airport code, is stored in a Google Sheet for ongoing visibility. The workflow then evaluates whether the delay exceeds 30 minutes, signaling a severe delay. If so, it sends an instant Slack alert to the ‘ops-sales’ channel with detailed delay information. For delays under 30 minutes, no alert is triggered, ensuring only significant delays generate immediate team notifications. This setup is ideal for airport operations teams or travel agencies aiming to stay updated on flight delays and promptly communicate issues to relevant teams.