<button class="button button-with-icon cloud-select-dropdown__button button-primary" aria-haspopup="true">On-premises or any cloud edition v1.15</button>

- [SAP BTP edition v1.1](https://docs.cloud.google.com/sap/docs/abap-sdk/btp/latest/reference/googcl_sheets_v4.md.txt)
- [On-premises or any cloud edition v1.15](https://docs.cloud.google.com/sap/docs/abap-sdk/on-premises-or-any-cloud/latest/reference/googcl_sheets_v4.md.txt)

## Class

```abap
/GOOG/CL_SHEETS_V4
```

- Inheriting from:`/GOOG/CL_HTTP_CLIENT`
- Description:`Google Sheets API v4`

For general information about a class in ABAP SDK for Google Cloud, see [API client stub](https://docs.cloud.google.com/sap/docs/abap-sdk/latest/developer#client_stub).

## Types

| Type | Description | Visibility |
|---|---|---|
| `TY_001` | `AddBandingRequest` | PUBLIC |
| `TY_002` | `AddBandingResponse` | PUBLIC |
| `TY_003` | `AddChartRequest` | PUBLIC |
| `TY_004` | `AddChartResponse` | PUBLIC |
| `TY_005` | `AddConditionalFormatRuleRequest` | PUBLIC |
| `TY_006` | `AddDataSourceRequest` | PUBLIC |
| `TY_007` | `AddDataSourceResponse` | PUBLIC |
| `TY_008` | `AddDimensionGroupRequest` | PUBLIC |
| `TY_009` | `AddDimensionGroupResponse` | PUBLIC |
| `TY_010` | `AddFilterViewRequest` | PUBLIC |
| `TY_011` | `AddFilterViewResponse` | PUBLIC |
| `TY_012` | `AddNamedRangeRequest` | PUBLIC |
| `TY_013` | `AddNamedRangeResponse` | PUBLIC |
| `TY_014` | `AddProtectedRangeRequest` | PUBLIC |
| `TY_015` | `AddProtectedRangeResponse` | PUBLIC |
| `TY_016` | `AddSheetRequest` | PUBLIC |
| `TY_017` | `AddSheetResponse` | PUBLIC |
| `TY_018` | `AddSlicerRequest` | PUBLIC |
| `TY_019` | `AddSlicerResponse` | PUBLIC |
| `TY_020` | `AppendCellsRequest` | PUBLIC |
| `TY_021` | `AppendDimensionRequest` | PUBLIC |
| `TY_022` | `AppendValuesResponse` | PUBLIC |
| `TY_023` | `AutoFillRequest` | PUBLIC |
| `TY_024` | `AutoResizeDimensionsRequest` | PUBLIC |
| `TY_025` | `BandedRange` | PUBLIC |
| `TY_026` | `BandingProperties` | PUBLIC |
| `TY_027` | `BaselineValueFormat` | PUBLIC |
| `TY_028` | `BasicChartAxis` | PUBLIC |
| `TY_029` | `BasicChartDomain` | PUBLIC |
| `TY_030` | `BasicChartSeries` | PUBLIC |
| `TY_031` | `BasicChartSpec` | PUBLIC |
| `TY_032` | `BasicFilter` | PUBLIC |
| `TY_033` | `BasicSeriesDataPointStyleOverride` | PUBLIC |
| `TY_034` | `BatchClearValuesByDataFilterRequest` | PUBLIC |
| `TY_035` | `BatchClearValuesByDataFilterResponse` | PUBLIC |
| `TY_036` | `BatchClearValuesRequest` | PUBLIC |
| `TY_037` | `BatchClearValuesResponse` | PUBLIC |
| `TY_038` | `BatchGetValuesByDataFilterRequest` | PUBLIC |
| `TY_039` | `BatchGetValuesByDataFilterResponse` | PUBLIC |
| `TY_040` | `BatchGetValuesResponse` | PUBLIC |
| `TY_041` | `BatchUpdateSpreadsheetRequest` | PUBLIC |
| `TY_042` | `BatchUpdateSpreadsheetResponse` | PUBLIC |
| `TY_043` | `BatchUpdateValuesByDataFilterRequest` | PUBLIC |
| `TY_044` | `BatchUpdateValuesByDataFilterResponse` | PUBLIC |
| `TY_045` | `BatchUpdateValuesRequest` | PUBLIC |
| `TY_046` | `BatchUpdateValuesResponse` | PUBLIC |
| `TY_047` | `BigQueryDataSourceSpec` | PUBLIC |
| `TY_048` | `BigQueryQuerySpec` | PUBLIC |
| `TY_049` | `BigQueryTableSpec` | PUBLIC |
| `TY_050` | `BooleanCondition` | PUBLIC |
| `TY_051` | `BooleanRule` | PUBLIC |
| `TY_052` | `Border` | PUBLIC |
| `TY_053` | `Borders` | PUBLIC |
| `TY_054` | `BubbleChartSpec` | PUBLIC |
| `TY_055` | `CandlestickChartSpec` | PUBLIC |
| `TY_056` | `CandlestickData` | PUBLIC |
| `TY_057` | `CandlestickDomain` | PUBLIC |
| `TY_058` | `CandlestickSeries` | PUBLIC |
| `TY_059` | `CellData` | PUBLIC |
| `TY_060` | `CellFormat` | PUBLIC |
| `TY_061` | `ChartAxisViewWindowOptions` | PUBLIC |
| `TY_062` | `ChartCustomNumberFormatOptions` | PUBLIC |
| `TY_063` | `ChartData` | PUBLIC |
| `TY_064` | `ChartDateTimeRule` | PUBLIC |
| `TY_065` | `ChartGroupRule` | PUBLIC |
| `TY_066` | `ChartHistogramRule` | PUBLIC |
| `TY_067` | `ChartSourceRange` | PUBLIC |
| `TY_068` | `ChartSpec` | PUBLIC |
| `TY_069` | `ClearBasicFilterRequest` | PUBLIC |
| `TY_071` | `ClearValuesResponse` | PUBLIC |
| `TY_072` | `Color` | PUBLIC |
| `TY_073` | `ColorStyle` | PUBLIC |
| `TY_074` | `ConditionValue` | PUBLIC |
| `TY_075` | `ConditionalFormatRule` | PUBLIC |
| `TY_076` | `CopyPasteRequest` | PUBLIC |
| `TY_077` | `CopySheetToAnotherSpreadsheetRequest` | PUBLIC |
| `TY_078` | `CreateDeveloperMetadataRequest` | PUBLIC |
| `TY_079` | `CreateDeveloperMetadataResponse` | PUBLIC |
| `TY_080` | `CutPasteRequest` | PUBLIC |
| `TY_081` | `DataExecutionStatus` | PUBLIC |
| `TY_082` | `DataFilter` | PUBLIC |
| `TY_083` | `DataFilterValueRange` | PUBLIC |
| `TY_084` | `DataLabel` | PUBLIC |
| `TY_085` | `DataSource` | PUBLIC |
| `TY_086` | `DataSourceChartProperties` | PUBLIC |
| `TY_087` | `DataSourceColumn` | PUBLIC |
| `TY_088` | `DataSourceColumnReference` | PUBLIC |
| `TY_089` | `DataSourceFormula` | PUBLIC |
| `TY_090` | `DataSourceObjectReference` | PUBLIC |
| `TY_091` | `DataSourceObjectReferences` | PUBLIC |
| `TY_092` | `DataSourceParameter` | PUBLIC |
| `TY_093` | `DataSourceRefreshDailySchedule` | PUBLIC |
| `TY_094` | `DataSourceRefreshMonthlySchedule` | PUBLIC |
| `TY_095` | `DataSourceRefreshSchedule` | PUBLIC |
| `TY_096` | `DataSourceRefreshWeeklySchedule` | PUBLIC |
| `TY_097` | `DataSourceSheetDimensionRange` | PUBLIC |
| `TY_098` | `DataSourceSheetProperties` | PUBLIC |
| `TY_099` | `DataSourceSpec` | PUBLIC |
| `TY_100` | `DataSourceTable` | PUBLIC |
| `TY_101` | `DataValidationRule` | PUBLIC |
| `TY_102` | `DateTimeRule` | PUBLIC |
| `TY_103` | `DeleteBandingRequest` | PUBLIC |
| `TY_104` | `DeleteConditionalFormatRuleRequest` | PUBLIC |
| `TY_105` | `DeleteConditionalFormatRuleResponse` | PUBLIC |
| `TY_106` | `DeleteDataSourceRequest` | PUBLIC |
| `TY_107` | `DeleteDeveloperMetadataRequest` | PUBLIC |
| `TY_108` | `DeleteDeveloperMetadataResponse` | PUBLIC |
| `TY_109` | `DeleteDimensionGroupRequest` | PUBLIC |
| `TY_110` | `DeleteDimensionGroupResponse` | PUBLIC |
| `TY_111` | `DeleteDimensionRequest` | PUBLIC |
| `TY_112` | `DeleteDuplicatesRequest` | PUBLIC |
| `TY_113` | `DeleteDuplicatesResponse` | PUBLIC |
| `TY_114` | `DeleteEmbeddedObjectRequest` | PUBLIC |
| `TY_115` | `DeleteFilterViewRequest` | PUBLIC |
| `TY_116` | `DeleteNamedRangeRequest` | PUBLIC |
| `TY_117` | `DeleteProtectedRangeRequest` | PUBLIC |
| `TY_118` | `DeleteRangeRequest` | PUBLIC |
| `TY_119` | `DeleteSheetRequest` | PUBLIC |
| `TY_120` | `DeveloperMetadata` | PUBLIC |
| `TY_121` | `DeveloperMetadataLocation` | PUBLIC |
| `TY_122` | `DeveloperMetadataLookup` | PUBLIC |
| `TY_123` | `DimensionGroup` | PUBLIC |
| `TY_124` | `DimensionProperties` | PUBLIC |
| `TY_125` | `DimensionRange` | PUBLIC |
| `TY_126` | `DuplicateFilterViewRequest` | PUBLIC |
| `TY_127` | `DuplicateFilterViewResponse` | PUBLIC |
| `TY_128` | `DuplicateSheetRequest` | PUBLIC |
| `TY_129` | `DuplicateSheetResponse` | PUBLIC |
| `TY_130` | `Editors` | PUBLIC |
| `TY_131` | `EmbeddedChart` | PUBLIC |
| `TY_132` | `EmbeddedObjectBorder` | PUBLIC |
| `TY_133` | `EmbeddedObjectPosition` | PUBLIC |
| `TY_134` | `ErrorValue` | PUBLIC |
| `TY_135` | `ExtendedValue` | PUBLIC |
| `TY_136` | `FilterCriteria` | PUBLIC |
| `TY_137` | `FilterSpec` | PUBLIC |
| `TY_138` | `FilterView` | PUBLIC |
| `TY_139` | `FindReplaceRequest` | PUBLIC |
| `TY_140` | `FindReplaceResponse` | PUBLIC |
| `TY_141` | `GetSpreadsheetByDataFilterRequest` | PUBLIC |
| `TY_142` | `GradientRule` | PUBLIC |
| `TY_143` | `GridCoordinate` | PUBLIC |
| `TY_144` | `GridData` | PUBLIC |
| `TY_145` | `GridProperties` | PUBLIC |
| `TY_146` | `GridRange` | PUBLIC |
| `TY_147` | `HistogramChartSpec` | PUBLIC |
| `TY_148` | `HistogramRule` | PUBLIC |
| `TY_149` | `HistogramSeries` | PUBLIC |
| `TY_150` | `InsertDimensionRequest` | PUBLIC |
| `TY_151` | `InsertRangeRequest` | PUBLIC |
| `TY_152` | `InterpolationPoint` | PUBLIC |
| `TY_153` | `Interval` | PUBLIC |
| `TY_154` | `IterativeCalculationSettings` | PUBLIC |
| `TY_155` | `KeyValueFormat` | PUBLIC |
| `TY_156` | `LineStyle` | PUBLIC |
| `TY_157` | `Link` | PUBLIC |
| `TY_158` | `ManualRule` | PUBLIC |
| `TY_159` | `ManualRuleGroup` | PUBLIC |
| `TY_160` | `MatchedDeveloperMetadata` | PUBLIC |
| `TY_161` | `MatchedValueRange` | PUBLIC |
| `TY_162` | `MergeCellsRequest` | PUBLIC |
| `TY_163` | `MoveDimensionRequest` | PUBLIC |
| `TY_164` | `NamedRange` | PUBLIC |
| `TY_165` | `NumberFormat` | PUBLIC |
| `TY_166` | `OrgChartSpec` | PUBLIC |
| `TY_167` | `OverlayPosition` | PUBLIC |
| `TY_168` | `Padding` | PUBLIC |
| `TY_169` | `PasteDataRequest` | PUBLIC |
| `TY_170` | `PieChartSpec` | PUBLIC |
| `TY_171` | `PivotFilterCriteria` | PUBLIC |
| `TY_172` | `PivotFilterSpec` | PUBLIC |
| `TY_173` | `PivotGroup` | PUBLIC |
| `TY_174` | `PivotGroupLimit` | PUBLIC |
| `TY_175` | `PivotGroupRule` | PUBLIC |
| `TY_176` | `PivotGroupSortValueBucket` | PUBLIC |
| `TY_177` | `PivotGroupValueMetadata` | PUBLIC |
| `TY_178` | `PivotTable` | PUBLIC |
| `TY_179` | `PivotValue` | PUBLIC |
| `TY_180` | `PointStyle` | PUBLIC |
| `TY_181` | `ProtectedRange` | PUBLIC |
| `TY_182` | `RandomizeRangeRequest` | PUBLIC |
| `TY_183` | `RefreshDataSourceObjectExecutionStatus` | PUBLIC |
| `TY_184` | `RefreshDataSourceRequest` | PUBLIC |
| `TY_185` | `RefreshDataSourceResponse` | PUBLIC |
| `TY_186` | `RepeatCellRequest` | PUBLIC |
| `TY_187` | `Request` | PUBLIC |
| `TY_188` | `Response` | PUBLIC |
| `TY_189` | `RowData` | PUBLIC |
| `TY_190` | `ScorecardChartSpec` | PUBLIC |
| `TY_191` | `SearchDeveloperMetadataRequest` | PUBLIC |
| `TY_192` | `SearchDeveloperMetadataResponse` | PUBLIC |
| `TY_193` | `SetBasicFilterRequest` | PUBLIC |
| `TY_194` | `SetDataValidationRequest` | PUBLIC |
| `TY_195` | `Sheet` | PUBLIC |
| `TY_196` | `SheetProperties` | PUBLIC |
| `TY_197` | `Slicer` | PUBLIC |
| `TY_198` | `SlicerSpec` | PUBLIC |
| `TY_199` | `SortRangeRequest` | PUBLIC |
| `TY_200` | `SortSpec` | PUBLIC |
| `TY_201` | `SourceAndDestination` | PUBLIC |
| `TY_202` | `Spreadsheet` | PUBLIC |
| `TY_203` | `SpreadsheetProperties` | PUBLIC |
| `TY_204` | `SpreadsheetTheme` | PUBLIC |
| `TY_205` | `TextFormat` | PUBLIC |
| `TY_206` | `TextFormatRun` | PUBLIC |
| `TY_207` | `TextPosition` | PUBLIC |
| `TY_208` | `TextRotation` | PUBLIC |
| `TY_209` | `TextToColumnsRequest` | PUBLIC |
| `TY_210` | `ThemeColorPair` | PUBLIC |
| `TY_211` | `TimeOfDay` | PUBLIC |
| `TY_212` | `TreemapChartColorScale` | PUBLIC |
| `TY_213` | `TreemapChartSpec` | PUBLIC |
| `TY_214` | `TrimWhitespaceRequest` | PUBLIC |
| `TY_215` | `TrimWhitespaceResponse` | PUBLIC |
| `TY_216` | `UnmergeCellsRequest` | PUBLIC |
| `TY_217` | `UpdateBandingRequest` | PUBLIC |
| `TY_218` | `UpdateBordersRequest` | PUBLIC |
| `TY_219` | `UpdateCellsRequest` | PUBLIC |
| `TY_220` | `UpdateChartSpecRequest` | PUBLIC |
| `TY_221` | `UpdateConditionalFormatRuleRequest` | PUBLIC |
| `TY_222` | `UpdateConditionalFormatRuleResponse` | PUBLIC |
| `TY_223` | `UpdateDataSourceRequest` | PUBLIC |
| `TY_224` | `UpdateDataSourceResponse` | PUBLIC |
| `TY_225` | `UpdateDeveloperMetadataRequest` | PUBLIC |
| `TY_226` | `UpdateDeveloperMetadataResponse` | PUBLIC |
| `TY_227` | `UpdateDimensionGroupRequest` | PUBLIC |
| `TY_228` | `UpdateDimensionPropertiesRequest` | PUBLIC |
| `TY_229` | `UpdateEmbeddedObjectBorderRequest` | PUBLIC |
| `TY_230` | `UpdateEmbeddedObjectPositionRequest` | PUBLIC |
| `TY_231` | `UpdateEmbeddedObjectPositionResponse` | PUBLIC |
| `TY_232` | `UpdateFilterViewRequest` | PUBLIC |
| `TY_233` | `UpdateNamedRangeRequest` | PUBLIC |
| `TY_234` | `UpdateProtectedRangeRequest` | PUBLIC |
| `TY_235` | `UpdateSheetPropertiesRequest` | PUBLIC |
| `TY_236` | `UpdateSlicerSpecRequest` | PUBLIC |
| `TY_237` | `UpdateSpreadsheetPropertiesRequest` | PUBLIC |
| `TY_238` | `UpdateValuesByDataFilterResponse` | PUBLIC |
| `TY_239` | `UpdateValuesResponse` | PUBLIC |
| `TY_240` | `ValueRange` | PUBLIC |
| `TY_241` | `WaterfallChartColumnStyle` | PUBLIC |
| `TY_242` | `WaterfallChartCustomSubtotal` | PUBLIC |
| `TY_243` | `WaterfallChartDomain` | PUBLIC |
| `TY_244` | `WaterfallChartSeries` | PUBLIC |
| `TY_245` | `WaterfallChartSpec` | PUBLIC |
| `TY_246` | `CancelDataSourceRefreshRequest` | PUBLIC |
| `TY_247` | `CancelDataSourceRefreshResponse` | PUBLIC |
| `TY_248` | `CancelDataSourceRefreshStatus` | PUBLIC |
| `TY_249` | `RefreshCancellationStatus` | PUBLIC |
| `TY_250` | `LookerDataSourceSpec` | PUBLIC |
| `TY_T_025` | `BandedRange` | PUBLIC |
| `TY_T_028` | `BasicChartAxis` | PUBLIC |
| `TY_T_029` | `BasicChartDomain` | PUBLIC |
| `TY_T_030` | `BasicChartSeries` | PUBLIC |
| `TY_T_033` | `BasicSeriesDataPointStyleOverride` | PUBLIC |
| `TY_T_056` | `CandlestickData` | PUBLIC |
| `TY_T_059` | `CellData` | PUBLIC |
| `TY_T_074` | `ConditionValue` | PUBLIC |
| `TY_T_075` | `ConditionalFormatRule` | PUBLIC |
| `TY_T_082` | `DataFilter` | PUBLIC |
| `TY_T_083` | `DataFilterValueRange` | PUBLIC |
| `TY_T_085` | `DataSource` | PUBLIC |
| `TY_T_087` | `DataSourceColumn` | PUBLIC |
| `TY_T_088` | `DataSourceColumnReference` | PUBLIC |
| `TY_T_090` | `DataSourceObjectReference` | PUBLIC |
| `TY_T_092` | `DataSourceParameter` | PUBLIC |
| `TY_T_095` | `DataSourceRefreshSchedule` | PUBLIC |
| `TY_T_120` | `DeveloperMetadata` | PUBLIC |
| `TY_T_123` | `DimensionGroup` | PUBLIC |
| `TY_T_124` | `DimensionProperties` | PUBLIC |
| `TY_T_125` | `DimensionRange` | PUBLIC |
| `TY_T_131` | `EmbeddedChart` | PUBLIC |
| `TY_T_135` | `ExtendedValue` | PUBLIC |
| `TY_T_137` | `FilterSpec` | PUBLIC |
| `TY_T_138` | `FilterView` | PUBLIC |
| `TY_T_144` | `GridData` | PUBLIC |
| `TY_T_146` | `GridRange` | PUBLIC |
| `TY_T_149` | `HistogramSeries` | PUBLIC |
| `TY_T_159` | `ManualRuleGroup` | PUBLIC |
| `TY_T_160` | `MatchedDeveloperMetadata` | PUBLIC |
| `TY_T_161` | `MatchedValueRange` | PUBLIC |
| `TY_T_164` | `NamedRange` | PUBLIC |
| `TY_T_172` | `PivotFilterSpec` | PUBLIC |
| `TY_T_173` | `PivotGroup` | PUBLIC |
| `TY_T_177` | `PivotGroupValueMetadata` | PUBLIC |
| `TY_T_179` | `PivotValue` | PUBLIC |
| `TY_T_181` | `ProtectedRange` | PUBLIC |
| `TY_T_183` | `RefreshDataSourceObjectExecutionStatus` | PUBLIC |
| `TY_T_187` | `Request` | PUBLIC |
| `TY_T_188` | `Response` | PUBLIC |
| `TY_T_189` | `RowData` | PUBLIC |
| `TY_T_195` | `Sheet` | PUBLIC |
| `TY_T_197` | `Slicer` | PUBLIC |
| `TY_T_200` | `SortSpec` | PUBLIC |
| `TY_T_206` | `TextFormatRun` | PUBLIC |
| `TY_T_210` | `ThemeColorPair` | PUBLIC |
| `TY_T_238` | `UpdateValuesByDataFilterResponse` | PUBLIC |
| `TY_T_239` | `UpdateValuesResponse` | PUBLIC |
| `TY_T_240` | `ValueRange` | PUBLIC |
| `TY_T_242` | `WaterfallChartCustomSubtotal` | PUBLIC |
| `TY_T_244` | `WaterfallChartSeries` | PUBLIC |
| `TY_T_248` | `CancelDataSourceRefreshStatus` | PUBLIC |
| `TY_T_INT4` | `Table of Integers` | PUBLIC |
| `TY_T_STRING` | `Table of Strings` | PUBLIC |

## Constants

| Name | Type | Description | Value | Visibility |
|---|---|---|---|---|
| `C_SUPPORTED_AUTH` | `/GOOG/SUPP_AUTH` | Supported Auth Types | OOIJWW | PUBLIC |
| `C_SERVICE_NAME` | `/GOOG/SERVICE_NAME` | Google Service Name | sheets:v4 | PUBLIC |
| `C_ROOT_URL` | `STRING` | API Root URL | https://sheets.googleapis.com | PUBLIC |
| `C_REVISION_DATE` | `DATUM` | Discovery Document revision Date | 20250306 | PUBLIC |
| `C_PATH_PREFIX` | `STRING` | API Path Prefix |   | PUBLIC |
| `C_ON_PREM_VERSION` | `/GOOG/SDK_VERSION` | Lowest On-premises Version | 1.5 | PUBLIC |
| `C_CLOUD_VERSION` | `/GOOG/SDK_VERSION` | Lowest Cloud Version | 1.0 | PUBLIC |

## Methods

For general information about a method in ABAP SDK for Google Cloud, see [API method](https://docs.cloud.google.com/sap/docs/abap-sdk/latest/developer#api_method).

### CONSTRUCTOR

- Description: Constructor
- Visibility: PUBLIC

#### Parameters

| Name | Category | Type | Description |
|---|---|---|---|
| `IV_KEY_NAME` | IMPORTING | `/GOOG/KEYNAME` | Google Cloud Key Name |
| `IV_LOG_OBJ` | IMPORTING | `BALOBJ_D` | Application log: Object name (Application code) |
| `IV_LOG_SUBOBJ` | IMPORTING | `BALSUBOBJ` | Application Log: Subobject |

#### Exception

| Name | Description |
|---|---|
| `/GOOG/CX_SDK` | ABAP SDK for Google Cloud: Exception Class |

### APPEND_VALUES

- Description: sheets.spreadsheets.values.append
- Visibility: PUBLIC

#### Parameters

| Name | Category | Type | Description |
|---|---|---|---|
| `IV_Q_INCLUDEVALUESINRESPONSE` | IMPORTING | `STRING` | includeValuesInResponse |
| `IV_Q_INSERTDATAOPTION` | IMPORTING | `STRING` | insertDataOption |
| `IV_Q_RESPONSEDATETIMERENDEROPT` | IMPORTING | `STRING` | responseDateTimeRenderOption |
| `IV_Q_RESPONSEVALUERENDEROPTION` | IMPORTING | `STRING` | responseValueRenderOption |
| `IV_Q_VALUEINPUTOPTION` | IMPORTING | `STRING` | valueInputOption |
| `IV_P_RANGE` | IMPORTING | `STRING` | range |
| `IV_P_SPREADSHEET_ID` | IMPORTING | `STRING` | spreadsheetId |
| `IS_INPUT` | IMPORTING | `TY_240` | ValueRange |
| `ES_RAW` | EXPORTING | `DATA` | Raw Output Data |
| `ES_OUTPUT` | EXPORTING | `TY_022` | AppendValuesResponse |
| `EV_RET_CODE` | EXPORTING | `I` | Return Code |
| `EV_ERR_TEXT` | EXPORTING | `STRING` | Error Text |
| `ES_ERR_RESP` | EXPORTING | `/GOOG/ERR_RESP` | Error Response |

#### Exception

| Name | Description |
|---|---|
| `/GOOG/CX_SDK` | ABAP SDK for Google Cloud: Exception Class |

### BATCH_CLEAR_BY_DATA_FILTER

- Description: sheets.spreadsheets.values.batchClearByDataFilter
- Visibility: PUBLIC

#### Parameters

| Name | Category | Type | Description |
|---|---|---|---|
| `IV_P_SPREADSHEET_ID` | IMPORTING | `STRING` | spreadsheetId |
| `IS_INPUT` | IMPORTING | `TY_034` | BatchClearValuesByDataFilterRequest |
| `ES_RAW` | EXPORTING | `DATA` | Raw Output Data |
| `ES_OUTPUT` | EXPORTING | `TY_035` | BatchClearValuesByDataFilterResponse |
| `EV_RET_CODE` | EXPORTING | `I` | Return Code |
| `EV_ERR_TEXT` | EXPORTING | `STRING` | Error Text |
| `ES_ERR_RESP` | EXPORTING | `/GOOG/ERR_RESP` | Error Response |

#### Exception

| Name | Description |
|---|---|
| `/GOOG/CX_SDK` | ABAP SDK for Google Cloud: Exception Class |

### BATCH_CLEAR_VALUES

- Description: sheets.spreadsheets.values.batchClear
- Visibility: PUBLIC

#### Parameters

| Name | Category | Type | Description |
|---|---|---|---|
| `IV_P_SPREADSHEET_ID` | IMPORTING | `STRING` | spreadsheetId |
| `IS_INPUT` | IMPORTING | `TY_036` | BatchClearValuesRequest |
| `ES_RAW` | EXPORTING | `DATA` | Raw Output Data |
| `ES_OUTPUT` | EXPORTING | `TY_037` | BatchClearValuesResponse |
| `EV_RET_CODE` | EXPORTING | `I` | Return Code |
| `EV_ERR_TEXT` | EXPORTING | `STRING` | Error Text |
| `ES_ERR_RESP` | EXPORTING | `/GOOG/ERR_RESP` | Error Response |

#### Exception

| Name | Description |
|---|---|
| `/GOOG/CX_SDK` | ABAP SDK for Google Cloud: Exception Class |

### BATCH_GET_BY_DATA_FILTER_VA

- Description: sheets.spreadsheets.values.batchGetByDataFilter
- Visibility: PUBLIC

#### Parameters

| Name | Category | Type | Description |
|---|---|---|---|
| `IV_P_SPREADSHEET_ID` | IMPORTING | `STRING` | spreadsheetId |
| `IS_INPUT` | IMPORTING | `TY_038` | BatchGetValuesByDataFilterRequest |
| `ES_RAW` | EXPORTING | `DATA` | Raw Output Data |
| `ES_OUTPUT` | EXPORTING | `TY_039` | BatchGetValuesByDataFilterResponse |
| `EV_RET_CODE` | EXPORTING | `I` | Return Code |
| `EV_ERR_TEXT` | EXPORTING | `STRING` | Error Text |
| `ES_ERR_RESP` | EXPORTING | `/GOOG/ERR_RESP` | Error Response |

#### Exception

| Name | Description |
|---|---|
| `/GOOG/CX_SDK` | ABAP SDK for Google Cloud: Exception Class |

### BATCH_GET_VALUES

- Description: sheets.spreadsheets.values.batchGet
- Visibility: PUBLIC

#### Parameters

| Name | Category | Type | Description |
|---|---|---|---|
| `IV_Q_DATETIMERENDEROPTION` | IMPORTING | `STRING` | dateTimeRenderOption |
| `IV_Q_MAJORDIMENSION` | IMPORTING | `STRING` | majorDimension |
| `IV_Q_RANGES` | IMPORTING | `STRING` | ranges |
| `IV_Q_VALUERENDEROPTION` | IMPORTING | `STRING` | valueRenderOption |
| `IV_P_SPREADSHEET_ID` | IMPORTING | `STRING` | spreadsheetId |
| `ES_RAW` | EXPORTING | `DATA` | Raw Output Data |
| `ES_OUTPUT` | EXPORTING | `TY_040` | BatchGetValuesResponse |
| `EV_RET_CODE` | EXPORTING | `I` | Return Code |
| `EV_ERR_TEXT` | EXPORTING | `STRING` | Error Text |
| `ES_ERR_RESP` | EXPORTING | `/GOOG/ERR_RESP` | Error Response |

#### Exception

| Name | Description |
|---|---|
| `/GOOG/CX_SDK` | ABAP SDK for Google Cloud: Exception Class |

### BATCH_UPDATE_BY_DATA_FILTER

- Description: sheets.spreadsheets.values.batchUpdateByDataFilter
- Visibility: PUBLIC

#### Parameters

| Name | Category | Type | Description |
|---|---|---|---|
| `IV_P_SPREADSHEET_ID` | IMPORTING | `STRING` | spreadsheetId |
| `IS_INPUT` | IMPORTING | `TY_043` | BatchUpdateValuesByDataFilterRequest |
| `ES_RAW` | EXPORTING | `DATA` | Raw Output Data |
| `ES_OUTPUT` | EXPORTING | `TY_044` | BatchUpdateValuesByDataFilterResponse |
| `EV_RET_CODE` | EXPORTING | `I` | Return Code |
| `EV_ERR_TEXT` | EXPORTING | `STRING` | Error Text |
| `ES_ERR_RESP` | EXPORTING | `/GOOG/ERR_RESP` | Error Response |

#### Exception

| Name | Description |
|---|---|
| `/GOOG/CX_SDK` | ABAP SDK for Google Cloud: Exception Class |

### BATCH_UPDATE_SPREADSHEETS

- Description: sheets.spreadsheets.batchUpdate
- Visibility: PUBLIC

#### Parameters

| Name | Category | Type | Description |
|---|---|---|---|
| `IV_P_SPREADSHEET_ID` | IMPORTING | `STRING` | spreadsheetId |
| `IS_INPUT` | IMPORTING | `TY_041` | BatchUpdateSpreadsheetRequest |
| `ES_RAW` | EXPORTING | `DATA` | Raw Output Data |
| `ES_OUTPUT` | EXPORTING | `TY_042` | BatchUpdateSpreadsheetResponse |
| `EV_RET_CODE` | EXPORTING | `I` | Return Code |
| `EV_ERR_TEXT` | EXPORTING | `STRING` | Error Text |
| `ES_ERR_RESP` | EXPORTING | `/GOOG/ERR_RESP` | Error Response |

#### Exception

| Name | Description |
|---|---|
| `/GOOG/CX_SDK` | ABAP SDK for Google Cloud: Exception Class |

### BATCH_UPDATE_VALUES

- Description: sheets.spreadsheets.values.batchUpdate
- Visibility: PUBLIC

#### Parameters

| Name | Category | Type | Description |
|---|---|---|---|
| `IV_P_SPREADSHEET_ID` | IMPORTING | `STRING` | spreadsheetId |
| `IS_INPUT` | IMPORTING | `TY_045` | BatchUpdateValuesRequest |
| `ES_RAW` | EXPORTING | `DATA` | Raw Output Data |
| `ES_OUTPUT` | EXPORTING | `TY_046` | BatchUpdateValuesResponse |
| `EV_RET_CODE` | EXPORTING | `I` | Return Code |
| `EV_ERR_TEXT` | EXPORTING | `STRING` | Error Text |
| `ES_ERR_RESP` | EXPORTING | `/GOOG/ERR_RESP` | Error Response |

#### Exception

| Name | Description |
|---|---|
| `/GOOG/CX_SDK` | ABAP SDK for Google Cloud: Exception Class |

### CLEAR_VALUES

- Description: sheets.spreadsheets.values.clear
- Visibility: PUBLIC

#### Parameters

| Name | Category | Type | Description |
|---|---|---|---|
| `IV_P_RANGE` | IMPORTING | `STRING` | range |
| `IV_P_SPREADSHEET_ID` | IMPORTING | `STRING` | spreadsheetId |
| `IS_INPUT` | IMPORTING | `DATA` | Input Data |
| `ES_RAW` | EXPORTING | `DATA` | Raw Output Data |
| `ES_OUTPUT` | EXPORTING | `TY_071` | ClearValuesResponse |
| `EV_RET_CODE` | EXPORTING | `I` | Return Code |
| `EV_ERR_TEXT` | EXPORTING | `STRING` | Error Text |
| `ES_ERR_RESP` | EXPORTING | `/GOOG/ERR_RESP` | Error Response |

#### Exception

| Name | Description |
|---|---|
| `/GOOG/CX_SDK` | ABAP SDK for Google Cloud: Exception Class |

### COPY_TO_SHEETS

- Description: sheets.spreadsheets.sheets.copyTo
- Visibility: PUBLIC

#### Parameters

| Name | Category | Type | Description |
|---|---|---|---|
| `IV_P_SHEET_ID` | IMPORTING | `STRING` | sheetId |
| `IV_P_SPREADSHEET_ID` | IMPORTING | `STRING` | spreadsheetId |
| `IS_INPUT` | IMPORTING | `TY_077` | CopySheetToAnotherSpreadsheetRequest |
| `ES_RAW` | EXPORTING | `DATA` | Raw Output Data |
| `ES_OUTPUT` | EXPORTING | `TY_196` | SheetProperties |
| `EV_RET_CODE` | EXPORTING | `I` | Return Code |
| `EV_ERR_TEXT` | EXPORTING | `STRING` | Error Text |
| `ES_ERR_RESP` | EXPORTING | `/GOOG/ERR_RESP` | Error Response |

#### Exception

| Name | Description |
|---|---|
| `/GOOG/CX_SDK` | ABAP SDK for Google Cloud: Exception Class |

### CREATE_SPREADSHEETS

- Description: sheets.spreadsheets.create
- Visibility: PUBLIC

#### Parameters

| Name | Category | Type | Description |
|---|---|---|---|
| `IS_INPUT` | IMPORTING | `TY_202` | Spreadsheet |
| `ES_RAW` | EXPORTING | `DATA` | Raw Output Data |
| `ES_OUTPUT` | EXPORTING | `TY_202` | Spreadsheet |
| `EV_RET_CODE` | EXPORTING | `I` | Return Code |
| `EV_ERR_TEXT` | EXPORTING | `STRING` | Error Text |
| `ES_ERR_RESP` | EXPORTING | `/GOOG/ERR_RESP` | Error Response |

#### Exception

| Name | Description |
|---|---|
| `/GOOG/CX_SDK` | ABAP SDK for Google Cloud: Exception Class |

### GET_BY_DATA_FILTER_SPREADSH

- Description: sheets.spreadsheets.getByDataFilter
- Visibility: PUBLIC

#### Parameters

| Name | Category | Type | Description |
|---|---|---|---|
| `IV_P_SPREADSHEET_ID` | IMPORTING | `STRING` | spreadsheetId |
| `IS_INPUT` | IMPORTING | `TY_141` | GetSpreadsheetByDataFilterRequest |
| `ES_RAW` | EXPORTING | `DATA` | Raw Output Data |
| `ES_OUTPUT` | EXPORTING | `TY_202` | Spreadsheet |
| `EV_RET_CODE` | EXPORTING | `I` | Return Code |
| `EV_ERR_TEXT` | EXPORTING | `STRING` | Error Text |
| `ES_ERR_RESP` | EXPORTING | `/GOOG/ERR_RESP` | Error Response |

#### Exception

| Name | Description |
|---|---|
| `/GOOG/CX_SDK` | ABAP SDK for Google Cloud: Exception Class |

### GET_DEVELOPER_METADATA

- Description: sheets.spreadsheets.developerMetadata.get
- Visibility: PUBLIC

#### Parameters

| Name | Category | Type | Description |
|---|---|---|---|
| `IV_P_METADATA_ID` | IMPORTING | `STRING` | metadataId |
| `IV_P_SPREADSHEET_ID` | IMPORTING | `STRING` | spreadsheetId |
| `ES_RAW` | EXPORTING | `DATA` | Raw Output Data |
| `ES_OUTPUT` | EXPORTING | `TY_120` | DeveloperMetadata |
| `EV_RET_CODE` | EXPORTING | `I` | Return Code |
| `EV_ERR_TEXT` | EXPORTING | `STRING` | Error Text |
| `ES_ERR_RESP` | EXPORTING | `/GOOG/ERR_RESP` | Error Response |

#### Exception

| Name | Description |
|---|---|
| `/GOOG/CX_SDK` | ABAP SDK for Google Cloud: Exception Class |

### GET_SPREADSHEETS

- Description: sheets.spreadsheets.get
- Visibility: PUBLIC

#### Parameters

| Name | Category | Type | Description |
|---|---|---|---|
| `IV_Q_INCLUDEGRIDDATA` | IMPORTING | `STRING` | includeGridData |
| `IV_Q_RANGES` | IMPORTING | `STRING` | ranges |
| `IV_P_SPREADSHEET_ID` | IMPORTING | `STRING` | spreadsheetId |
| `ES_RAW` | EXPORTING | `DATA` | Raw Output Data |
| `ES_OUTPUT` | EXPORTING | `TY_202` | Spreadsheet |
| `EV_RET_CODE` | EXPORTING | `I` | Return Code |
| `EV_ERR_TEXT` | EXPORTING | `STRING` | Error Text |
| `ES_ERR_RESP` | EXPORTING | `/GOOG/ERR_RESP` | Error Response |

#### Exception

| Name | Description |
|---|---|
| `/GOOG/CX_SDK` | ABAP SDK for Google Cloud: Exception Class |

### GET_VALUES

- Description: sheets.spreadsheets.values.get
- Visibility: PUBLIC

#### Parameters

| Name | Category | Type | Description |
|---|---|---|---|
| `IV_Q_DATETIMERENDEROPTION` | IMPORTING | `STRING` | dateTimeRenderOption |
| `IV_Q_MAJORDIMENSION` | IMPORTING | `STRING` | majorDimension |
| `IV_Q_VALUERENDEROPTION` | IMPORTING | `STRING` | valueRenderOption |
| `IV_P_RANGE` | IMPORTING | `STRING` | range |
| `IV_P_SPREADSHEET_ID` | IMPORTING | `STRING` | spreadsheetId |
| `ES_RAW` | EXPORTING | `DATA` | Raw Output Data |
| `ES_OUTPUT` | EXPORTING | `TY_240` | ValueRange |
| `EV_RET_CODE` | EXPORTING | `I` | Return Code |
| `EV_ERR_TEXT` | EXPORTING | `STRING` | Error Text |
| `ES_ERR_RESP` | EXPORTING | `/GOOG/ERR_RESP` | Error Response |

#### Exception

| Name | Description |
|---|---|
| `/GOOG/CX_SDK` | ABAP SDK for Google Cloud: Exception Class |

### SEARCH_DEVELOPER_METADATA

- Description: sheets.spreadsheets.developerMetadata.search
- Visibility: PUBLIC

#### Parameters

| Name | Category | Type | Description |
|---|---|---|---|
| `IV_P_SPREADSHEET_ID` | IMPORTING | `STRING` | spreadsheetId |
| `IS_INPUT` | IMPORTING | `TY_191` | SearchDeveloperMetadataRequest |
| `ES_RAW` | EXPORTING | `DATA` | Raw Output Data |
| `ES_OUTPUT` | EXPORTING | `TY_192` | SearchDeveloperMetadataResponse |
| `EV_RET_CODE` | EXPORTING | `I` | Return Code |
| `EV_ERR_TEXT` | EXPORTING | `STRING` | Error Text |
| `ES_ERR_RESP` | EXPORTING | `/GOOG/ERR_RESP` | Error Response |

#### Exception

| Name | Description |
|---|---|
| `/GOOG/CX_SDK` | ABAP SDK for Google Cloud: Exception Class |

### UPDATE_VALUES

- Description: sheets.spreadsheets.values.update
- Visibility: PUBLIC

#### Parameters

| Name | Category | Type | Description |
|---|---|---|---|
| `IV_Q_INCLUDEVALUESINRESPONSE` | IMPORTING | `STRING` | includeValuesInResponse |
| `IV_Q_RESPONSEDATETIMERENDEROPT` | IMPORTING | `STRING` | responseDateTimeRenderOption |
| `IV_Q_RESPONSEVALUERENDEROPTION` | IMPORTING | `STRING` | responseValueRenderOption |
| `IV_Q_VALUEINPUTOPTION` | IMPORTING | `STRING` | valueInputOption |
| `IV_P_RANGE` | IMPORTING | `STRING` | range |
| `IV_P_SPREADSHEET_ID` | IMPORTING | `STRING` | spreadsheetId |
| `IS_INPUT` | IMPORTING | `TY_240` | ValueRange |
| `ES_RAW` | EXPORTING | `DATA` | Raw Output Data |
| `ES_OUTPUT` | EXPORTING | `TY_239` | UpdateValuesResponse |
| `EV_RET_CODE` | EXPORTING | `I` | Return Code |
| `EV_ERR_TEXT` | EXPORTING | `STRING` | Error Text |
| `ES_ERR_RESP` | EXPORTING | `/GOOG/ERR_RESP` | Error Response |

#### Exception

| Name | Description |
|---|---|
| `/GOOG/CX_SDK` | ABAP SDK for Google Cloud: Exception Class |

### CLOSE

- Description: Close Connection
- Visibility: PUBLIC