Thoughts

UFO UAP RV YT Pipeline - Session 13 update: Pivoted creative pipeline handoff format. Key discovery: Gemini cannot write directly to Google Sheets (only via Apps Script). Claude's Google Drive MCP (google_drive_search + google_drive_fetch) is read-only, cannot write to Sheets either. New handoff flow: Gemini session (phone or desktop) > tap "Export to Docs" (one tap) > Google Doc lands in Drive > Claude reads Doc via Google Drive MCP > Claude outputs production manifests as JSON files in pipeline/manifests/{session_id}/. Rewrote both Gem prompts to output in a structured block format (--- SCRIPT --- / --- END SCRIPT ---) with labeled fields that Claude can reliably parse from a Google Doc. Rewrote process-scripts skill to read from Google Docs and write JSON manifests instead of Google Sheet rows. JSON manifests are version-controlled via git (better rollback than Sheet rows). Google Sheet is no longer needed for the pipeline. JSON files are the contract between creative and automated production pipelines. Also updated global rules: pre-build skill now has Step 5 asking Dave if project uses git. If yes, one-commit-per-task is non-negotiable. Tracking protocol Save Points section strengthened to match.