Morning team travel briefing with live flight alerts
Every weekday morning, your team gets one Slack briefing on who's flying today, their live flight status, and any delays or cancellations to act on.
AviationStack
Google Sheets
SlackOperationsDaily DigestsNotifications & AlertsEvery weekday at 7am, post a single morning travel briefing to our Slack channel covering the team's flights for the day. Skip the post entirely on days when no one on the roster is flying.
Start by reading our team travel roster from a Google Sheet with the Get Values operation. Each row holds a traveler's name, their flight number or IATA flight code, and the travel date. Keep only the rows where the travel date is today, and ignore everyone else.
For each flight departing today, look up its live status with AviationStack's Get Flights (real-time) operation, matching on the flight number or IATA flight code. Capture the current flight status, the scheduled versus estimated departure and arrival times, and the departure terminal and gate.
Then post one briefing to Slack with the Send a Message operation. Group the summary by traveler so each person's flight is clear: who is flying, scheduled versus estimated departure and arrival times, and terminal and gate. Lead with anything that needs attention, and clearly flag any flight that is delayed, diverted, or cancelled, so the team can react before people leave for the airport.
Keep the roster modest and the schedule to once each morning. AviationStack's real-time flight data is available on all plans but updates on a 30 to 60 second delay, and the free plan is limited to roughly 100 requests per month. If no flights are departing today, do not post anything at all.
What does this prompt do?
- Reads your team travel roster from a Google Sheet each weekday morning and picks out only the flights departing that day.
- Checks the live status of every flight, including scheduled versus estimated departure and arrival times, terminal, and gate.
- Posts a single briefing to your Slack channel, grouped by traveler, with delays, diversions, and cancellations flagged at the top.
- Stays quiet on days when no one is traveling, so the channel only lights up when it matters.
What do I need to use this?
- A Google Sheet listing each traveler, their flight number, and their travel date.
- An AviationStack account for live flight data.
- A Slack workspace and the channel where the morning briefing should post.
How can I customize it?
- Change the send time or the days it runs, such as a 6am send or including weekends.
- Point it at a different Slack channel, or send to more than one team.
- Adjust what counts as needing attention, for example flagging any delay over 15 minutes.
FAQs
What do I need in my travel spreadsheet?
What happens on days when nobody is flying?
Will it warn us about delays and cancellations?
Does this work with the free AviationStack plan?
Can I change what time it runs?
Related templates
Every weekday at 10am, an AI voice agent phones your most overdue Xero accounts, logs what each customer promised, and reports back to finance in Slack.
See every Google Maps listing you manage on one screen, ranked worst first, with an audit button that writes the fix list for you.
Every couple of hours we find the chats your team never answered, email those visitors a real reply, and hand the sensitive ones to a support lead.
Your team picks a template, finds the customer, checks they are safe to email, then sends it, with every send logged where the whole team can see it.
Every night at 2am, pull the contacts on your open and won deals and block them from your cold outreach before the next send goes out.
Build every text campaign in one screen: check who is actually reachable, see a realistic send plan, then watch delivery land row by row.
Give your team one calm morning travel briefing.
Stop pinging each other about flight times and delays. Let one Slack post cover who is flying and what needs attention before anyone leaves for the airport.