Google · Schema
SpreadsheetsPostResponse1
SpreadsheetsPostResponse1 schema
AdvertisingCloudDevelopersGooglePlatformSearchT1Agentic CommerceUniversal Commerce ProtocolAP2A2A
Properties
| Name | Type | Description |
|---|---|---|
| replies | array | |
| spreadsheetId | string | |
| updatedSpreadsheet | object |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"$id": "https://raw.githubusercontent.com/api-evangelist/google/main/json-schema/google-spreadsheets-post-response1-schema.json",
"title": "SpreadsheetsPostResponse1",
"description": "SpreadsheetsPostResponse1 schema",
"x-generated": "2026-10-03",
"x-method": "derived",
"x-generator": "derive-json-schema.py",
"x-source": "openapi/google-batch-api-openapi.yml#/components/schemas/SpreadsheetsPostResponse1",
"type": "object",
"properties": {
"replies": {
"type": "array",
"items": {
"type": "object",
"properties": {
"addBanding": {
"type": "object",
"properties": {
"bandedRange": {
"type": "object",
"properties": {
"bandedRangeId": {
"type": "integer"
},
"columnProperties": {
"type": "object",
"properties": {
"firstBandColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"firstBandColorStyle": {
"type": "object",
"properties": {
"rgbColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"themeColor": {
"type": "string"
}
}
},
"footerColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"footerColorStyle": {
"type": "object",
"properties": {
"rgbColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"themeColor": {
"type": "string"
}
}
},
"headerColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"headerColorStyle": {
"type": "object",
"properties": {
"rgbColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"themeColor": {
"type": "string"
}
}
},
"secondBandColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"secondBandColorStyle": {
"type": "object",
"properties": {
"rgbColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"themeColor": {
"type": "string"
}
}
}
}
},
"range": {
"type": "object",
"properties": {
"endColumnIndex": {
"type": "integer"
},
"endRowIndex": {
"type": "integer"
},
"sheetId": {
"type": "integer"
},
"startColumnIndex": {
"type": "integer"
},
"startRowIndex": {
"type": "integer"
}
}
},
"rowProperties": {
"type": "object",
"properties": {
"firstBandColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"firstBandColorStyle": {
"type": "object",
"properties": {
"rgbColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"themeColor": {
"type": "string"
}
}
},
"footerColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"footerColorStyle": {
"type": "object",
"properties": {
"rgbColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"themeColor": {
"type": "string"
}
}
},
"headerColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"headerColorStyle": {
"type": "object",
"properties": {
"rgbColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"themeColor": {
"type": "string"
}
}
},
"secondBandColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"secondBandColorStyle": {
"type": "object",
"properties": {
"rgbColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"themeColor": {
"type": "string"
}
}
}
}
}
}
}
}
},
"addChart": {
"type": "object",
"properties": {
"chart": {
"type": "object",
"properties": {
"border": {
"type": "object",
"properties": {
"color": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"colorStyle": {
"type": "object",
"properties": {
"rgbColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"themeColor": {
"type": "string"
}
}
}
}
},
"chartId": {
"type": "integer"
},
"position": {
"type": "object",
"properties": {
"newSheet": {
"type": "boolean"
},
"overlayPosition": {
"type": "object",
"properties": {
"anchorCell": {
"type": "object",
"properties": {
"columnIndex": {
"type": "integer"
},
"rowIndex": {
"type": "integer"
},
"sheetId": {
"type": "integer"
}
}
},
"heightPixels": {
"type": "integer"
},
"offsetXPixels": {
"type": "integer"
},
"offsetYPixels": {
"type": "integer"
},
"widthPixels": {
"type": "integer"
}
}
},
"sheetId": {
"type": "integer"
}
}
},
"spec": {
"type": "object",
"properties": {
"altText": {
"type": "string"
},
"backgroundColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"backgroundColorStyle": {
"type": "object",
"properties": {
"rgbColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"themeColor": {
"type": "string"
}
}
},
"basicChart": {
"type": "object",
"properties": {
"axis": {
"type": "array",
"items": {
"type": "object",
"properties": {
"format": {
"type": "object",
"properties": {
"bold": {
"type": "boolean"
},
"fontFamily": {
"type": "string"
},
"fontSize": {
"type": "integer"
},
"foregroundColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"foregroundColorStyle": {
"type": "object",
"properties": {
"rgbColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"themeColor": {
"type": "string"
}
}
},
"italic": {
"type": "boolean"
},
"link": {
"type": "object",
"properties": {
"uri": {
"type": "string"
}
}
},
"strikethrough": {
"type": "boolean"
},
"underline": {
"type": "boolean"
}
}
},
"position": {
"type": "string"
},
"title": {
"type": "string"
},
"titleTextPosition": {
"type": "object",
"properties": {
"horizontalAlignment": {
"type": "string"
}
}
},
"viewWindowOptions": {
"type": "object",
"properties": {
"viewWindowMax": {
"type": "number"
},
"viewWindowMin": {
"type": "number"
},
"viewWindowMode": {
"type": "string"
}
}
}
}
}
},
"chartType": {
"type": "string"
},
"compareMode": {
"type": "string"
},
"domains": {
"type": "array",
"items": {
"type": "object",
"properties": {
"domain": {
"type": "object",
"properties": {
"aggregateType": {
"type": "string"
},
"columnReference": {
"type": "object",
"properties": {
"name": {
"type": "string"
}
}
},
"groupRule": {
"type": "object",
"properties": {
"dateTimeRule": {
"type": "object",
"properties": {
"type": {
"type": "string"
}
}
},
"histogramRule": {
"type": "object",
"properties": {
"intervalSize": {
"type": "number"
},
"maxValue": {
"type": "number"
},
"minValue": {
"type": "number"
}
}
}
}
},
"sourceRange": {
"type": "object",
"properties": {
"sources": {
"type": "array",
"items": {
"type": "object",
"properties": {
"endColumnIndex": {
"type": "integer"
},
"endRowIndex": {
"type": "integer"
},
"sheetId": {
"type": "integer"
},
"startColumnIndex": {
"type": "integer"
},
"startRowIndex": {
"type": "integer"
}
}
}
}
}
}
}
},
"reversed": {
"type": "boolean"
}
}
}
},
"headerCount": {
"type": "integer"
},
"interpolateNulls": {
"type": "boolean"
},
"legendPosition": {
"type": "string"
},
"lineSmoothing": {
"type": "boolean"
},
"series": {
"type": "array",
"items": {
"type": "object",
"properties": {
"color": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"colorStyle": {
"type": "object",
"properties": {
"rgbColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"themeColor": {
"type": "string"
}
}
},
"dataLabel": {
"type": "object",
"properties": {
"customLabelData": {
"type": "object",
# --- truncated at 32 KB (845 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/google/refs/heads/main/json-schema/google-spreadsheets-post-response1-schema.json
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-spreadsheets-post-response1"
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.