Files
openclaw/skills/home-projects
Clawd Bot ca9b510922 chore: align with upstream openclaw/openclaw and overlay local additions
- Reset master to upstream/main (16,697 commits)
- Overlay 2,271 local-only files (skills, tools, workspace, configs, apps)
- Restore IDENTITY.md and USER.md templates
- Build verified, gateway running, Discord working

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-03-03 07:40:46 +01:00
..

Home Projects Skill

Management af husforbedringsprojekter via Google Sheets.

Installation

# Skill er allerede i /home/alex/clawd/skills/home-projects/
# Packaged version: /home/alex/clawd/home-projects.skill

Quick Start

Læs alle projekter

skills/home-projects/scripts/read-projects.sh

Tilføj nyt projekt

skills/home-projects/scripts/add-project.sh \
  "tilretning af døre til at lukke korrekt" \
  34 \
  "2 timer" \
  ""

Analyser projekter

skills/home-projects/scripts/analyze-projects.sh

Features

  • Read projects from Google Sheet (via MCP)
  • Add new projects (local cache + manual sync)
  • Analyze priorities, costs, and timelines
  • Categorize projects (indvendigt, udvendigt, teknisk)
  • ⚠️ Write to Google Sheet requires OAuth setup (see references/oauth-setup.md)

Google Sheet

Scripts

scripts/read-projects.sh

Reads all projects from Google Sheet via MCP and caches to /tmp/husprojekt_liste.txt.

scripts/add-project.sh

Adds new project to local cache and provides instructions for manual Google Sheet update.

Usage:

scripts/add-project.sh "Task name" priority "time estimate" "price estimate"

Example:

scripts/add-project.sh "Ny opgave" 35 "3 timer" "1500"

scripts/analyze-projects.sh

Analyzes projects and provides:

  • Total projects, time, cost
  • Top 10 priorities
  • Quick wins (< 1 hour)
  • Largest projects
  • Category breakdown

OAuth Setup (Optional)

For automatic Google Sheet write access:

  1. Get Google Cloud credentials (client_secret.json)
  2. Install gog CLI: brew install steipete/tap/gogcli
  3. Set up OAuth: gog auth add your@gmail.com --services sheets

See references/oauth-setup.md for complete guide.

Cache Files

  • /tmp/husprojekt_liste.txt - Raw project data
  • /tmp/husprojekt_analyse.md - Detailed analysis

Integration

With Home Assistant

Projects that could integrate with Home Assistant:

  • Smart locks
  • Heating control
  • Surveillance network
  • Door sensors

See homeassistant skill for integration details.

With Kanban Board

Projects can be imported to Kanban:

# Tag as domain:home, type:epic
# Link to Google Sheet for reference

Troubleshooting

MCP not working

# Check MCP server status
mcporter list

# Test Google Workspace connection
mcporter call --server google-workspace --tool sheets.getText \
  spreadsheetId="1G6KEBQER_qBI3Hau8GUBrhEOf4FrHMtmKypPjD_8pBw"

OAuth issues

# Check gog auth
gog auth list

# Re-authenticate
gog auth add your@gmail.com --services sheets

Development

Created: 2026-02-17
Last updated: 2026-02-17
Location: /home/alex/clawd/skills/home-projects/
Package: /home/alex/clawd/home-projects.skill