Live read-only preview of a specified range in a Google Sheet. Renders as an HTML table. Works on Google Apps Script only.
| Field | Type | |
|---|---|---|
| spreadsheet_id | string. The Google Sheets ID. | required |
| sheet_name | string. The name of the sheet tab. | required |
| range | string. The A1 notation range (e.g. A1:D10). | required |
{
"type": "sheet_preview",
"spreadsheet_id": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms",
"sheet_name": "Sheet name",
"range": "A1:D10"
}{
"identifier": "urn:air:a2uicatalog.ai:atom:sheet_preview",
"displayName": "Sheet Preview",
"type": "application/vnd.a2ui.atom+json",
"url": "https://a2uicatalog.ai/atoms/sheet_preview",
"capabilities": [
"apps-script-web"
],
"description": "Live read-only preview of a specified range in a Google Sheet. Renders as an HTML table. Works on Google Apps Script only.",
"representativeQueries": [
"show a live read-only Google Sheet range preview",
"live read-only preview of a specified range in a google sheet. renders as an html table. works on go",
"render a sheet preview"
]
}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