Skill

Pi Diagnostics (Google Sheets)

Manages Pi hardware health, cron job health, OpenClaw job status, and OpenClaw config snapshots in a single Google Sheet with four tabs:

Diagnostics Sheet: https://docs.google.com/spreadsheets/d/1xIMil5RtrnrHwRORIaV9wMJQPsvXDlDdyfVBiNmhBhI/edit

Sheet Structure

Tab 1: Pi Health

Columns: Timestamp, CPU Temp (°C), GPU Temp (°C), CPU Load (1m), CPU Load (5m), CPU Load (15m), RAM Used (MB), RAM Total (MB), Disk Used (GB), Disk Total (GB), Uptime (days)

Tab 2: Cron Health

Columns: Timestamp, Script, Exit Code, Duration (s), Notes

Populated automatically by the exit trap in each bin script via kip-cron-log.sh.

Tab 3: OpenClaw Jobs

Columns: Timestamp, Job Name, Status, Duration (s), Consecutive Errors, Error Reason, Notes

Populated by openclaw-jobs-snapshot.sh (daily snapshot of ~/.openclaw/cron/jobs-state.json).

Tab 4: OpenClaw Config

Columns: Timestamp, Version, Primary Model, Agent Runtime, Memory Search Provider, Memory Search Model, Skills Count, Gateway Mode, Notes

Populated by openclaw-config-snapshot.sh (daily snapshot of openclaw.json + update-check.json).

Collection Scripts

Script	Frequency	Logs to
`system-pi-health-report.sh`	Every 6 hours	Pi Health tab + `kip-claw/src/lib/piHealth.json`
`openclaw-jobs-snapshot.sh`	Daily at 4:00am	OpenClaw Jobs tab + `kip-claw/src/lib/openclawJobs.json`
`openclaw-config-snapshot.sh`	Daily at 4:15am	OpenClaw Config tab + `kip-claw/src/lib/openclawConfig.json`
`kip-cron-log.sh`	On every bin script exit	Cron Health tab

Google Workspace MCP

For interactive diagnostics, use the Google Workspace MCP for spreadsheet 1xIMil5RtrnrHwRORIaV9wMJQPsvXDlDdyfVBiNmhBhI. Always pass user_google_email: "kip@palewi.re"; do not use gog. Read the applicable Pi Health, Cron Health, OpenClaw Jobs, or OpenClaw Config range with read_sheet_values.

Manually trigger a Pi health snapshot

bash {{HOME}}/bin/system-pi-health-report.sh

Manually trigger an OpenClaw jobs snapshot

bash {{HOME}}/bin/openclaw-jobs-snapshot.sh

Manually trigger an OpenClaw config snapshot

bash {{HOME}}/bin/openclaw-config-snapshot.sh

Notes

Sheet ID: 1xIMil5RtrnrHwRORIaV9wMJQPsvXDlDdyfVBiNmhBhI
Tabs: Pi Health, Cron Health, OpenClaw Jobs, OpenClaw Config
Requires Google Workspace MCP Sheets access for interactive queries. Existing unattended collection scripts retain their independent gog implementation because MCP tools require an authenticated agent session.
kip-claw JSON mirrors: src/lib/piHealth.json, src/lib/openclawJobs.json, src/lib/openclawConfig.json
GPU temp requires vcgencmd (available on Raspberry Pi OS); will be empty on non-Pi hardware
Cron Health rows are appended by kip-cron-log.sh, which is called via exit traps in: kip-backup, kip-batocera-backup, kip-speedtest, kip-pi-health, kip-openclaw-jobs, kip-openclaw-config