1. The Problem Statement:
Currently, Google Sheets is strictly tabular. Developers attempting to store nested JSON data must either store “Stringified” text (which is unreadable) or create multiple sheets with complex relational mappings. This leads to high maintenance costs and data integrity risks for organizations. Organizations need an easy way out for updating configurations specially for large Applications where there are a lot of available options that need to be updated more frequently.
2. The Proposed Solution: JSON Sheets
A new document type that treats the grid as a hierarchical tree rather than a flat matrix.
-
UI/UX: A “Smooth Layout” rendering engine that allows for collapsible nodes, type-validation (Boolean vs. String vs. Object), and breadcrumb navigation.
-
Integration: A dedicated API class within Apps Script (JsonSheetApp) to allow real-time GET/POST actions directly from/to external applications.
3. Use Cases:
-
Config Management: Organizations managing app configurations collaboratively through JSON sheets.
-
Localized Content: Storing multi-nested translation strings for global apps.
-
Readable External JSON Import View: Can also be utilized for importing any json for the Smooth UI/UX readability.