Skip to content

2026-08-30 — Session Log (raw)

Google Sheets Connector (Budget)

Set up Hal ↔ Budget Google Sheet integration via scoped service account.

  • Project universal-talon-454006-c6, Sheets API enabled.
  • Service account: sheet-connector@universal-talon-454006-c6.iam.gserviceaccount.com
  • Key at ~/.config/gdrive/service-account.json (600). Venv ~/.venv-sheets.
  • Budget sheet ID 1C6BTvRvouxy7MdpeK9KkeKHJ_TH-KJm2c5wS_5mC6SQ — 13 tabs (2016–2027).
  • Verified working, Editor, scoped to only this sheet.

Budget model

  • Weekly-column cashflow ledger, monthly salary Dean ~5500, rows = categories.
  • Use: what-if cashflow ("spend £200 now → ripple through months").

2028 sheet plan (future)

  • Carryover opens from end of 2027 sheet. Clone structure, formula-driven carryover.
  • Trigger: "create a 2028 sheet".

Other

  • Security audit — closed Canva editor server (port 8790): rebound *→127.0.0.1; LAN refused. UFW enforcement still TBD.
  • Slow-boot = one-off Dell memory re-training (68.9s silent kernel vs 4.7s normal); next boot 28s, fine.
  • Researched Nelson MCP (moot), 5 MCP servers (FastAPI-MCP standout, not needed).

Wiki

  • New: wiki/Google Sheets Connector.md, wiki/sessions/2026-08-30.md. Index updated.
  • Memory MCP: added google_sheets_connector, budget_spreadsheet, budget_2028_sheet_plan + relations.