Plan Google Sheets changes against exact spreadsheet, tab, range, and record identity, then verify the read-back before calling the work done.
Spreadsheet writes fail in ordinary ways: the wrong tab has a familiar title, a row moves, a formula gets replaced by a value, or a timed-out append gets retried and creates a duplicate. A successful API response does not catch those mistakes.
Google Sheets Operations turns each change into a controlled sequence. It identifies the spreadsheet and sheet by stable IDs, maps records by business key, captures the affected values, formulas, structure, and permissions, and chooses deliberate RAW or USER_ENTERED semantics. Each operation includes preconditions, an approval boundary, expected effects, exact read-back checks, and a recovery path. Ambiguous timeouts stay ambiguous until a read proves what happened.
Use it for bounded appends, value and formula updates, clears, formatting, row changes, sorting, sheet structure, and protected ranges through a Google Workspace connector, CLI, or the Sheets API. It does not require one specific client. The workflow keeps planning separate from mutation and does not broaden approval from one tab, range, or operation to another.
Version 1.0.0 was reviewed on 2026-07-17 and evaluated through Codex CLI with gpt-5.6-sol in 12 fresh read-only contexts. The candidate scored 97.92 across three cases, compared with 76.67 for the same agent without the skill and 82.08 for the exact free upstream. The cases covered a rate update with formula and import-race risk, an append retry after an ambiguous timeout, and a canonical high-risk clear plan. All cases passed. The closest case-level margin over upstream was exactly 5 points. This evaluation measures the supplied cases; it does not prove that a live spreadsheet is correct, that a connector has the claimed permissions, or that a write is safe without current read-back. The reviewed package SHA-256 is 0c924fbd494337cd8c8631e6bea7607e372e2e0ab0addfa5aec3f91d5079a9c1.
The package includes a read-only checker for an optional canonical JSON change plan. Passing it confirms structure, referenced snapshots, risky-operation recovery fields, and verdict precedence. It cannot contact Google, verify source data, authorize a mutation, or prove execution. Maintenance and install support are handled by the platform-operated publisher for this listing.
Input
Plan a change to the FX Rates tab. The supplied currencies are in a different order from the sheet, four rate cells contain formulas, and an import refreshes every 15 minutes. Do not write yet.
Output
A key-mapped change plan with formula decisions, refreshed preconditions, RAW or USER_ENTERED choice, exact cell operations, approval blockers, read-back checks, recovery, and a ready-for-approval or blocked verdict.
Input
An append for ticket T-2048 timed out. Retry only if it did not land, then update that one ticket to mitigated without touching the formula column.
Output
An ordered deduplication and mutation plan that branches on zero, one, or multiple key matches, preserves formulas, re-resolves row identity under concurrency, verifies the returned row, and does not call an ambiguous response successful.
Provide the exact spreadsheet and tab, the requested outcome, affected ranges or record keys, current permissions, the tool or connector you expect to use, and any invariants such as formulas or protected columns. Ask for a read-only plan, an approval-ready operation list, execution of an already approved change, or verification of a completed write. The skill stops at a plan when the target, authority, pre-image, or recovery path is incomplete.
Spreadsheet ID and title, sheet ID and exact title, affected ranges or stable record keys, headers, and the requested outcome.
An authenticated Google Workspace connector, CLI, or Sheets API client with the least access needed for inspection and any explicitly approved write.
Permission to plan or mutate, the approved operation and range, formulas or structure that must survive, and any concurrent imports, forms, scripts, or editors.
A way to read back affected values, formulas, and metadata plus a usable pre-change snapshot for changes that may need compensation.
SKILL.md; controlled Google Sheets inspection, planning, mutation, verification, and recovery workflow; canonical change-plan contract; read-only change-plan checker; Agent Skills interface metadata
No reviews yet.
Input
Create a canonical plan to clear staging cells on one close workbook tab. Approval is pending, writes are not yet allowed, and value and formula snapshots exist.
Output
Schema-bound JSON with exact target and range, referenced snapshots, preconditions, invariants, recovery, a critical approval blocker, not-run verification, and a blocked verdict accepted by the bundled checker.
Creator
Ccevrix8
