Monitor public transit delays and alert your team in Teams

The system checks transit schedules against real departures and posts an alert when there's a delay.

How the work actually flows

A straight line. Runs once per each route and stop.

Pattern: Sequence (1) ยท Multiple Instances with a priori Design-Time Knowledge (13)

flowchart TD trig(["scheduled route check"]):::trigtime s0[["check routes and stops list"]]:::mi s1["look up actual departures"]:::svc s2["compare to published schedule"]:::task s3["post delay alert in teams"]:::svc s4[("log delay for reporting")]:::store trig --> s0 s0 --> s1 s1 --> s2 s2 --> s3 s3 --> s4 out[/"teams alert and logged delay history"/]:::out pay{{"catches delays before they matter"}}:::pay s4 --> out out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
Starts itA stepAn outside serviceRuns once per itemA record or sheetResultPayoff
Build size
Advanced

A larger build with multiple systems, AI reasoning, and custom rules.

Business functions
Spreadsheet & Database Ops
Connects
Microsoft TeamsSupabase

The problem it solves

Keeping track of whether buses or trains are running on time means checking a transit site over and over, which nobody has time to do all day. By the time you notice a delay yourself, you've already missed the chance to reroute or warn the people relying on that schedule.

Who it fits

Commuter coordinators, logistics teams, or travel desks that track transit routes for others.

How it works

  1. The system checks a list of routes and stops on a set schedule
  2. It looks up the actual departure times for each one
  3. It compares actual times against the published schedule
  4. If a delay is bigger than your threshold, it posts an alert in Microsoft Teams
  5. The delay is logged for later reporting
What you get

Delays you hear about before your team does

You find out about transit delays on your routes as soon as they happen, so your team can adjust plans right away.

What you get

Real-time Teams alerts for delays plus a historical log of delay data.

What you need

A Microsoft Teams workspace, a Supabase account, and a web scraping service.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Turn your FAQ articles into audio playable on your support site

Converts written FAQ answers into natural-sounding audio and adds a play button to your support pages automatically.

Standard

Get alerted in Microsoft Teams when a site goes offline

Checks your Unifi network sites on a schedule and posts a Microsoft Teams alert the moment one drops offline.

Standard

Manage reservations and answer customer questions with AI chat

Answers customer questions and creates, updates, or cancels reservations automatically through chat, day or night.

Advanced

Auto-generate FAQ answers with AI and store them in a database

It uses AI to write clear FAQ answers for any topic and saves them for your website or support team.

Standard
Back to the AI Playbook