Google Sheets · Schema

DataSource

Information about an external data source in the spreadsheet.

Google WorkspaceProductivitySpreadsheets

Properties

Name Type Description
dataSourceId string The spreadsheet-scoped unique ID that identifies the data source.
calculatedColumns array All calculated columns in the data source.
sheetId integer The ID of the Sheet connected with the data source.
View JSON Schema on GitHub

JSON Schema

google-sheets-data-source-schema.json Raw ↑ 
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "DataSource",
  "type": "object",
  "description": "Information about an external data source in the spreadsheet.",
  "properties": {
    "dataSourceId": {
      "type": "string",
      "description": "The spreadsheet-scoped unique ID that identifies the data source."
    },
    "calculatedColumns": {
      "type": "array",
      "description": "All calculated columns in the data source."
    },
    "sheetId": {
      "type": "integer",
      "description": "The ID of the Sheet connected with the data source."
    }
  }
}