sheet-schema-drift
CommunityDetect sheet column drift before it corrupts data
Data & Analytics#data integrity#alerting#scheduled tasks#header validation#silent corruption#sheet schema#tab map
Authorblucsigma05
Version1.0.0
Installs0
System Documentation
What problem does it solve?
It prevents silent failures when the Google Sheet column order or headers drift away from what the code’s TAB_MAP expects, which can cause reads to return wrong types and writes to corrupt data.
Core Features & Use Cases
- Daily schema verification: Compares expected TAB_MAP tab headers against live sheet header data.
- Actionable drift reporting: Distinguishes missing, extra, and reordered columns with escalating alert priorities.
- Operational guardrails: Stops and files an issue if the required getSheetHeaders endpoint is unavailable, avoiding false comparisons.
- Audit trail: Appends results to a “Schema Drift Log” page for PM visibility.
Quick Start
Schedule and run the sheet-schema-drift task so it pulls TAB_MAP expectations from DataEngine.gs and verifies live headers via the getSheetHeaders endpoint.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: sheet-schema-drift Download link: https://github.com/blucsigma05/tbm-apps-script/archive/main.zip#sheet-schema-drift Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.