# Scripts Audit Report - March 9, 2026

## Summary: MASSIVE DUPLICATION FOUND 🚨

**TOTAL FILES:** 620+ scripts across organized directories
**KEY ISSUES:**
- 🔴 **Heavy versioning** - Multiple v2, v3, v4, final versions
- 🔴 **Cross-directory duplicates** - Same files in multiple dirs
- 🟡 **No virtual environments** - Python scripts use system packages
- 🟡 **Unclear dependencies** - No requirements.txt files

---

## Directory Breakdown

### ✅ CORE/ (9 files) - CLEAN
- **Status:** Well-organized, no version conflicts
- **Files:** heartbeat, compaction, memory management
- **Dependencies:** Google APIs (system-wide)
- **Action:** None needed

### 🟡 EMAIL/ (20 files) - MODERATE ISSUES  
- **Version conflicts:** 5 files
  - `send-yaniv-*` (draft, draft_v2, clean, final) - **4 versions of same script!**
  - `gen-phat-scale-v2.py` vs unknown v1
- **Dependencies:** Google APIs, standard library
- **Action:** Keep latest Yaniv script, archive others

### 🔴 FIGMA/ (45 files) - HEAVY VERSIONING
- **Version conflicts:** 13+ files
  - `figma-test-props`, `figma-test-props2`, `figma-test-set-props`
  - `figma-market-gap-v2.cjs` 
  - `fix_presentation_v3.py`, `jessica-fix-slides.py`
- **Dependencies:** Figma API, Node.js modules
- **Action:** Major cleanup needed

### 🔴 IMAGES/ (27 files) - MULTIPLE VERSIONS
- **Version conflicts:** 6 files
  - `gen-bug-hunt-final.py` vs `gen-bug-hunt-v4.py`
  - `gen-catch-final.py` vs `gen-catch-v3.py`
- **Dependencies:** PIL/Pillow, requests, OpenAI
- **Action:** Keep final versions only

### 🚨 UTILS/ (210 files) - DISASTER ZONE
- **Version conflicts:** 50+ files minimum
  - `blur_clients` (v2, v3, v4, v5, v6, v7, v8, final)
  - `add-type-bughunt` (v2, v3, v4, v5)
  - `add-v2-pillars.cjs` vs `add-v3-pillars.cjs`
- **Dependencies:** Everything - needs audit
- **Action:** MAJOR deduplication needed

### 🔴 LEGACY/ (34 files) - VERSIONING MESS
- **Version conflicts:** 23 out of 34 files are versions
- **Status:** Should be archived/cleaned
- **Action:** Keep one version each, delete rest

### 🟢 NOTION/ (6 files) - ACCEPTABLE
- **Dependencies:** requests, Notion API
- **Action:** Minor cleanup

### 🟢 TASTE/ (9 files) - CLEAN
- **Status:** Well-organized pipeline
- **Action:** None needed

## Cross-Directory Duplicates Found

**EXACT SAME FILES in multiple directories:**
- `auto-compact-sessions.py` (core/ + utils/)
- `blur_clients*.py` (legacy/ + utils/ + multiple versions)
- `add-type-bughunt*.py` (legacy/ + utils/ + versions)
- `figma-*` scripts (figma/ + utils/)

## Virtual Environment Analysis

### ❌ MISSING: No venvs found in any script directory
### ❌ MISSING: No requirements.txt files
### ✅ SYSTEM PACKAGES: Most dependencies available system-wide
- `google-*` packages ✅
- `requests` ✅  
- `PIL/Pillow` ✅
- `playwright` ✅

**RECOMMENDATION:** Add requirements.txt files for complex scripts but system packages seem sufficient for now.

## Python Dependencies Snapshot
- **Google APIs:** gmail, calendar, docs, sheets
- **Image processing:** PIL, playwright, imagemagick
- **Web:** requests, beautifulsoup
- **AI:** openai, anthropic (via env vars)

## Cleanup Priority

### 🚨 IMMEDIATE (Critical)
1. **UTILS/** - 210 → ~50 files (remove duplicates/versions)
2. **Cross-directory duplicates** - Pick canonical location

### 🔴 HIGH 
1. **FIGMA/** - Consolidate test scripts, keep latest versions
2. **LEGACY/** - Archive old versions properly  
3. **EMAIL/** - Keep latest Yaniv script only

### 🟡 MEDIUM
1. **IMAGES/** - Keep final versions, remove intermediates
2. Add requirements.txt where needed

### 🟢 LOW
1. **CORE/**, **TASTE/**, **NOTION/** - Already clean

---

## RECOMMENDED ACTIONS

1. **UTILS Deduplication** - Reduce 210 → ~50 files
2. **Version Consolidation** - Keep latest only, archive rest  
3. **Cross-directory cleanup** - One canonical location per script
4. **Requirements documentation** - Add requirements.txt files
5. **README files** - Document each directory's purpose

**ESTIMATED CLEANUP:** ~150-200 files can be safely removed/archived