- spreadsheets
- /v4/spreadsheets
- /v4/spreadsheets/{spreadsheetId}
- /v4/spreadsheets/{spreadsheetId}/developerMetadata/{metadataId}
- /v4/spreadsheets/{spreadsheetId}/developerMetadata:search
- /v4/spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyTo
- /v4/spreadsheets/{spreadsheetId}/values/{range}
- /v4/spreadsheets/{spreadsheetId}/values/{range}
- /v4/spreadsheets/{spreadsheetId}/values/{range}:append
- /v4/spreadsheets/{spreadsheetId}/values/{range}:clear
- /v4/spreadsheets/{spreadsheetId}/values:batchClear
- /v4/spreadsheets/{spreadsheetId}/values:batchClearByDataFilter
- /v4/spreadsheets/{spreadsheetId}/values:batchGet
- /v4/spreadsheets/{spreadsheetId}/values:batchGetByDataFilter
- /v4/spreadsheets/{spreadsheetId}/values:batchUpdate
- /v4/spreadsheets/{spreadsheetId}/values:batchUpdateByDataFilter
- /v4/spreadsheets/{spreadsheetId}:batchUpdate
- /v4/spreadsheets/{spreadsheetId}:getByDataFilter
- Schemas
- Schemas
- AddBandingRequest
- AddBandingResponse
- AddChartRequest
- AddChartResponse
- AddConditionalFormatRuleRequest
- AddDataSourceRequest
- AddDataSourceResponse
- AddDimensionGroupRequest
- AddDimensionGroupResponse
- AddFilterViewRequest
- AddFilterViewResponse
- AddNamedRangeRequest
- AddNamedRangeResponse
- AddProtectedRangeRequest
- AddProtectedRangeResponse
- AddSheetRequest
- AddSheetResponse
- AddSlicerRequest
- AddSlicerResponse
- AppendCellsRequest
- AppendDimensionRequest
- AppendValuesResponse
- AutoFillRequest
- AutoResizeDimensionsRequest
- BandedRange
- BandingProperties
- BaselineValueFormat
- BasicChartAxis
- BasicChartDomain
- BasicChartSeries
- BasicChartSpec
- BasicFilter
- BasicSeriesDataPointStyleOverride
- BatchClearValuesByDataFilterRequest
- BatchClearValuesByDataFilterResponse
- BatchClearValuesRequest
- BatchClearValuesResponse
- BatchGetValuesByDataFilterRequest
- BatchGetValuesByDataFilterResponse
- BatchGetValuesResponse
- BatchUpdateSpreadsheetRequest
- BatchUpdateSpreadsheetResponse
- BatchUpdateValuesByDataFilterRequest
- BatchUpdateValuesByDataFilterResponse
- BatchUpdateValuesRequest
- BatchUpdateValuesResponse
- BigQueryDataSourceSpec
- BigQueryQuerySpec
- BigQueryTableSpec
- BooleanCondition
- BooleanRule
- Border
- Borders
- BubbleChartSpec
- CandlestickChartSpec
- CandlestickData
- CandlestickDomain
- CandlestickSeries
- CellData
- CellFormat
- ChartAxisViewWindowOptions
- ChartCustomNumberFormatOptions
- ChartData
- ChartDateTimeRule
- ChartGroupRule
- ChartHistogramRule
- ChartSourceRange
- ChartSpec
- ClearBasicFilterRequest
- ClearValuesRequest
- ClearValuesResponse
- Color
- ColorStyle
- ConditionValue
- ConditionalFormatRule
- CopyPasteRequest
- CopySheetToAnotherSpreadsheetRequest
- CreateDeveloperMetadataRequest
- CreateDeveloperMetadataResponse
- CutPasteRequest
- DataExecutionStatus
- DataFilter
- DataFilterValueRange
- DataLabel
- DataSource
- DataSourceChartProperties
- DataSourceColumn
- DataSourceColumnReference
- DataSourceFormula
- DataSourceObjectReference
- DataSourceObjectReferences
- DataSourceParameter
- DataSourceRefreshDailySchedule
- DataSourceRefreshMonthlySchedule
- DataSourceRefreshSchedule
- DataSourceRefreshWeeklySchedule
- DataSourceSheetDimensionRange
- DataSourceSheetProperties
- DataSourceSpec
- DataSourceTable
- DataValidationRule
- DateTimeRule
- DeleteBandingRequest
- DeleteConditionalFormatRuleRequest
- DeleteConditionalFormatRuleResponse
- DeleteDataSourceRequest
- DeleteDeveloperMetadataRequest
- DeleteDeveloperMetadataResponse
- DeleteDimensionGroupRequest
- DeleteDimensionGroupResponse
- DeleteDimensionRequest
- DeleteDuplicatesRequest
- DeleteDuplicatesResponse
- DeleteEmbeddedObjectRequest
- DeleteFilterViewRequest
- DeleteNamedRangeRequest
- DeleteProtectedRangeRequest
- DeleteRangeRequest
- DeleteSheetRequest
- DeveloperMetadata
- DeveloperMetadataLocation
- DeveloperMetadataLookup
- DimensionGroup
- DimensionProperties
- DimensionRange
- DuplicateFilterViewRequest
- DuplicateFilterViewResponse
- DuplicateSheetRequest
- DuplicateSheetResponse
- Editors
- EmbeddedChart
- EmbeddedObjectBorder
- EmbeddedObjectPosition
- ErrorValue
- ExtendedValue
- FilterCriteria
- FilterSpec
- FilterView
- FindReplaceRequest
- FindReplaceResponse
- GetSpreadsheetByDataFilterRequest
- GradientRule
- GridCoordinate
- GridData
- GridProperties
- GridRange
- HistogramChartSpec
- HistogramRule
- HistogramSeries
- InsertDimensionRequest
- InsertRangeRequest
- InterpolationPoint
- Interval
- IterativeCalculationSettings
- KeyValueFormat
- LineStyle
- Link
- ManualRule
- ManualRuleGroup
- MatchedDeveloperMetadata
- MatchedValueRange
- MergeCellsRequest
- MoveDimensionRequest
- NamedRange
- NumberFormat
- OrgChartSpec
- OverlayPosition
- Padding
- PasteDataRequest
- PieChartSpec
- PivotFilterCriteria
- PivotFilterSpec
- PivotGroup
- PivotGroupLimit
- PivotGroupRule
- PivotGroupSortValueBucket
- PivotGroupValueMetadata
- PivotTable
- PivotValue
- PointStyle
- ProtectedRange
- RandomizeRangeRequest
- RefreshDataSourceObjectExecutionStatus
- RefreshDataSourceRequest
- RefreshDataSourceResponse
- RepeatCellRequest
- Request
- Response
- RowData
- ScorecardChartSpec
- SearchDeveloperMetadataRequest
- SearchDeveloperMetadataResponse
- SetBasicFilterRequest
- SetDataValidationRequest
- Sheet
- SheetProperties
- Slicer
- SlicerSpec
- SortRangeRequest
- SortSpec
- SourceAndDestination
- Spreadsheet
- SpreadsheetProperties
- SpreadsheetTheme
- TextFormat
- TextFormatRun
- TextPosition
- TextRotation
- TextToColumnsRequest
- ThemeColorPair
- TimeOfDay
- TreemapChartColorScale
- TreemapChartSpec
- TrimWhitespaceRequest
- TrimWhitespaceResponse
- UnmergeCellsRequest
- UpdateBandingRequest
- UpdateBordersRequest
- UpdateCellsRequest
- UpdateChartSpecRequest
- UpdateConditionalFormatRuleRequest
- UpdateConditionalFormatRuleResponse
- UpdateDataSourceRequest
- UpdateDataSourceResponse
- UpdateDeveloperMetadataRequest
- UpdateDeveloperMetadataResponse
- UpdateDimensionGroupRequest
- UpdateDimensionPropertiesRequest
- UpdateEmbeddedObjectBorderRequest
- UpdateEmbeddedObjectPositionRequest
- UpdateEmbeddedObjectPositionResponse
- UpdateFilterViewRequest
- UpdateNamedRangeRequest
- UpdateProtectedRangeRequest
- UpdateSheetPropertiesRequest
- UpdateSlicerSpecRequest
- UpdateSpreadsheetPropertiesRequest
- UpdateValuesByDataFilterResponse
- UpdateValuesResponse
- ValueRange
- WaterfallChartColumnStyle
- WaterfallChartCustomSubtotal
- WaterfallChartDomain
- WaterfallChartSeries
- WaterfallChartSpec
GridRange
"Sheet1" is sheet ID 123456, then: Sheet1!A1:A1 == sheet_id: 123456, start_row_index: 0, end_row_index: 1, start_column_index: 0, end_column_index: 1 `Sheet1!A3:B4 == sheet_id: 123456, start_row_index: 2, end_row_index: 4, start_column_index: 0, end_col{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}