A single kind of update to apply to a spreadsheet.

Attributes

• updateChartSpec (type: GoogleApi.Sheets.V4.Model.UpdateChartSpecRequest.t, default: nil) - Updates a chart's specifications.
• setBasicFilter (type: GoogleApi.Sheets.V4.Model.SetBasicFilterRequest.t, default: nil) - Sets the basic filter on a sheet.
• addConditionalFormatRule (type: GoogleApi.Sheets.V4.Model.AddConditionalFormatRuleRequest.t, default: nil) - Adds a new conditional format rule.
• addNamedRange (type: GoogleApi.Sheets.V4.Model.AddNamedRangeRequest.t, default: nil) - Adds a named range.
• setDataValidation (type: GoogleApi.Sheets.V4.Model.SetDataValidationRequest.t, default: nil) - Sets data validation for one or more cells.
• updateDimensionProperties (type: GoogleApi.Sheets.V4.Model.UpdateDimensionPropertiesRequest.t, default: nil) - Updates dimensions' properties.
• updateDimensionGroup (type: GoogleApi.Sheets.V4.Model.UpdateDimensionGroupRequest.t, default: nil) - Updates the state of the specified group.
• appendDimension (type: GoogleApi.Sheets.V4.Model.AppendDimensionRequest.t, default: nil) - Appends dimensions to the end of a sheet.
• duplicateFilterView (type: GoogleApi.Sheets.V4.Model.DuplicateFilterViewRequest.t, default: nil) - Duplicates a filter view.
• updateEmbeddedObjectPosition (type: GoogleApi.Sheets.V4.Model.UpdateEmbeddedObjectPositionRequest.t, default: nil) - Updates an embedded object's (e.g. chart, image) position.
• deleteBanding (type: GoogleApi.Sheets.V4.Model.DeleteBandingRequest.t, default: nil) - Removes a banded range
• addSlicer (type: GoogleApi.Sheets.V4.Model.AddSlicerRequest.t, default: nil) - Adds a slicer.
• updateSlicerSpec (type: GoogleApi.Sheets.V4.Model.UpdateSlicerSpecRequest.t, default: nil) - Updates a slicer's specifications.
• deleteRange (type: GoogleApi.Sheets.V4.Model.DeleteRangeRequest.t, default: nil) - Deletes a range of cells from a sheet, shifting the remaining cells.
• trimWhitespace (type: GoogleApi.Sheets.V4.Model.TrimWhitespaceRequest.t, default: nil) - Trims cells of whitespace (such as spaces, tabs, or new lines).
• deleteDeveloperMetadata (type: GoogleApi.Sheets.V4.Model.DeleteDeveloperMetadataRequest.t, default: nil) - Deletes developer metadata
• randomizeRange (type: GoogleApi.Sheets.V4.Model.RandomizeRangeRequest.t, default: nil) - Randomizes the order of the rows in a range.
• appendCells (type: GoogleApi.Sheets.V4.Model.AppendCellsRequest.t, default: nil) - Appends cells after the last row with data in a sheet.
• updateCells (type: GoogleApi.Sheets.V4.Model.UpdateCellsRequest.t, default: nil) - Updates many cells at once.
• addBanding (type: GoogleApi.Sheets.V4.Model.AddBandingRequest.t, default: nil) - Adds a new banded range
• deleteEmbeddedObject (type: GoogleApi.Sheets.V4.Model.DeleteEmbeddedObjectRequest.t, default: nil) - Deletes an embedded object (e.g, chart, image) in a sheet.
• findReplace (type: GoogleApi.Sheets.V4.Model.FindReplaceRequest.t, default: nil) - Finds and replaces occurrences of some text with other text.
• cutPaste (type: GoogleApi.Sheets.V4.Model.CutPasteRequest.t, default: nil) - Cuts data from one area and pastes it to another.
• updateProtectedRange (type: GoogleApi.Sheets.V4.Model.UpdateProtectedRangeRequest.t, default: nil) - Updates a protected range.
• deleteSheet (type: GoogleApi.Sheets.V4.Model.DeleteSheetRequest.t, default: nil) - Deletes a sheet.
• updateNamedRange (type: GoogleApi.Sheets.V4.Model.UpdateNamedRangeRequest.t, default: nil) - Updates a named range.
• addProtectedRange (type: GoogleApi.Sheets.V4.Model.AddProtectedRangeRequest.t, default: nil) - Adds a protected range.
• deleteDimension (type: GoogleApi.Sheets.V4.Model.DeleteDimensionRequest.t, default: nil) - Deletes rows or columns in a sheet.
• deleteDimensionGroup (type: GoogleApi.Sheets.V4.Model.DeleteDimensionGroupRequest.t, default: nil) - Deletes a group over the specified range.
• updateSheetProperties (type: GoogleApi.Sheets.V4.Model.UpdateSheetPropertiesRequest.t, default: nil) - Updates a sheet's properties.
• repeatCell (type: GoogleApi.Sheets.V4.Model.RepeatCellRequest.t, default: nil) - Repeats a single cell across a range.
• deleteConditionalFormatRule (type: GoogleApi.Sheets.V4.Model.DeleteConditionalFormatRuleRequest.t, default: nil) - Deletes an existing conditional format rule.
• updateFilterView (type: GoogleApi.Sheets.V4.Model.UpdateFilterViewRequest.t, default: nil) - Updates the properties of a filter view.
• copyPaste (type: GoogleApi.Sheets.V4.Model.CopyPasteRequest.t, default: nil) - Copies data from one area and pastes it to another.
• unmergeCells (type: GoogleApi.Sheets.V4.Model.UnmergeCellsRequest.t, default: nil) - Unmerges merged cells.
• createDeveloperMetadata (type: GoogleApi.Sheets.V4.Model.CreateDeveloperMetadataRequest.t, default: nil) - Creates new developer metadata
• updateSpreadsheetProperties (type: GoogleApi.Sheets.V4.Model.UpdateSpreadsheetPropertiesRequest.t, default: nil) - Updates the spreadsheet's properties.
• autoFill (type: GoogleApi.Sheets.V4.Model.AutoFillRequest.t, default: nil) - Automatically fills in more data based on existing data.
• sortRange (type: GoogleApi.Sheets.V4.Model.SortRangeRequest.t, default: nil) - Sorts data in a range.
• deleteDuplicates (type: GoogleApi.Sheets.V4.Model.DeleteDuplicatesRequest.t, default: nil) - Removes rows containing duplicate values in specified columns of a cell range.
• addFilterView (type: GoogleApi.Sheets.V4.Model.AddFilterViewRequest.t, default: nil) - Adds a filter view.
• mergeCells (type: GoogleApi.Sheets.V4.Model.MergeCellsRequest.t, default: nil) - Merges cells together.
• insertRange (type: GoogleApi.Sheets.V4.Model.InsertRangeRequest.t, default: nil) - Inserts new cells in a sheet, shifting the existing cells.
• addChart (type: GoogleApi.Sheets.V4.Model.AddChartRequest.t, default: nil) - Adds a chart.
• updateConditionalFormatRule (type: GoogleApi.Sheets.V4.Model.UpdateConditionalFormatRuleRequest.t, default: nil) - Updates an existing conditional format rule.
• deleteNamedRange (type: GoogleApi.Sheets.V4.Model.DeleteNamedRangeRequest.t, default: nil) - Deletes a named range.
• insertDimension (type: GoogleApi.Sheets.V4.Model.InsertDimensionRequest.t, default: nil) - Inserts new rows or columns in a sheet.
• updateDeveloperMetadata (type: GoogleApi.Sheets.V4.Model.UpdateDeveloperMetadataRequest.t, default: nil) - Updates an existing developer metadata entry
• addDimensionGroup (type: GoogleApi.Sheets.V4.Model.AddDimensionGroupRequest.t, default: nil) - Creates a group over the specified range.
• textToColumns (type: GoogleApi.Sheets.V4.Model.TextToColumnsRequest.t, default: nil) - Converts a column of text into many columns of text.
• deleteFilterView (type: GoogleApi.Sheets.V4.Model.DeleteFilterViewRequest.t, default: nil) - Deletes a filter view from a sheet.
• updateBorders (type: GoogleApi.Sheets.V4.Model.UpdateBordersRequest.t, default: nil) - Updates the borders in a range of cells.
• pasteData (type: GoogleApi.Sheets.V4.Model.PasteDataRequest.t, default: nil) - Pastes data (HTML or delimited) into a sheet.
• moveDimension (type: GoogleApi.Sheets.V4.Model.MoveDimensionRequest.t, default: nil) - Moves rows or columns to another location in a sheet.
• addSheet (type: GoogleApi.Sheets.V4.Model.AddSheetRequest.t, default: nil) - Adds a sheet.
• updateBanding (type: GoogleApi.Sheets.V4.Model.UpdateBandingRequest.t, default: nil) - Updates a banded range
• clearBasicFilter (type: GoogleApi.Sheets.V4.Model.ClearBasicFilterRequest.t, default: nil) - Clears the basic filter on a sheet.
• deleteProtectedRange (type: GoogleApi.Sheets.V4.Model.DeleteProtectedRangeRequest.t, default: nil) - Deletes a protected range.
• duplicateSheet (type: GoogleApi.Sheets.V4.Model.DuplicateSheetRequest.t, default: nil) - Duplicates a sheet.
• autoResizeDimensions (type: GoogleApi.Sheets.V4.Model.AutoResizeDimensionsRequest.t, default: nil) - Automatically resizes one or more dimensions based on the contents of the cells in that dimension.