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:#EAF2F9,stroke:#2F6FA8,color:#241A12,stroke-width:1.5px
        classDef p2 fill:#ECE6FB,stroke:#7C3AED,color:#241A12,stroke-width:1.5px
        classDef p3 fill:#E4F1EE,stroke:#0E7C6E,color:#241A12,stroke-width:1.5px
        classDef p4 fill:#E9E7FB,stroke:#4F46E5,color:#241A12,stroke-width:1.5px
        classDef p5 fill:#FAF0DC,stroke:#A5650A,color:#241A12,stroke-width:1.5px
        classDef p6 fill:#FBEBEA,stroke:#C23A30,color:#241A12,stroke-width:1.5px
        classDef start fill:#E4F1EE,stroke:#0E7C6E,color:#241A12,stroke-width:1.5px
        classDef done fill:#D9F3EC,stroke:#0E7C6E,color:#241A12,stroke-width:2.5px

        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:#E9E7FB,stroke:#4F46E5,color:#241A12,stroke-width:1.5px
        classDef mod fill:#ECE6FB,stroke:#7C3AED,color:#241A12,stroke-width:1.5px
        class S1,S2,S3,S4,S5,S6,S7,S8 state
        class FM2,WA2,DP2,GD2,HU2 mod