Google Sheets · Schema
GridData
Data in the grid, as well as metadata about the dimensions.
Google WorkspaceProductivitySpreadsheets
Properties
| Name | Type | Description |
|---|---|---|
| startRow | integer | The first row this GridData refers to, zero-based. |
| startColumn | integer | The first column this GridData refers to, zero-based. |
| rowData | array | The data in the grid, one entry per row, starting with the row in startRow. |
| rowMetadata | array | Metadata about the requested rows in the grid, starting with the row in startRow. |
| columnMetadata | array | Metadata about the requested columns in the grid, starting with the column in startColumn. |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"title": "GridData",
"type": "object",
"description": "Data in the grid, as well as metadata about the dimensions.",
"properties": {
"startRow": {
"type": "integer",
"description": "The first row this GridData refers to, zero-based."
},
"startColumn": {
"type": "integer",
"description": "The first column this GridData refers to, zero-based."
},
"rowData": {
"type": "array",
"description": "The data in the grid, one entry per row, starting with the row in startRow."
},
"rowMetadata": {
"type": "array",
"description": "Metadata about the requested rows in the grid, starting with the row in startRow."
},
"columnMetadata": {
"type": "array",
"description": "Metadata about the requested columns in the grid, starting with the column in startColumn."
}
}
}
Work with this as data
Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.
MCP server
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
Tools for schemas
4 MCP tools reach this
find_json_schemasBrowse and filter every JSON Schema in the catalog.apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.resolveTurn a domain, URL or GitHub org into the provider it belongs to.find_cohortsEvery scored population of providers in the catalog.
Call it yourself
curl for this page
This JSON Schema
curl "https://apis.io/api/v1/json-schemas/google-sheets-grid-data"
All schemas
curl "https://apis.io/api/v1/json-schemas?limit=25"
Discovery needs no key. Ratings and market analysis are Pro.
Get an API key
Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.