runtime-instructions-control-plane
Load per-job runtime instructions from Google Sheets, cache them locally, and reconcile cron job enablement flags safely for OpenClaw operations.
- License 许可
- MIT
- 最近更新
- 2026-06-10
- Stars
- ★ 3
- Forks
- 0
01 前言 Front Matter
- name
- runtime-instructions-control-plane
- metadata
- { "openclaw": { "emoji": "🧭", "requires": { "bins": [ "node" ] } } }
- description
- Load per-job runtime instructions from Google Sheets, cache them locally, and reconcile cron job enablement flags safely for OpenClaw operations.
03 SKILL.md 正文
Runtime Instructions Control Plane
Use this skill to run OpenClaw jobs from a Google Sheet control plane without editing cron/jobs.json manually.
What this provides
- Fetches per-job instructions from Google Sheets and writes local runtime cache files.
- Supports local-only fallback from cache when Sheets or auth is unavailable.
- Reconciles cron job
enabledflags from sheet rows in dry-run or apply mode. - Includes a schema reference and starter CSV template for sheet setup.
Included files
scripts/load-sheet-instructions.mjsscripts/reconcile-cron-from-sheet.mjsreferences/google-sheet-instructions-schema.mdtemplates/job_instructions_template.csv
Environment
Set these before running:
GOOGLE_SHEETS_SPREADSHEET_IDGOOGLE_SHEETS_RANGE(optional, default in scripts)- Either service account creds:
GOOGLE_SERVICE_ACCOUNT_EMAILGOOGLE_SERVICE_ACCOUNT_PRIVATE_KEY
- Or authenticated
gcloudfor token fallback in loader script.
Optional path overrides:
OPENCLAW_ROOT(default:~/.openclaw)OPENCLAW_RUNTIME_INSTRUCTIONS_DIR(default:$OPENCLAW_ROOT/memory/runtime-instructions)OPENCLAW_CRON_JOBS_PATH(default:$OPENCLAW_ROOT/cron/jobs.json)
Usage
Load one job's runtime instructions:
node scripts/load-sheet-instructions.mjs \
--job-id "<job-id>" \
--job-name "<job-name>"
Load from cache only (no network):
node scripts/load-sheet-instructions.mjs --job-id "<job-id>" --local-only
Preview cron enable/disable changes from sheet:
node scripts/reconcile-cron-from-sheet.mjs
Apply cron enable/disable changes:
node scripts/reconcile-cron-from-sheet.mjs --apply
Safety notes
- Always run dry-run first before
--apply. - Reconcile script creates a timestamped backup before writing
jobs.json. - Keep this focused on operational control-plane toggles, not content generation.
04 同仓库更多 Skills
youtube-content
YouTube transcripts to summaries, threads, blogs.
xurl
X/Twitter via xurl CLI: post, search, DM, media, v2 API.
touchdesigner-mcp
Control a running TouchDesigner instance via twozero MCP — create operators, set parameters, wire connections, execute Python, build real-time visuals. 36 native tools.
test-driven-development
TDD: enforce RED-GREEN-REFACTOR, tests before code.
teams-meeting-pipeline
Operate the Teams meeting summary pipeline via Hermes CLI — summarize meetings, inspect pipeline status, replay jobs, manage Microsoft Graph subscriptions.
systematic-debugging
4-phase root cause debugging: understand bugs before fixing.