Google Sheets · Schema

Spreadsheet

A Google Sheets spreadsheet resource.

Google WorkspaceProductivitySpreadsheets

Properties

Name Type Description
spreadsheetId string The ID of the spreadsheet. Read-only.
sheets array The sheets that are part of a spreadsheet.
namedRanges array The named ranges defined in a spreadsheet.
spreadsheetUrl string The URL of the spreadsheet. Read-only.
developerMetadata array The developer metadata associated with a spreadsheet.
dataSources array A list of external data sources connected to the spreadsheet.
dataSourceSchedules array Output only. A list of data source refresh schedules.
View JSON Schema on GitHub

JSON Schema

google-sheets-spreadsheet-schema.json Raw ↑
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "Spreadsheet",
  "type": "object",
  "description": "A Google Sheets spreadsheet resource.",
  "properties": {
    "spreadsheetId": {
      "type": "string",
      "description": "The ID of the spreadsheet. Read-only."
    },
    "sheets": {
      "type": "array",
      "description": "The sheets that are part of a spreadsheet."
    },
    "namedRanges": {
      "type": "array",
      "description": "The named ranges defined in a spreadsheet."
    },
    "spreadsheetUrl": {
      "type": "string",
      "description": "The URL of the spreadsheet. Read-only."
    },
    "developerMetadata": {
      "type": "array",
      "description": "The developer metadata associated with a spreadsheet."
    },
    "dataSources": {
      "type": "array",
      "description": "A list of external data sources connected to the spreadsheet."
    },
    "dataSourceSchedules": {
      "type": "array",
      "description": "Output only. A list of data source refresh schedules."
    }
  }
}