メニュー
Bridges the Google Sheets spreadsheet (primary flock data source) with local flock_database.json. Eliminates manual export. Validates changes against careful-not-clever principles.
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
SOC 職業分類に基づく
| name | google-sheets-sync |
| description | Bridges the Google Sheets spreadsheet (primary flock data source) with local flock_database.json. Eliminates manual export. Validates changes against careful-not-clever principles. |
| version | 1.0.0 |
"The LORD is my shepherd; I shall not want." — Psalm 23:1
The flock's primary data lives in a Google Sheets spreadsheet. This skill bridges the gap between the live spreadsheet and the local data/flock_database.json, eliminating manual export and ensuring data stays current.
claude mcp add google-sheets -- uvx mcp-google-sheets@latest
The project already has: GOOGLE_CLOUD_PROJECT=constant-cubist-471700-e1
Steps:
GOOGLE_APPLICATION_CREDENTIALS=/path/to/key.jsonclaude mcp list # Should show google-sheets as Connected
In a Claude Code session, type /mcp to see active servers.
/sync — Full Syncdata/flock_database.jsonflock_database.jsonpython3 scripts/validate_flock.py| Data | Direction | Notes |
|---|---|---|
| Animal records (tag, name, breed, DOB, status) | Sheets → Local | Primary source |
| Pen assignments | Sheets → Local | Changes frequently |
| Breeding records | Sheets → Local | Seasonal updates |
| Health records (FAMACHA, treatments) | Sheets → Local | Most frequent changes |
| Pedigree (sire/dam) | Sheets → Local | Rarely changes |
| Data | Why |
|---|---|
| Anything contradicting spiral notebook images | Notebook is highest authority (Priority 1) |
| Breed composition percentages | Calculated from parents — recalculate locally |
| Parasite resistance scores | Calculated by scripts/parasite_resistance.py |
| [UNCLEAR] items | Need manual resolution, not overwrite |
| Deceased animal details | Preserve local historical data |
When Sheets and local data disagree:
## Flock Sync Report — [date]
### Changes Found
| Animal | Field | Sheets Value | Local Value | Action |
|--------|-------|-------------|-------------|--------|
| Eclipse | pen | 1 | 3 | APPLY (Sheets wins) |
| NoriSon | sire | unknown | Nori | KEEP LOCAL (notebook verified) |
### Summary
- Applied: [N] changes
- Kept local: [N] items
- Flagged for review: [N] items
- Validation: [pass/fail]
Soli Deo Gloria — Accurate records are faithful stewardship.
Enforces atomic commits, checkpoint summaries, rate-limit recovery, and safe resume patterns. Writes session pulses + cognitive memory so interrupted sessions can restart cleanly.
Evaluate sheep matings and pipeline placement against a performance-based checklist. Select by FAMACHA/FEC first, hair/wool second, breed third, meat fourth. Manages a 7-pen closed-loop breeding pipeline toward a hardy, hairy, meaty, parasite-resistant composite flock.
Round-robin multi-LLM consultation with full-context debate. GPT proposes, Gemini refines, Grok challenges — each sees the full chain including wheat/chaff verdicts and justifications. Nothing is filtered between rounds.
Tracks FAMACHA scores and health trends per animal over time. Flags animals trending toward anemia before they're critical. Links health data to breeding decisions.
Plans pasture rotation for Florida sheep operation. Considers parasite pressure, seasonal grass growth, pen capacity, and rest periods for larval die-off.
Cross-repository cognitive memory system with semantic search. Persists knowledge across sessions using TF-IDF recall, memory versioning, knowledge graph edges, and confidence decay. Memory is cognition, not storage.