Google Sheets Validation Skill

Purpose

Validates data integrity and state consistency across Google Sheets operations during CFN Loop execution. Provides objective verification that schema exists, data is properly populated, formulas are correct, and no errors exist in the spreadsheet.

Problem Solved

Google Sheets operations fail silently when data is malformed, formulas contain errors, or API calls return unexpected results. Without validation, invalid intermediate states propagate to subsequent phases, causing cascading failures. This skill provides comprehensive validation gates preventing invalid state progression.

When to Use

• After schema creation phase completes (verify structure)
• After data population phase completes (verify data consistency)
• After formula application phase completes (verify calculation correctness)
• During Loop 2 validation (verify overall integrity)
• For audit trails and compliance reporting
• Before proceeding to next sprint phase