Inherited a Broken Sheet
RescueYou inherited a spreadsheet full of #REF! errors with no documentation. You need to understand it, fix it, and document it before it breaks something downstream.
The Prompt
I inherited this sheet from my predecessor: [SHEET_URL] It's full of #REF! errors and I have no idea what it's supposed to do. Can you: 1. Examine the sheet and tell me what it's designed to do 2. Advise top 5 improvements I should make 3. Fix all #REF! errors (I need zero showing) 4. Publish documentation to Notion explaining: - What this sheet does - What inputs it expects - How to use it correctly
Just Paste and Watch
Claude Code figures out which Gremlin commands to run. Inspect → diagnose → snapshot → repair → validate → document. You don't need to learn the CLI — it already knows it.
How Gremlin Handles This
Inspect
Analyze structure, formulas, and data flow
Diagnose
Find all #REF! errors and root causes
Lint
Validate formulas, detect broken references
Repair/Rescue
Fix broken references and formula chains
Snapshot
Create versioned backups before/after
Publish
Generate "How This Sheet Works" documentation
How Claude Code Executes It
This sheet is a mess. Let me inspect the structure before fixing anything.
g-gremlin inspect -s SHEET_ID --structure --lint --output .g_gremlin/profile.json
✓ 3 tabs found, 142 formulas detected
g-gremlin lint SHEET_ID --rules "all" --transitive --output lint_report.json
✓ Found 47 #REF! errors across 3 tabs
g-gremlin snapshot create SHEET_ID --name "pre-repair-backup"
✓ Snapshot saved
g-gremlin repair SHEET_ID --apply
✓ Repaired 47 broken references
Sheet repaired and documentation published to Notion.
Results
Try This Workflow
Start with the quickstart guide, then rescue your own inherited sheets.