🎁 Get the FREE AI Skills Starter Guide β€” Subscribe β†’
BytesAgainBytesAgain
πŸ¦€ ClawHub

Runtime Instructions Control Plane

by @danielsinewe

Load per-job runtime instructions from Google Sheets, cache them locally, and reconcile cron job enablement flags safely for OpenClaw operations.

TERMINAL
clawhub install runtime-instructions-control-plane

πŸ“– About This Skill


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 enabled flags 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.mjs
  • scripts/reconcile-cron-from-sheet.mjs
  • references/google-sheet-instructions-schema.md
  • templates/job_instructions_template.csv
  • Environment

    Set these before running:
  • GOOGLE_SHEETS_SPREADSHEET_ID
  • GOOGLE_SHEETS_RANGE (optional, default in scripts)
  • Either service account creds:
  • - GOOGLE_SERVICE_ACCOUNT_EMAIL - GOOGLE_SERVICE_ACCOUNT_PRIVATE_KEY
  • Or authenticated gcloud for 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-name ""
    

    Load from cache only (no network):

    node scripts/load-sheet-instructions.mjs --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.
  • πŸ’‘ Examples

    Load one job's runtime instructions:

    node scripts/load-sheet-instructions.mjs \
      --job-id "" \
      --job-name ""
    

    Load from cache only (no network):

    node scripts/load-sheet-instructions.mjs --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