Module: Google::Apis::SheetsV4

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

Overview

Google Sheets API

Reads and writes Google Sheets.

Defined Under Namespace

Classes: AddBandingRequest, AddBandingResponse, AddChartRequest, AddChartResponse, AddConditionalFormatRuleRequest, 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, BatchClearValuesByDataFilterRequest, BatchClearValuesByDataFilterResponse, BatchClearValuesRequest, BatchClearValuesResponse, BatchGetValuesByDataFilterRequest, BatchGetValuesByDataFilterResponse, BatchGetValuesResponse, BatchUpdateSpreadsheetRequest, BatchUpdateSpreadsheetResponse, BatchUpdateValuesByDataFilterRequest, BatchUpdateValuesByDataFilterResponse, BatchUpdateValuesRequest, BatchUpdateValuesResponse, BooleanCondition, BooleanRule, Border, Borders, BubbleChartSpec, CandlestickChartSpec, CandlestickData, CandlestickDomain, CandlestickSeries, CellData, CellFormat, ChartAxisViewWindowOptions, ChartCustomNumberFormatOptions, ChartData, ChartSourceRange, ChartSpec, ClearBasicFilterRequest, ClearValuesRequest, ClearValuesResponse, Color, ColorStyle, ConditionValue, ConditionalFormatRule, CopyPasteRequest, CopySheetToAnotherSpreadsheetRequest, CreateDeveloperMetadataRequest, CreateDeveloperMetadataResponse, CutPasteRequest, DataFilter, DataFilterValueRange, DataValidationRule, DateTimeRule, DeleteBandingRequest, DeleteConditionalFormatRuleRequest, DeleteConditionalFormatRuleResponse, 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, EmbeddedObjectPosition, ErrorValue, ExtendedValue, FilterCriteria, FilterView, FindReplaceRequest, FindReplaceResponse, GetSpreadsheetByDataFilterRequest, GradientRule, GridCoordinate, GridData, GridProperties, GridRange, HistogramChartSpec, HistogramRule, HistogramSeries, InsertDimensionRequest, InsertRangeRequest, InterpolationPoint, IterativeCalculationSettings, KeyValueFormat, LineStyle, ManualRule, ManualRuleGroup, MatchedDeveloperMetadata, MatchedValueRange, MergeCellsRequest, MoveDimensionRequest, NamedRange, NumberFormat, OrgChartSpec, OverlayPosition, Padding, PasteDataRequest, PieChartSpec, PivotFilterCriteria, PivotGroup, PivotGroupRule, PivotGroupSortValueBucket, PivotGroupValueMetadata, PivotTable, PivotValue, ProtectedRange, RandomizeRangeRequest, 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, TreemapChartColorScale, TreemapChartSpec, TrimWhitespaceRequest, TrimWhitespaceResponse, UnmergeCellsRequest, UpdateBandingRequest, UpdateBordersRequest, UpdateCellsRequest, UpdateChartSpecRequest, UpdateConditionalFormatRuleRequest, UpdateConditionalFormatRuleResponse, UpdateDeveloperMetadataRequest, UpdateDeveloperMetadataResponse, UpdateDimensionGroupRequest, UpdateDimensionPropertiesRequest, UpdateEmbeddedObjectPositionRequest, UpdateEmbeddedObjectPositionResponse, UpdateFilterViewRequest, UpdateNamedRangeRequest, UpdateProtectedRangeRequest, UpdateSheetPropertiesRequest, UpdateSlicerSpecRequest, UpdateSpreadsheetPropertiesRequest, UpdateValuesByDataFilterResponse, UpdateValuesResponse, ValueRange, WaterfallChartColumnStyle, WaterfallChartCustomSubtotal, WaterfallChartDomain, WaterfallChartSeries, WaterfallChartSpec

Constant Summary collapse

VERSION =
'V4'
REVISION =
'20200707'
AUTH_DRIVE =

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

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

View and manage Google Drive files and folders that you have opened or created 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 your spreadsheets in Google Drive

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

View your Google Spreadsheets

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