L&D Cohort Automation

graph TD
  START["Files dropped in
00_Incoming"] --> FM

  subgraph Phase1["Phase 1 — File Management"]
    FM["Detect file type
recording vs transcript"] --> RN["Rename per convention
LD-C1_W03A_Recording_2026-04-28"]
    RN --> MV["Move to destination
01_Recordings / 02_Transcripts"]
    MV --> SC["Create shortcuts
in 00_SHARED subfolders"]
    SC --> EX["Extract transcript text"]
  end

  EX --> SU

  subgraph Phase2["Phase 2 — Sheet Updates"]
    SU["Find session row
in Schedule Sheet"] --> LK["Write recording &
transcript links"]
    LK --> MS["Mark SOP steps
complete"]
  end

  MS --> HU

  subgraph Phase3["Phase 3 — Hub Doc"]
    HU["Append session entry
to 00_START_HERE"]
  end

  HU --> WA

  subgraph Phase4["Phase 4 — Walter AI Analysis"]
    WA["Send transcript to
Claude or Gemini API"] --> JP["Parse structured
JSON response"]
    JP --> AD["Create formatted
Analysis Doc in Drive"]
  end

  AD --> DP

  subgraph Phase5["Phase 5 — FN Population"]
    DP["Copy FN template"] --> PH["Replace placeholders
with Walter data"]
  end

  PH --> GD

  subgraph Phase6["Phase 6 — Notifications"]
    GD["Create Gmail draft
with links & analysis"]
    GD --> CU["Create ClickUp
review tasks"]
  end

  CU --> DONE["Pipeline Complete"]

  classDef p1 fill:#f472b622,stroke:#f472b6,stroke-width:2px
  classDef p2 fill:#a78bfa22,stroke:#a78bfa,stroke-width:2px
  classDef p3 fill:#34d39922,stroke:#34d399,stroke-width:2px
  classDef p4 fill:#60a5fa22,stroke:#60a5fa,stroke-width:2px
  classDef p5 fill:#fbbf2422,stroke:#fbbf24,stroke-width:2px
  classDef p6 fill:#f8717122,stroke:#f87171,stroke-width:2px
  classDef start fill:#818cf822,stroke:#818cf8,stroke-width:2px
  classDef done fill:#34d39944,stroke:#34d399,stroke-width:3px

  class START start
  class FM,RN,MV,SC,EX p1
  class SU,LK,MS p2
  class HU p3
  class WA,JP,AD p4
  class DP,PH p5
  class GD,CU p6
  class DONE done
  

graph LR
  subgraph State["PIPELINE_W03A
Script Properties"]
    S1["transcriptText"]
    S2["recordingUrl"]
    S3["transcriptUrl"]
    S4["walterJson"]
    S5["analysisUrl"]
    S6["fnDocUrl"]
    S7["synopsis"]
    S8["draftId"]
  end

  FM2["FileManager"] -->|"writes"| S1
  FM2 -->|"writes"| S2
  FM2 -->|"writes"| S3
  WA2["WalterApi"] -->|"reads"| S1
  WA2 -->|"writes"| S4
  WA2 -->|"writes"| S5
  WA2 -->|"writes"| S7
  DP2["DocPopulator"] -->|"reads"| S4
  DP2 -->|"writes"| S6
  GD2["GmailDrafter"] -->|"reads"| S4
  GD2 -->|"reads"| S2
  GD2 -->|"reads"| S3
  GD2 -->|"reads"| S6
  GD2 -->|"writes"| S8
  HU2["HubUpdater"] -->|"reads"| S2
  HU2 -->|"reads"| S3
  HU2 -->|"reads"| S7

  classDef state fill:#60a5fa22,stroke:#60a5fa,stroke-width:2px
  classDef mod fill:#a78bfa22,stroke:#a78bfa,stroke-width:2px
  class S1,S2,S3,S4,S5,S6,S7,S8 state
  class FM2,WA2,DP2,GD2,HU2 mod