Module: Google::Apis::SheetsV4

Defined in:: lib/google/apis/sheets_v4.rb,
lib/google/apis/sheets_v4/classes.rb,
lib/google/apis/sheets_v4/service.rb,
lib/google/apis/sheets_v4/gem_version.rb,
lib/google/apis/sheets_v4/representations.rb

Overview

Google Sheets API

Reads and writes Google Sheets.

See Also:

https://developers.google.com/sheets/

Defined Under Namespace

Classes: 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, SheetsService, 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

Constant Summary collapse

GEM_VERSION = Version of the google-apis-sheets_v4 gem

"0.11.0"

GENERATOR_VERSION = Version of the code generator used to generate this client

"0.4.0"

REVISION = Revision of the discovery document this client was generated from

"20210629"

VERSION = Version of the Google Sheets API this client connects to. This is NOT the gem version.

'V4'

AUTH_DRIVE = See, edit, create, and delete all of your Google Drive files

'https://www.googleapis.com/auth/drive'

AUTH_DRIVE_FILE = See, edit, create, and delete only the specific Google Drive files you use with this app

'https://www.googleapis.com/auth/drive.file'

AUTH_DRIVE_READONLY = See and download all your Google Drive files

'https://www.googleapis.com/auth/drive.readonly'

AUTH_SPREADSHEETS = See, edit, create, and delete all your Google Sheets spreadsheets

'https://www.googleapis.com/auth/spreadsheets'

AUTH_SPREADSHEETS_READONLY = See all your Google Sheets spreadsheets

'https://www.googleapis.com/auth/spreadsheets.readonly'