Sheet Stats

Aggregate statistics (sum, average, count, min, max) computed from a Google Sheet range and displayed as a row of stat badges. Ideal for dashboards.

Surfaces

google-apps-script-webmcp-apps ⚠

Degraded on

Surface	Note
mcp-apps	renders sample data — live Google Workspace data requires an Apps Script deployment

Live preview

📊 Sheet Stats — live stats require server-side auth.

Fields

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

Example payload

{
  "type": "sheet_stats",
  "spreadsheet_id": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms",
  "range": "A1:D10"
}

ARD catalog entry

{
  "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": [
    "google-apps-script-web",
    "mcp-apps"
  ],
  "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"
  ]
}

← Full ARD catalog

Deploy your own Google Apps Script renderer

The renderer is an open-source Google Apps Script web app. 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 a2ui/apps-script-surface/gas-wired-renderer
clasp push && clasp deploy

Full deploy guide →