# 🛠️ APPS SCRIPT TOOLBOX

**Master Bridge Connection Center**
Links CITADEL workers to Google Sheets for automated inventory reporting

---

## 📡 OVERVIEW

The Apps Script Toolbox serves as the bridge between:
- **Local Workers** (citadel_reporter.py, citadel_archivist.py)
- **Google Sheets** (automated audit reports)
- **321GB Data Empire** (S10, Oppo, Laptop, GDrive)

---

## 🚀 QUICK START

### Prerequisites

Ensure the following secrets are configured:
- `GOOGLE_SHEETS_CREDENTIALS` - Service account JSON credentials
- `RCLONE_CONFIG_DATA` - Rclone configuration for GDrive access
- `HF_TOKEN` - HuggingFace API token

### Basic Commands

```bash
# Verify all connections are working
python workers/apps_script_toolbox.py --verify

# Generate Identity Strike Report (Section 44 Audit)
python workers/apps_script_toolbox.py --identity-strike

# Run full archive audit and push to Google Sheets
python workers/apps_script_toolbox.py --full-audit

# Update worker status dashboard
python workers/apps_script_toolbox.py --worker-status
```

---

## 📊 FEATURES

### 1. Identity Strike Report (`--identity-strike`)
Generates Section 44 audit report showing all files from connected systems.

### 2. Full Archive Audit (`--full-audit`)
Comprehensive archive processing with MD5 hash computation and Google Sheets export.

### 3. Worker Status Dashboard (`--worker-status`)
Updates Google Sheets dashboard with sync times, health status, and error logs.

### 4. Connection Verification (`--verify`)
Validates all connections: Google Sheets API, Rclone, HF token, worker files.

---

## ⚙️ Workers

### Worker Watchdog (`worker_watchdog.py`)
Continuous monitoring and auto-healing for scripts and workers.

```bash
# Run once
python workers/worker_watchdog.py --once

# Run continuous monitoring (every 5 minutes)
python workers/worker_watchdog.py --interval 300
```

### Self-Healing Worker (`self_healing_worker.py`)
Autonomous script repair system with syntax checking and auto-fix.

```bash
# Full heal (scan + repair)
python workers/self_healing_worker.py

# Scan only
python workers/self_healing_worker.py --no-repair
```

---

*TIA-ARCHITECT-CORE v25.0.OMNI++ | Citadel Mesh Coordination System*