sheets-reconciliation

Compare a sheet range against its source of truth and report mismatches with cell-level citations.

Updated Sep 11, 2026
One-click install
npx skills add https://github.com/JYeswak/grok_bot_playground --skill sheets-reconciliation-jyeswak
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sheets-reconciliation
Source: https://github.com/JYeswak/grok_bot_playground/tree/main/plugin/skills/sheets-reconciliation
Command: npx skills add https://github.com/JYeswak/grok_bot_playground --skill sheets-reconciliation-jyeswak

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Spreadsheets silently drift from the systems they mirror — a hand-edited row, a stale export, a rollup formula pointing at an old range — and a vague "all match" claim hides the damage. This Skill performs a rigorous, read-only reconciliation that names both sides, cites every disagreement to its exact cell and source line, and never writes a fix without the owner's explicit approval. ## Core Features & Use Cases - Cited row-by-row comparison: Walks every join key on both sides and reports each mismatch with the side-A cell reference (Tab!A4:D4) and the side-B record (line number or record id). - Rollup verification: Recomputes summary cells from the detail ranges they claim to cover and flags stale or incorrect totals. - Read-only safety boundary: Proposes fixes as drafts only — it never writes, overwrites, appends, or deletes a cell, and quarantines unreadable values instead of forcing a verdict. - Use Case: Verify that a CRM export still matches the tracking sheet your team maintains, producing a mismatch table with verdicts (missing-A, missing-B, value-drift, stale-read, unreadable) and draft fixes for the owner to confirm cell by cell. ## Quick Start Ask the AI to reconcile the range Sheet1!A2:D200 in your workbook against the attached CRM export CSV and report every mismatch with cell citations.

Frequently Asked Questions about sheets-reconciliation

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I check if a spreadsheet matches its source data?▼

Reconcile the sheet by picking a join key present on both sides, normalizing case and date formats, then comparing every row. Each mismatch should cite the exact sheet cell and the source line or record id so findings are verifiable.

How to verify a spreadsheet rollup total against detail rows?▼

Recompute the summary cell from the detail range it claims to cover and compare the result to the displayed value. Cite both the summary cell and the detail range so a stale or mispointed formula is easy to locate.

Can this skill fix the mismatches it finds in my sheet?▼

No. The skill is strictly read-only: it proposes fixes as drafts naming the exact cell and new value, but only the owner's explicit approval of each change authorizes a write, which belongs to a separate routine.

What happens when one side of the reconciliation cannot be read?▼

The unreachable side is recorded as unreachable and the reconciliation stops rather than reporting "all match". A comparison with a missing side is not a valid verdict, and no source values are invented to close the gap.

Why does spreadsheet reconciliation report stale-read mismatches?▼

Every mismatch cell is re-read before reporting to rule out a stale read from caching or concurrent edits. If the value changed between reads, the finding is marked stale-read instead of a true value drift.