Live airport delay dashboard with FlightStats, Google Sheets & Slack alerts
Needs changesWhat this workflow does
This workflow has 6 nodes and runs on a schedule (legacy Cron node). Along the way it connects Google Sheets and Slack. It also calls api.flightstats.com over HTTP.
How it runs
Trigger: On a schedule (legacy Cron node).
- FlightStats API (HTTP Request): calls api.flightstats.com
- Set Output Data (Google Sheets): append
- Merge API Data (If): checks a condition and branches into true / false
- Send Response via Slack (Slack): uses Slack
Services it uses
HTTP calls to: api.flightstats.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Cron in Set Schedule: replace with Schedule Trigger.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Cron Set Schedule | Schedule Trigger |
Nodes used (6)
- Cron
n8n-nodes-base.cron - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack - No Operation, do nothing
n8n-nodes-base.noOp
From the author
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…