kip-claw 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
gogimplementation 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