Google · Schema
SpreadsheetsPostResponse
SpreadsheetsPostResponse schema
AdvertisingCloudDevelopersGooglePlatformSearchT1Agentic CommerceUniversal Commerce ProtocolAP2A2A
Properties
| Name | Type | Description |
|---|---|---|
| dataSourceSchedules | array | |
| dataSources | array | |
| developerMetadata | array | |
| namedRanges | array | |
| properties | object | |
| sheets | array | |
| spreadsheetId | string | |
| spreadsheetUrl | string |
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-response-schema.json",
"title": "SpreadsheetsPostResponse",
"description": "SpreadsheetsPostResponse schema",
"x-generated": "2026-10-03",
"x-method": "derived",
"x-generator": "derive-json-schema.py",
"x-source": "openapi/google-create-api-openapi.yml#/components/schemas/SpreadsheetsPostResponse",
"type": "object",
"properties": {
"dataSourceSchedules": {
"type": "array",
"items": {
"type": "object",
"properties": {
"dailySchedule": {
"type": "object",
"properties": {
"startTime": {
"type": "object",
"properties": {
"hours": {
"type": "integer"
},
"minutes": {
"type": "integer"
},
"nanos": {
"type": "integer"
},
"seconds": {
"type": "integer"
}
}
}
}
},
"enabled": {
"type": "boolean"
},
"monthlySchedule": {
"type": "object",
"properties": {
"daysOfMonth": {
"type": "array",
"items": {
"type": "integer"
}
},
"startTime": {
"type": "object",
"properties": {
"hours": {
"type": "integer"
},
"minutes": {
"type": "integer"
},
"nanos": {
"type": "integer"
},
"seconds": {
"type": "integer"
}
}
}
}
},
"nextRun": {
"type": "object",
"properties": {
"endTime": {
"type": "string"
},
"startTime": {
"type": "string"
}
}
},
"refreshScope": {
"type": "string"
},
"weeklySchedule": {
"type": "object",
"properties": {
"daysOfWeek": {
"type": "array",
"items": {
"type": "string"
}
},
"startTime": {
"type": "object",
"properties": {
"hours": {
"type": "integer"
},
"minutes": {
"type": "integer"
},
"nanos": {
"type": "integer"
},
"seconds": {
"type": "integer"
}
}
}
}
}
}
}
},
"dataSources": {
"type": "array",
"items": {
"type": "object",
"properties": {
"calculatedColumns": {
"type": "array",
"items": {
"type": "object",
"properties": {
"formula": {
"type": "string"
},
"reference": {
"type": "object",
"properties": {
"name": {
"type": "string"
}
}
}
}
}
},
"dataSourceId": {
"type": "string"
},
"sheetId": {
"type": "integer"
},
"spec": {
"type": "object",
"properties": {
"bigQuery": {
"type": "object",
"properties": {
"projectId": {
"type": "string"
},
"querySpec": {
"type": "object",
"properties": {
"rawQuery": {
"type": "string"
}
}
},
"tableSpec": {
"type": "object",
"properties": {
"datasetId": {
"type": "string"
},
"tableId": {
"type": "string"
},
"tableProjectId": {
"type": "string"
}
}
}
}
},
"parameters": {
"type": "array",
"items": {
"type": "object",
"properties": {
"name": {
"type": "string"
},
"namedRangeId": {
"type": "string"
},
"range": {
"type": "object",
"properties": {
"endColumnIndex": {
"type": "integer"
},
"endRowIndex": {
"type": "integer"
},
"sheetId": {
"type": "integer"
},
"startColumnIndex": {
"type": "integer"
},
"startRowIndex": {
"type": "integer"
}
}
}
}
}
}
}
}
}
}
},
"developerMetadata": {
"type": "array",
"items": {
"type": "object",
"properties": {
"location": {
"type": "object",
"properties": {
"dimensionRange": {
"type": "object",
"properties": {
"dimension": {
"type": "string"
},
"endIndex": {
"type": "integer"
},
"sheetId": {
"type": "integer"
},
"startIndex": {
"type": "integer"
}
}
},
"locationType": {
"type": "string"
},
"sheetId": {
"type": "integer"
},
"spreadsheet": {
"type": "boolean"
}
}
},
"metadataId": {
"type": "integer"
},
"metadataKey": {
"type": "string"
},
"metadataValue": {
"type": "string"
},
"visibility": {
"type": "string"
}
}
}
},
"namedRanges": {
"type": "array",
"items": {
"type": "object",
"properties": {
"name": {
"type": "string"
},
"namedRangeId": {
"type": "string"
},
"range": {
"type": "object",
"properties": {
"endColumnIndex": {
"type": "integer"
},
"endRowIndex": {
"type": "integer"
},
"sheetId": {
"type": "integer"
},
"startColumnIndex": {
"type": "integer"
},
"startRowIndex": {
"type": "integer"
}
}
}
}
}
},
"properties": {
"$ref": "#/$defs/SpreadsheetsPostResponseProperties"
},
"sheets": {
"type": "array",
"items": {
"type": "object",
"properties": {
"bandedRanges": {
"type": "array",
"items": {
"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"
}
}
}
}
}
}
}
},
"basicFilter": {
"type": "object",
"properties": {
"criteria": {
"type": "object",
"properties": {
"doloreb_": {
"type": "object",
"properties": {
"condition": {
"type": "object",
"properties": {
"type": {
"type": "string"
},
"values": {
"type": "array",
"items": {
"type": "object",
"properties": {
"relativeDate": {
"type": "string"
},
"userEnteredValue": {
"type": "string"
}
}
}
}
}
},
"hiddenValues": {
"type": "array",
"items": {
"type": "string"
}
},
"visibleBackgroundColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"visibleBackgroundColorStyle": {
"type": "object",
"properties": {
"rgbColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"themeColor": {
"type": "string"
}
}
},
"visibleForegroundColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"visibleForegroundColorStyle": {
"type": "object",
"properties": {
"rgbColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"themeColor": {
"type": "string"
}
}
}
}
}
}
},
"filterSpecs": {
"type": "array",
"items": {
"type": "object",
"properties": {
"columnIndex": {
"type": "integer"
},
"dataSourceColumnReference": {
"type": "object",
"properties": {
"name": {
"type": "string"
}
}
},
"filterCriteria": {
"type": "object",
"properties": {
"condition": {
"type": "object",
"properties": {
"type": {
"type": "string"
},
"values": {
"type": "array",
"items": {
"type": "object",
"properties": {
"relativeDate": {
"type": "string"
},
"userEnteredValue": {
"type": "string"
}
}
}
}
}
},
"hiddenValues": {
"type": "array",
"items": {
"type": "string"
}
},
"visibleBackgroundColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"visibleBackgroundColorStyle": {
"type": "object",
"properties": {
"rgbColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"themeColor": {
"type": "string"
}
}
},
"visibleForegroundColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
}
},
"visibleForegroundColorStyle": {
"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"
}
}
},
"sortSpecs": {
"type": "array",
"items": {
"type": "object",
"properties": {
"backgroundColor": {
"type": "object",
"properties": {
"alpha": {
"type": "number"
},
"blue": {
"type": "number"
},
"green": {
"type": "number"
},
"red": {
"type": "number"
}
# --- truncated at 32 KB (424 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/google/refs/heads/main/json-schema/google-spreadsheets-post-response-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-response"
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.