- name
- runtime-instructions-control-plane
- description
- Load per-job runtime instructions from Google Sheets, cache them locally, and reconcile cron job enablement flags safely for OpenClaw operations.
- metadata
- { "openclaw": { "emoji": "🧭", "requires": { "bins": ["node"] } } }
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_EMAIL - GOOGLE_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-onlyPreview cron enable/disable changes from sheet:
node scripts/reconcile-cron-from-sheet.mjsApply cron enable/disable changes:
node scripts/reconcile-cron-from-sheet.mjs --applySafety 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.