Aggregate statistics (sum, average, count, min, max) computed from a Google Sheet range and displayed as a row of stat badges. Ideal for dashboards.
| Field | Type | |
|---|---|---|
| spreadsheet_id | string. The Google Sheets ID. | required |
| sheet_name | string. Sheet tab name. | optional |
| range | string. A1 notation range (e.g. B2:B50). | required |
| label | string. Card heading. Default is "Sheet Stats". | optional |
| show | array. Which stats to show — any of sum, average, count, min, max. Default ["sum","average","count"]. | optional |
| accent | string. Accent colour for stat values. | optional |
{
"type": "sheet_stats",
"spreadsheet_id": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms",
"range": "A1:D10"
}{
"identifier": "urn:air:a2uicatalog.ai:atom:sheet_stats",
"displayName": "Sheet Stats",
"type": "application/vnd.a2ui.atom+json",
"url": "https://a2uicatalog.ai/atoms/sheet_stats",
"capabilities": [
"apps-script-web"
],
"description": "Aggregate statistics (sum, average, count, min, max) computed from a Google Sheet range and displayed as a row of stat badges. Ideal for dashboards.",
"representativeQueries": [
"show a aggregate stats from a sheet range displayed as stat badges",
"aggregate statistics (sum, average, count, min, max) computed from a google sheet range and displaye",
"render a sheet stats"
]
}The renderer is open source. Deploy your own instance in 4 commands — you own the URL, no dependency on the demo endpoint.
git clone https://github.com/a2uicatalog/a2ui
cd apps-script-surface/gas-schema-renderer
clasp push && clasp deploy