| # π οΈ 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* |
| |