// Type definitions for Google Apps Script 2019-03-25
// Project: https://developers.google.com/apps-script/
// Generator: https://github.com/grant/google-apps-script-dts
// Definitions: https://github.com/DefinitelyTyped/DefinitelyTyped

declare namespace GoogleAppsScript {
  namespace Sheets {
    namespace Collection {
      namespace Spreadsheets {
        interface DeveloperMetadataCollection {
          // Returns the developer metadata with the specified ID.
          // The caller must specify the spreadsheet ID and the developer metadata's
          // unique metadataId.
          get(spreadsheetId: string, metadataId: number): Sheets.Schema.DeveloperMetadata;
          // Returns all developer metadata matching the specified DataFilter.
          // If the provided DataFilter represents a DeveloperMetadataLookup object,
          // this will return all DeveloperMetadata entries selected by it. If the
          // DataFilter represents a location in a spreadsheet, this will return all
          // developer metadata associated with locations intersecting that region.
          search(resource: Schema.SearchDeveloperMetadataRequest, spreadsheetId: string): Sheets.Schema.SearchDeveloperMetadataResponse;
        }
        interface SheetsCollection {
          // Copies a single sheet from a spreadsheet to another spreadsheet.
          // Returns the properties of the newly created sheet.
          copyTo(resource: Schema.CopySheetToAnotherSpreadsheetRequest, spreadsheetId: string, sheetId: number): Sheets.Schema.SheetProperties;
        }
        interface ValuesCollection {
          // Appends values to a spreadsheet. The input range is used to search for
          // existing data and find a "table" within that range. Values will be
          // appended to the next row of the table, starting with the first column of
          // the table. See the
          // [guide](/sheets/api/guides/values#appending_values)
          // and
          // [sample code](/sheets/api/samples/writing#append_values)
          // for specific details of how tables are detected and data is appended.
          // The caller must specify the spreadsheet ID, range, and
          // a valueInputOption.  The `valueInputOption` only
          // controls how the input data will be added to the sheet (column-wise or
          // row-wise), it does not influence what cell the data starts being written
          // to.
          append(resource: Schema.ValueRange, spreadsheetId: string, range: string): Sheets.Schema.AppendValuesResponse;
          // Appends values to a spreadsheet. The input range is used to search for
          // existing data and find a "table" within that range. Values will be
          // appended to the next row of the table, starting with the first column of
          // the table. See the
          // [guide](/sheets/api/guides/values#appending_values)
          // and
          // [sample code](/sheets/api/samples/writing#append_values)
          // for specific details of how tables are detected and data is appended.
          // The caller must specify the spreadsheet ID, range, and
          // a valueInputOption.  The `valueInputOption` only
          // controls how the input data will be added to the sheet (column-wise or
          // row-wise), it does not influence what cell the data starts being written
          // to.
          append(resource: Schema.ValueRange, spreadsheetId: string, range: string, optionalArgs: object): Sheets.Schema.AppendValuesResponse;
          // Clears one or more ranges of values from a spreadsheet.
          // The caller must specify the spreadsheet ID and one or more ranges.
          // Only values are cleared -- all other properties of the cell (such as
          // formatting, data validation, etc..) are kept.
          batchClear(resource: Schema.BatchClearValuesRequest, spreadsheetId: string): Sheets.Schema.BatchClearValuesResponse;
          // Clears one or more ranges of values from a spreadsheet.
          // The caller must specify the spreadsheet ID and one or more
          // DataFilters. Ranges matching any of the specified data
          // filters will be cleared.  Only values are cleared -- all other properties
          // of the cell (such as formatting, data validation, etc..) are kept.
          batchClearByDataFilter(resource: Schema.BatchClearValuesByDataFilterRequest, spreadsheetId: string): Sheets.Schema.BatchClearValuesByDataFilterResponse;
          // Returns one or more ranges of values from a spreadsheet.
          // The caller must specify the spreadsheet ID and one or more ranges.
          batchGet(spreadsheetId: string): Sheets.Schema.BatchGetValuesResponse;
          // Returns one or more ranges of values from a spreadsheet.
          // The caller must specify the spreadsheet ID and one or more ranges.
          batchGet(spreadsheetId: string, optionalArgs: object): Sheets.Schema.BatchGetValuesResponse;
          // Returns one or more ranges of values that match the specified data filters.
          // The caller must specify the spreadsheet ID and one or more
          // DataFilters.  Ranges that match any of the data filters in
          // the request will be returned.
          batchGetByDataFilter(resource: Schema.BatchGetValuesByDataFilterRequest, spreadsheetId: string): Sheets.Schema.BatchGetValuesByDataFilterResponse;
          // Sets values in one or more ranges of a spreadsheet.
          // The caller must specify the spreadsheet ID,
          // a valueInputOption, and one or more
          // ValueRanges.
          batchUpdate(resource: Schema.BatchUpdateValuesRequest, spreadsheetId: string): Sheets.Schema.BatchUpdateValuesResponse;
          // Sets values in one or more ranges of a spreadsheet.
          // The caller must specify the spreadsheet ID,
          // a valueInputOption, and one or more
          // DataFilterValueRanges.
          batchUpdateByDataFilter(resource: Schema.BatchUpdateValuesByDataFilterRequest, spreadsheetId: string): Sheets.Schema.BatchUpdateValuesByDataFilterResponse;
          // Clears values from a spreadsheet.
          // The caller must specify the spreadsheet ID and range.
          // Only values are cleared -- all other properties of the cell (such as
          // formatting, data validation, etc..) are kept.
          clear(resource: any, /* Schema.ClearValuesRequest */ spreadsheetId: string, range: string): Sheets.Schema.ClearValuesResponse;
          // Returns a range of values from a spreadsheet.
          // The caller must specify the spreadsheet ID and a range.
          get(spreadsheetId: string, range: string): Sheets.Schema.ValueRange;
          // Returns a range of values from a spreadsheet.
          // The caller must specify the spreadsheet ID and a range.
          get(spreadsheetId: string, range: string, optionalArgs: object): Sheets.Schema.ValueRange;
          // Sets values in a range of a spreadsheet.
          // The caller must specify the spreadsheet ID, range, and
          // a valueInputOption.
          update(resource: Schema.ValueRange, spreadsheetId: string, range: string): Sheets.Schema.UpdateValuesResponse;
          // Sets values in a range of a spreadsheet.
          // The caller must specify the spreadsheet ID, range, and
          // a valueInputOption.
          update(resource: Schema.ValueRange, spreadsheetId: string, range: string, optionalArgs: object): Sheets.Schema.UpdateValuesResponse;
        }
      }
      interface SpreadsheetsCollection {
        DeveloperMetadata?: Sheets.Collection.Spreadsheets.DeveloperMetadataCollection | undefined;
        Sheets?: Sheets.Collection.Spreadsheets.SheetsCollection | undefined;
        Values?: Sheets.Collection.Spreadsheets.ValuesCollection | undefined;
        // Applies one or more updates to the spreadsheet.
        // Each request is validated before
        // being applied. If any request is not valid then the entire request will
        // fail and nothing will be applied.
        // Some requests have replies to
        // give you some information about how
        // they are applied. The replies will mirror the requests.  For example,
        // if you applied 4 updates and the 3rd one had a reply, then the
        // response will have 2 empty replies, the actual reply, and another empty
        // reply, in that order.
        // Due to the collaborative nature of spreadsheets, it is not guaranteed that
        // the spreadsheet will reflect exactly your changes after this completes,
        // however it is guaranteed that the updates in the request will be
        // applied together atomically. Your changes may be altered with respect to
        // collaborator changes. If there are no collaborators, the spreadsheet
        // should reflect your changes.
        batchUpdate(resource: Schema.BatchUpdateSpreadsheetRequest, spreadsheetId: string): Sheets.Schema.BatchUpdateSpreadsheetResponse;
        // Creates a spreadsheet, returning the newly created spreadsheet.
        create(resource: Schema.Spreadsheet): Sheets.Schema.Spreadsheet;
        // Returns the spreadsheet at the given ID.
        // The caller must specify the spreadsheet ID.
        // By default, data within grids will not be returned.
        // You can include grid data one of two ways:
        // * Specify a field mask listing your desired fields using the `fields` URL
        // parameter in HTTP
        // * Set the includeGridData
        // URL parameter to true.  If a field mask is set, the `includeGridData`
        // parameter is ignored
        // For large spreadsheets, it is recommended to retrieve only the specific
        // fields of the spreadsheet that you want.
        // To retrieve only subsets of the spreadsheet, use the
        // ranges URL parameter.
        // Multiple ranges can be specified.  Limiting the range will
        // return only the portions of the spreadsheet that intersect the requested
        // ranges. Ranges are specified using A1 notation.
        get(spreadsheetId: string): Sheets.Schema.Spreadsheet;
        // Returns the spreadsheet at the given ID.
        // The caller must specify the spreadsheet ID.
        // By default, data within grids will not be returned.
        // You can include grid data one of two ways:
        // * Specify a field mask listing your desired fields using the `fields` URL
        // parameter in HTTP
        // * Set the includeGridData
        // URL parameter to true.  If a field mask is set, the `includeGridData`
        // parameter is ignored
        // For large spreadsheets, it is recommended to retrieve only the specific
        // fields of the spreadsheet that you want.
        // To retrieve only subsets of the spreadsheet, use the
        // ranges URL parameter.
        // Multiple ranges can be specified.  Limiting the range will
        // return only the portions of the spreadsheet that intersect the requested
        // ranges. Ranges are specified using A1 notation.
        get(spreadsheetId: string, optionalArgs: object): Sheets.Schema.Spreadsheet;
        // Returns the spreadsheet at the given ID.
        // The caller must specify the spreadsheet ID.
        // This method differs from GetSpreadsheet in that it allows selecting
        // which subsets of spreadsheet data to return by specifying a
        // dataFilters parameter.
        // Multiple DataFilters can be specified.  Specifying one or
        // more data filters will return the portions of the spreadsheet that
        // intersect ranges matched by any of the filters.
        // By default, data within grids will not be returned.
        // You can include grid data one of two ways:
        // * Specify a field mask listing your desired fields using the `fields` URL
        // parameter in HTTP
        // * Set the includeGridData
        // parameter to true.  If a field mask is set, the `includeGridData`
        // parameter is ignored
        // For large spreadsheets, it is recommended to retrieve only the specific
        // fields of the spreadsheet that you want.
        getByDataFilter(resource: Schema.GetSpreadsheetByDataFilterRequest, spreadsheetId: string): Sheets.Schema.Spreadsheet;
      }
    }
    namespace Schema {
      interface AddBandingRequest {
        bandedRange?: Sheets.Schema.BandedRange | undefined;
      }
      interface AddBandingResponse {
        bandedRange?: Sheets.Schema.BandedRange | undefined;
      }
      interface AddChartRequest {
        chart?: Sheets.Schema.EmbeddedChart | undefined;
      }
      interface AddChartResponse {
        chart?: Sheets.Schema.EmbeddedChart | undefined;
      }
      interface AddConditionalFormatRuleRequest {
        index?: number | undefined;
        rule?: Sheets.Schema.ConditionalFormatRule | undefined;
      }
      interface AddDimensionGroupRequest {
        range?: Sheets.Schema.DimensionRange | undefined;
      }
      interface AddDimensionGroupResponse {
        dimensionGroups?: Sheets.Schema.DimensionGroup[] | undefined;
      }
      interface AddFilterViewRequest {
        filter?: Sheets.Schema.FilterView | undefined;
      }
      interface AddFilterViewResponse {
        filter?: Sheets.Schema.FilterView | undefined;
      }
      interface AddNamedRangeRequest {
        namedRange?: Sheets.Schema.NamedRange | undefined;
      }
      interface AddNamedRangeResponse {
        namedRange?: Sheets.Schema.NamedRange | undefined;
      }
      interface AddProtectedRangeRequest {
        protectedRange?: Sheets.Schema.ProtectedRange | undefined;
      }
      interface AddProtectedRangeResponse {
        protectedRange?: Sheets.Schema.ProtectedRange | undefined;
      }
      interface AddSheetRequest {
        properties?: Sheets.Schema.SheetProperties | undefined;
      }
      interface AddSheetResponse {
        properties?: Sheets.Schema.SheetProperties | undefined;
      }
      interface AppendCellsRequest {
        fields?: string | undefined;
        rows?: Sheets.Schema.RowData[] | undefined;
        sheetId?: number | undefined;
      }
      interface AppendDimensionRequest {
        dimension?: string | undefined;
        length?: number | undefined;
        sheetId?: number | undefined;
      }
      interface AppendValuesResponse {
        spreadsheetId?: string | undefined;
        tableRange?: string | undefined;
        updates?: Sheets.Schema.UpdateValuesResponse | undefined;
      }
      interface AutoFillRequest {
        range?: Sheets.Schema.GridRange | undefined;
        sourceAndDestination?: Sheets.Schema.SourceAndDestination | undefined;
        useAlternateSeries?: boolean | undefined;
      }
      interface AutoResizeDimensionsRequest {
        dimensions?: Sheets.Schema.DimensionRange | undefined;
      }
      interface BandedRange {
        bandedRangeId?: number | undefined;
        columnProperties?: Sheets.Schema.BandingProperties | undefined;
        range?: Sheets.Schema.GridRange | undefined;
        rowProperties?: Sheets.Schema.BandingProperties | undefined;
      }
      interface BandingProperties {
        firstBandColor?: Sheets.Schema.Color | undefined;
        footerColor?: Sheets.Schema.Color | undefined;
        headerColor?: Sheets.Schema.Color | undefined;
        secondBandColor?: Sheets.Schema.Color | undefined;
      }
      interface BasicChartAxis {
        format?: Sheets.Schema.TextFormat | undefined;
        position?: string | undefined;
        title?: string | undefined;
        titleTextPosition?: Sheets.Schema.TextPosition | undefined;
      }
      interface BasicChartDomain {
        domain?: Sheets.Schema.ChartData | undefined;
        reversed?: boolean | undefined;
      }
      interface BasicChartSeries {
        color?: Sheets.Schema.Color | undefined;
        lineStyle?: Sheets.Schema.LineStyle | undefined;
        series?: Sheets.Schema.ChartData | undefined;
        targetAxis?: string | undefined;
        type?: string | undefined;
      }
      interface BasicChartSpec {
        axis?: Sheets.Schema.BasicChartAxis[] | undefined;
        chartType?: string | undefined;
        compareMode?: string | undefined;
        domains?: Sheets.Schema.BasicChartDomain[] | undefined;
        headerCount?: number | undefined;
        interpolateNulls?: boolean | undefined;
        legendPosition?: string | undefined;
        lineSmoothing?: boolean | undefined;
        series?: Sheets.Schema.BasicChartSeries[] | undefined;
        stackedType?: string | undefined;
        threeDimensional?: boolean | undefined;
      }
      interface BasicFilter {
        criteria?: object | undefined;
        range?: Sheets.Schema.GridRange | undefined;
        sortSpecs?: Sheets.Schema.SortSpec[] | undefined;
      }
      interface BatchClearValuesByDataFilterRequest {
        dataFilters?: Sheets.Schema.DataFilter[] | undefined;
      }
      interface BatchClearValuesByDataFilterResponse {
        clearedRanges?: string[] | undefined;
        spreadsheetId?: string | undefined;
      }
      interface BatchClearValuesRequest {
        ranges?: string[] | undefined;
      }
      interface BatchClearValuesResponse {
        clearedRanges?: string[] | undefined;
        spreadsheetId?: string | undefined;
      }
      interface BatchGetValuesByDataFilterRequest {
        dataFilters?: Sheets.Schema.DataFilter[] | undefined;
        dateTimeRenderOption?: string | undefined;
        majorDimension?: string | undefined;
        valueRenderOption?: string | undefined;
      }
      interface BatchGetValuesByDataFilterResponse {
        spreadsheetId?: string | undefined;
        valueRanges?: Sheets.Schema.MatchedValueRange[] | undefined;
      }
      interface BatchGetValuesResponse {
        spreadsheetId?: string | undefined;
        valueRanges?: Sheets.Schema.ValueRange[] | undefined;
      }
      interface BatchUpdateSpreadsheetRequest {
        includeSpreadsheetInResponse?: boolean | undefined;
        requests?: Sheets.Schema.Request[] | undefined;
        responseIncludeGridData?: boolean | undefined;
        responseRanges?: string[] | undefined;
      }
      interface BatchUpdateSpreadsheetResponse {
        replies?: Sheets.Schema.Response[] | undefined;
        spreadsheetId?: string | undefined;
        updatedSpreadsheet?: Sheets.Schema.Spreadsheet | undefined;
      }
      interface BatchUpdateValuesByDataFilterRequest {
        data?: Sheets.Schema.DataFilterValueRange[] | undefined;
        includeValuesInResponse?: boolean | undefined;
        responseDateTimeRenderOption?: string | undefined;
        responseValueRenderOption?: string | undefined;
        valueInputOption?: string | undefined;
      }
      interface BatchUpdateValuesByDataFilterResponse {
        responses?: Sheets.Schema.UpdateValuesByDataFilterResponse[] | undefined;
        spreadsheetId?: string | undefined;
        totalUpdatedCells?: number | undefined;
        totalUpdatedColumns?: number | undefined;
        totalUpdatedRows?: number | undefined;
        totalUpdatedSheets?: number | undefined;
      }
      interface BatchUpdateValuesRequest {
        data?: Sheets.Schema.ValueRange[] | undefined;
        includeValuesInResponse?: boolean | undefined;
        responseDateTimeRenderOption?: string | undefined;
        responseValueRenderOption?: string | undefined;
        valueInputOption?: string | undefined;
      }
      interface BatchUpdateValuesResponse {
        responses?: Sheets.Schema.UpdateValuesResponse[] | undefined;
        spreadsheetId?: string | undefined;
        totalUpdatedCells?: number | undefined;
        totalUpdatedColumns?: number | undefined;
        totalUpdatedRows?: number | undefined;
        totalUpdatedSheets?: number | undefined;
      }
      interface BooleanCondition {
        type?: string | undefined;
        values?: Sheets.Schema.ConditionValue[] | undefined;
      }
      interface BooleanRule {
        condition?: Sheets.Schema.BooleanCondition | undefined;
        format?: Sheets.Schema.CellFormat | undefined;
      }
      interface Border {
        color?: Sheets.Schema.Color | undefined;
        style?: string | undefined;
        width?: number | undefined;
      }
      interface Borders {
        bottom?: Sheets.Schema.Border | undefined;
        left?: Sheets.Schema.Border | undefined;
        right?: Sheets.Schema.Border | undefined;
        top?: Sheets.Schema.Border | undefined;
      }
      interface BubbleChartSpec {
        bubbleBorderColor?: Sheets.Schema.Color | undefined;
        bubbleLabels?: Sheets.Schema.ChartData | undefined;
        bubbleMaxRadiusSize?: number | undefined;
        bubbleMinRadiusSize?: number | undefined;
        bubbleOpacity?: number | undefined;
        bubbleSizes?: Sheets.Schema.ChartData | undefined;
        bubbleTextStyle?: Sheets.Schema.TextFormat | undefined;
        domain?: Sheets.Schema.ChartData | undefined;
        groupIds?: Sheets.Schema.ChartData | undefined;
        legendPosition?: string | undefined;
        series?: Sheets.Schema.ChartData | undefined;
      }
      interface CandlestickChartSpec {
        data?: Sheets.Schema.CandlestickData[] | undefined;
        domain?: Sheets.Schema.CandlestickDomain | undefined;
      }
      interface CandlestickData {
        closeSeries?: Sheets.Schema.CandlestickSeries | undefined;
        highSeries?: Sheets.Schema.CandlestickSeries | undefined;
        lowSeries?: Sheets.Schema.CandlestickSeries | undefined;
        openSeries?: Sheets.Schema.CandlestickSeries | undefined;
      }
      interface CandlestickDomain {
        data?: Sheets.Schema.ChartData | undefined;
        reversed?: boolean | undefined;
      }
      interface CandlestickSeries {
        data?: Sheets.Schema.ChartData | undefined;
      }
      interface CellData {
        dataValidation?: Sheets.Schema.DataValidationRule | undefined;
        effectiveFormat?: Sheets.Schema.CellFormat | undefined;
        effectiveValue?: Sheets.Schema.ExtendedValue | undefined;
        formattedValue?: string | undefined;
        hyperlink?: string | undefined;
        note?: string | undefined;
        pivotTable?: Sheets.Schema.PivotTable | undefined;
        textFormatRuns?: Sheets.Schema.TextFormatRun[] | undefined;
        userEnteredFormat?: Sheets.Schema.CellFormat | undefined;
        userEnteredValue?: Sheets.Schema.ExtendedValue | undefined;
      }
      interface CellFormat {
        backgroundColor?: Sheets.Schema.Color | undefined;
        borders?: Sheets.Schema.Borders | undefined;
        horizontalAlignment?: string | undefined;
        hyperlinkDisplayType?: string | undefined;
        numberFormat?: Sheets.Schema.NumberFormat | undefined;
        padding?: Sheets.Schema.Padding | undefined;
        textDirection?: string | undefined;
        textFormat?: Sheets.Schema.TextFormat | undefined;
        textRotation?: Sheets.Schema.TextRotation | undefined;
        verticalAlignment?: string | undefined;
        wrapStrategy?: string | undefined;
      }
      interface ChartData {
        sourceRange?: Sheets.Schema.ChartSourceRange | undefined;
      }
      interface ChartSourceRange {
        sources?: Sheets.Schema.GridRange[] | undefined;
      }
      interface ChartSpec {
        altText?: string | undefined;
        backgroundColor?: Sheets.Schema.Color | undefined;
        basicChart?: Sheets.Schema.BasicChartSpec | undefined;
        bubbleChart?: Sheets.Schema.BubbleChartSpec | undefined;
        candlestickChart?: Sheets.Schema.CandlestickChartSpec | undefined;
        fontName?: string | undefined;
        hiddenDimensionStrategy?: string | undefined;
        histogramChart?: Sheets.Schema.HistogramChartSpec | undefined;
        maximized?: boolean | undefined;
        orgChart?: Sheets.Schema.OrgChartSpec | undefined;
        pieChart?: Sheets.Schema.PieChartSpec | undefined;
        subtitle?: string | undefined;
        subtitleTextFormat?: Sheets.Schema.TextFormat | undefined;
        subtitleTextPosition?: Sheets.Schema.TextPosition | undefined;
        title?: string | undefined;
        titleTextFormat?: Sheets.Schema.TextFormat | undefined;
        titleTextPosition?: Sheets.Schema.TextPosition | undefined;
        treemapChart?: Sheets.Schema.TreemapChartSpec | undefined;
        waterfallChart?: Sheets.Schema.WaterfallChartSpec | undefined;
      }
      interface ClearBasicFilterRequest {
        sheetId?: number | undefined;
      }
      interface ClearValuesResponse {
        clearedRange?: string | undefined;
        spreadsheetId?: string | undefined;
      }
      interface Color {
        alpha?: number | undefined;
        blue?: number | undefined;
        green?: number | undefined;
        red?: number | undefined;
      }
      interface ConditionValue {
        relativeDate?: string | undefined;
        userEnteredValue?: string | undefined;
      }
      interface ConditionalFormatRule {
        booleanRule?: Sheets.Schema.BooleanRule | undefined;
        gradientRule?: Sheets.Schema.GradientRule | undefined;
        ranges?: Sheets.Schema.GridRange[] | undefined;
      }
      interface CopyPasteRequest {
        destination?: Sheets.Schema.GridRange | undefined;
        pasteOrientation?: string | undefined;
        pasteType?: string | undefined;
        source?: Sheets.Schema.GridRange | undefined;
      }
      interface CopySheetToAnotherSpreadsheetRequest {
        destinationSpreadsheetId?: string | undefined;
      }
      interface CreateDeveloperMetadataRequest {
        developerMetadata?: Sheets.Schema.DeveloperMetadata | undefined;
      }
      interface CreateDeveloperMetadataResponse {
        developerMetadata?: Sheets.Schema.DeveloperMetadata | undefined;
      }
      interface CutPasteRequest {
        destination?: Sheets.Schema.GridCoordinate | undefined;
        pasteType?: string | undefined;
        source?: Sheets.Schema.GridRange | undefined;
      }
      interface DataFilter {
        a1Range?: string | undefined;
        developerMetadataLookup?: Sheets.Schema.DeveloperMetadataLookup | undefined;
        gridRange?: Sheets.Schema.GridRange | undefined;
      }
      interface DataFilterValueRange {
        dataFilter?: Sheets.Schema.DataFilter | undefined;
        majorDimension?: string | undefined;
        values?: any[][] | undefined;
      }
      interface DataValidationRule {
        condition?: Sheets.Schema.BooleanCondition | undefined;
        inputMessage?: string | undefined;
        showCustomUi?: boolean | undefined;
        strict?: boolean | undefined;
      }
      interface DateTimeRule {
        type?: string | undefined;
      }
      interface DeleteBandingRequest {
        bandedRangeId?: number | undefined;
      }
      interface DeleteConditionalFormatRuleRequest {
        index?: number | undefined;
        sheetId?: number | undefined;
      }
      interface DeleteConditionalFormatRuleResponse {
        rule?: Sheets.Schema.ConditionalFormatRule | undefined;
      }
      interface DeleteDeveloperMetadataRequest {
        dataFilter?: Sheets.Schema.DataFilter | undefined;
      }
      interface DeleteDeveloperMetadataResponse {
        deletedDeveloperMetadata?: Sheets.Schema.DeveloperMetadata[] | undefined;
      }
      interface DeleteDimensionGroupRequest {
        range?: Sheets.Schema.DimensionRange | undefined;
      }
      interface DeleteDimensionGroupResponse {
        dimensionGroups?: Sheets.Schema.DimensionGroup[] | undefined;
      }
      interface DeleteDimensionRequest {
        range?: Sheets.Schema.DimensionRange | undefined;
      }
      interface DeleteEmbeddedObjectRequest {
        objectId?: number | undefined;
      }
      interface DeleteFilterViewRequest {
        filterId?: number | undefined;
      }
      interface DeleteNamedRangeRequest {
        namedRangeId?: string | undefined;
      }
      interface DeleteProtectedRangeRequest {
        protectedRangeId?: number | undefined;
      }
      interface DeleteRangeRequest {
        range?: Sheets.Schema.GridRange | undefined;
        shiftDimension?: string | undefined;
      }
      interface DeleteSheetRequest {
        sheetId?: number | undefined;
      }
      interface DeveloperMetadata {
        location?: Sheets.Schema.DeveloperMetadataLocation | undefined;
        metadataId?: number | undefined;
        metadataKey?: string | undefined;
        metadataValue?: string | undefined;
        visibility?: string | undefined;
      }
      interface DeveloperMetadataLocation {
        dimensionRange?: Sheets.Schema.DimensionRange | undefined;
        locationType?: string | undefined;
        sheetId?: number | undefined;
        spreadsheet?: boolean | undefined;
      }
      interface DeveloperMetadataLookup {
        locationMatchingStrategy?: string | undefined;
        locationType?: string | undefined;
        metadataId?: number | undefined;
        metadataKey?: string | undefined;
        metadataLocation?: Sheets.Schema.DeveloperMetadataLocation | undefined;
        metadataValue?: string | undefined;
        visibility?: string | undefined;
      }
      interface DimensionGroup {
        collapsed?: boolean | undefined;
        depth?: number | undefined;
        range?: Sheets.Schema.DimensionRange | undefined;
      }
      interface DimensionProperties {
        developerMetadata?: Sheets.Schema.DeveloperMetadata[] | undefined;
        hiddenByFilter?: boolean | undefined;
        hiddenByUser?: boolean | undefined;
        pixelSize?: number | undefined;
      }
      interface DimensionRange {
        dimension?: string | undefined;
        endIndex?: number | undefined;
        sheetId?: number | undefined;
        startIndex?: number | undefined;
      }
      interface DuplicateFilterViewRequest {
        filterId?: number | undefined;
      }
      interface DuplicateFilterViewResponse {
        filter?: Sheets.Schema.FilterView | undefined;
      }
      interface DuplicateSheetRequest {
        insertSheetIndex?: number | undefined;
        newSheetId?: number | undefined;
        newSheetName?: string | undefined;
        sourceSheetId?: number | undefined;
      }
      interface DuplicateSheetResponse {
        properties?: Sheets.Schema.SheetProperties | undefined;
      }
      interface Editors {
        domainUsersCanEdit?: boolean | undefined;
        groups?: string[] | undefined;
        users?: string[] | undefined;
      }
      interface EmbeddedChart {
        chartId?: number | undefined;
        position?: Sheets.Schema.EmbeddedObjectPosition | undefined;
        spec?: Sheets.Schema.ChartSpec | undefined;
      }
      interface EmbeddedObjectPosition {
        newSheet?: boolean | undefined;
        overlayPosition?: Sheets.Schema.OverlayPosition | undefined;
        sheetId?: number | undefined;
      }
      interface ErrorValue {
        message?: string | undefined;
        type?: string | undefined;
      }
      interface ExtendedValue {
        boolValue?: boolean | undefined;
        errorValue?: Sheets.Schema.ErrorValue | undefined;
        formulaValue?: string | undefined;
        numberValue?: number | undefined;
        stringValue?: string | undefined;
      }
      interface FilterCriteria {
        condition?: Sheets.Schema.BooleanCondition | undefined;
        hiddenValues?: string[] | undefined;
      }
      interface FilterView {
        criteria?: object | undefined;
        filterViewId?: number | undefined;
        namedRangeId?: string | undefined;
        range?: Sheets.Schema.GridRange | undefined;
        sortSpecs?: Sheets.Schema.SortSpec[] | undefined;
        title?: string | undefined;
      }
      interface FindReplaceRequest {
        allSheets?: boolean | undefined;
        find?: string | undefined;
        includeFormulas?: boolean | undefined;
        matchCase?: boolean | undefined;
        matchEntireCell?: boolean | undefined;
        range?: Sheets.Schema.GridRange | undefined;
        replacement?: string | undefined;
        searchByRegex?: boolean | undefined;
        sheetId?: number | undefined;
      }
      interface FindReplaceResponse {
        formulasChanged?: number | undefined;
        occurrencesChanged?: number | undefined;
        rowsChanged?: number | undefined;
        sheetsChanged?: number | undefined;
        valuesChanged?: number | undefined;
      }
      interface GetSpreadsheetByDataFilterRequest {
        dataFilters?: Sheets.Schema.DataFilter[] | undefined;
        includeGridData?: boolean | undefined;
      }
      interface GradientRule {
        maxpoint?: Sheets.Schema.InterpolationPoint | undefined;
        midpoint?: Sheets.Schema.InterpolationPoint | undefined;
        minpoint?: Sheets.Schema.InterpolationPoint | undefined;
      }
      interface GridCoordinate {
        columnIndex?: number | undefined;
        rowIndex?: number | undefined;
        sheetId?: number | undefined;
      }
      interface GridData {
        columnMetadata?: Sheets.Schema.DimensionProperties[] | undefined;
        rowData?: Sheets.Schema.RowData[] | undefined;
        rowMetadata?: Sheets.Schema.DimensionProperties[] | undefined;
        startColumn?: number | undefined;
        startRow?: number | undefined;
      }
      interface GridProperties {
        columnCount?: number | undefined;
        columnGroupControlAfter?: boolean | undefined;
        frozenColumnCount?: number | undefined;
        frozenRowCount?: number | undefined;
        hideGridlines?: boolean | undefined;
        rowCount?: number | undefined;
        rowGroupControlAfter?: boolean | undefined;
      }
      interface GridRange {
        endColumnIndex?: number | undefined;
        endRowIndex?: number | undefined;
        sheetId?: number | undefined;
        startColumnIndex?: number | undefined;
        startRowIndex?: number | undefined;
      }
      interface HistogramChartSpec {
        bucketSize?: number | undefined;
        legendPosition?: string | undefined;
        outlierPercentile?: number | undefined;
        series?: Sheets.Schema.HistogramSeries[] | undefined;
        showItemDividers?: boolean | undefined;
      }
      interface HistogramRule {
        end?: number | undefined;
        interval?: number | undefined;
        start?: number | undefined;
      }
      interface HistogramSeries {
        barColor?: Sheets.Schema.Color | undefined;
        data?: Sheets.Schema.ChartData | undefined;
      }
      interface InsertDimensionRequest {
        inheritFromBefore?: boolean | undefined;
        range?: Sheets.Schema.DimensionRange | undefined;
      }
      interface InsertRangeRequest {
        range?: Sheets.Schema.GridRange | undefined;
        shiftDimension?: string | undefined;
      }
      interface InterpolationPoint {
        color?: Sheets.Schema.Color | undefined;
        type?: string | undefined;
        value?: string | undefined;
      }
      interface IterativeCalculationSettings {
        convergenceThreshold?: number | undefined;
        maxIterations?: number | undefined;
      }
      interface LineStyle {
        type?: string | undefined;
        width?: number | undefined;
      }
      interface ManualRule {
        groups?: Sheets.Schema.ManualRuleGroup[] | undefined;
      }
      interface ManualRuleGroup {
        groupName?: Sheets.Schema.ExtendedValue | undefined;
        items?: Sheets.Schema.ExtendedValue[] | undefined;
      }
      interface MatchedDeveloperMetadata {
        dataFilters?: Sheets.Schema.DataFilter[] | undefined;
        developerMetadata?: Sheets.Schema.DeveloperMetadata | undefined;
      }
      interface MatchedValueRange {
        dataFilters?: Sheets.Schema.DataFilter[] | undefined;
        valueRange?: Sheets.Schema.ValueRange | undefined;
      }
      interface MergeCellsRequest {
        mergeType?: string | undefined;
        range?: Sheets.Schema.GridRange | undefined;
      }
      interface MoveDimensionRequest {
        destinationIndex?: number | undefined;
        source?: Sheets.Schema.DimensionRange | undefined;
      }
      interface NamedRange {
        name?: string | undefined;
        namedRangeId?: string | undefined;
        range?: Sheets.Schema.GridRange | undefined;
      }
      interface NumberFormat {
        pattern?: string | undefined;
        type?: string | undefined;
      }
      interface OrgChartSpec {
        labels?: Sheets.Schema.ChartData | undefined;
        nodeColor?: Sheets.Schema.Color | undefined;
        nodeSize?: string | undefined;
        parentLabels?: Sheets.Schema.ChartData | undefined;
        selectedNodeColor?: Sheets.Schema.Color | undefined;
        tooltips?: Sheets.Schema.ChartData | undefined;
      }
      interface OverlayPosition {
        anchorCell?: Sheets.Schema.GridCoordinate | undefined;
        heightPixels?: number | undefined;
        offsetXPixels?: number | undefined;
        offsetYPixels?: number | undefined;
        widthPixels?: number | undefined;
      }
      interface Padding {
        bottom?: number | undefined;
        left?: number | undefined;
        right?: number | undefined;
        top?: number | undefined;
      }
      interface PasteDataRequest {
        coordinate?: Sheets.Schema.GridCoordinate | undefined;
        data?: string | undefined;
        delimiter?: string | undefined;
        html?: boolean | undefined;
        type?: string | undefined;
      }
      interface PieChartSpec {
        domain?: Sheets.Schema.ChartData | undefined;
        legendPosition?: string | undefined;
        pieHole?: number | undefined;
        series?: Sheets.Schema.ChartData | undefined;
        threeDimensional?: boolean | undefined;
      }
      interface PivotFilterCriteria {
        visibleValues?: string[] | undefined;
      }
      interface PivotGroup {
        groupRule?: Sheets.Schema.PivotGroupRule | undefined;
        label?: string | undefined;
        repeatHeadings?: boolean | undefined;
        showTotals?: boolean | undefined;
        sortOrder?: string | undefined;
        sourceColumnOffset?: number | undefined;
        valueBucket?: Sheets.Schema.PivotGroupSortValueBucket | undefined;
        valueMetadata?: Sheets.Schema.PivotGroupValueMetadata[] | undefined;
      }
      interface PivotGroupRule {
        dateTimeRule?: Sheets.Schema.DateTimeRule | undefined;
        histogramRule?: Sheets.Schema.HistogramRule | undefined;
        manualRule?: Sheets.Schema.ManualRule | undefined;
      }
      interface PivotGroupSortValueBucket {
        buckets?: Sheets.Schema.ExtendedValue[] | undefined;
        valuesIndex?: number | undefined;
      }
      interface PivotGroupValueMetadata {
        collapsed?: boolean | undefined;
        value?: Sheets.Schema.ExtendedValue | undefined;
      }
      interface PivotTable {
        columns?: Sheets.Schema.PivotGroup[] | undefined;
        criteria?: object | undefined;
        rows?: Sheets.Schema.PivotGroup[] | undefined;
        source?: Sheets.Schema.GridRange | undefined;
        valueLayout?: string | undefined;
        values?: Sheets.Schema.PivotValue[] | undefined;
      }
      interface PivotValue {
        calculatedDisplayType?: string | undefined;
        formula?: string | undefined;
        name?: string | undefined;
        sourceColumnOffset?: number | undefined;
        summarizeFunction?: string | undefined;
      }
      interface ProtectedRange {
        description?: string | undefined;
        editors?: Sheets.Schema.Editors | undefined;
        namedRangeId?: string | undefined;
        protectedRangeId?: number | undefined;
        range?: Sheets.Schema.GridRange | undefined;
        requestingUserCanEdit?: boolean | undefined;
        unprotectedRanges?: Sheets.Schema.GridRange[] | undefined;
        warningOnly?: boolean | undefined;
      }
      interface RandomizeRangeRequest {
        range?: Sheets.Schema.GridRange | undefined;
      }
      interface RepeatCellRequest {
        cell?: Sheets.Schema.CellData | undefined;
        fields?: string | undefined;
        range?: Sheets.Schema.GridRange | undefined;
      }
      interface Request {
        addBanding?: Sheets.Schema.AddBandingRequest | undefined;
        addChart?: Sheets.Schema.AddChartRequest | undefined;
        addConditionalFormatRule?: Sheets.Schema.AddConditionalFormatRuleRequest | undefined;
        addDimensionGroup?: Sheets.Schema.AddDimensionGroupRequest | undefined;
        addFilterView?: Sheets.Schema.AddFilterViewRequest | undefined;
        addNamedRange?: Sheets.Schema.AddNamedRangeRequest | undefined;
        addProtectedRange?: Sheets.Schema.AddProtectedRangeRequest | undefined;
        addSheet?: Sheets.Schema.AddSheetRequest | undefined;
        appendCells?: Sheets.Schema.AppendCellsRequest | undefined;
        appendDimension?: Sheets.Schema.AppendDimensionRequest | undefined;
        autoFill?: Sheets.Schema.AutoFillRequest | undefined;
        autoResizeDimensions?: Sheets.Schema.AutoResizeDimensionsRequest | undefined;
        clearBasicFilter?: Sheets.Schema.ClearBasicFilterRequest | undefined;
        copyPaste?: Sheets.Schema.CopyPasteRequest | undefined;
        createDeveloperMetadata?: Sheets.Schema.CreateDeveloperMetadataRequest | undefined;
        cutPaste?: Sheets.Schema.CutPasteRequest | undefined;
        deleteBanding?: Sheets.Schema.DeleteBandingRequest | undefined;
        deleteConditionalFormatRule?: Sheets.Schema.DeleteConditionalFormatRuleRequest | undefined;
        deleteDeveloperMetadata?: Sheets.Schema.DeleteDeveloperMetadataRequest | undefined;
        deleteDimension?: Sheets.Schema.DeleteDimensionRequest | undefined;
        deleteDimensionGroup?: Sheets.Schema.DeleteDimensionGroupRequest | undefined;
        deleteEmbeddedObject?: Sheets.Schema.DeleteEmbeddedObjectRequest | undefined;
        deleteFilterView?: Sheets.Schema.DeleteFilterViewRequest | undefined;
        deleteNamedRange?: Sheets.Schema.DeleteNamedRangeRequest | undefined;
        deleteProtectedRange?: Sheets.Schema.DeleteProtectedRangeRequest | undefined;
        deleteRange?: Sheets.Schema.DeleteRangeRequest | undefined;
        deleteSheet?: Sheets.Schema.DeleteSheetRequest | undefined;
        duplicateFilterView?: Sheets.Schema.DuplicateFilterViewRequest | undefined;
        duplicateSheet?: Sheets.Schema.DuplicateSheetRequest | undefined;
        findReplace?: Sheets.Schema.FindReplaceRequest | undefined;
        insertDimension?: Sheets.Schema.InsertDimensionRequest | undefined;
        insertRange?: Sheets.Schema.InsertRangeRequest | undefined;
        mergeCells?: Sheets.Schema.MergeCellsRequest | undefined;
        moveDimension?: Sheets.Schema.MoveDimensionRequest | undefined;
        pasteData?: Sheets.Schema.PasteDataRequest | undefined;
        randomizeRange?: Sheets.Schema.RandomizeRangeRequest | undefined;
        repeatCell?: Sheets.Schema.RepeatCellRequest | undefined;
        setBasicFilter?: Sheets.Schema.SetBasicFilterRequest | undefined;
        setDataValidation?: Sheets.Schema.SetDataValidationRequest | undefined;
        sortRange?: Sheets.Schema.SortRangeRequest | undefined;
        textToColumns?: Sheets.Schema.TextToColumnsRequest | undefined;
        unmergeCells?: Sheets.Schema.UnmergeCellsRequest | undefined;
        updateBanding?: Sheets.Schema.UpdateBandingRequest | undefined;
        updateBorders?: Sheets.Schema.UpdateBordersRequest | undefined;
        updateCells?: Sheets.Schema.UpdateCellsRequest | undefined;
        updateChartSpec?: Sheets.Schema.UpdateChartSpecRequest | undefined;
        updateConditionalFormatRule?: Sheets.Schema.UpdateConditionalFormatRuleRequest | undefined;
        updateDeveloperMetadata?: Sheets.Schema.UpdateDeveloperMetadataRequest | undefined;
        updateDimensionGroup?: Sheets.Schema.UpdateDimensionGroupRequest | undefined;
        updateDimensionProperties?: Sheets.Schema.UpdateDimensionPropertiesRequest | undefined;
        updateEmbeddedObjectPosition?: Sheets.Schema.UpdateEmbeddedObjectPositionRequest | undefined;
        updateFilterView?: Sheets.Schema.UpdateFilterViewRequest | undefined;
        updateNamedRange?: Sheets.Schema.UpdateNamedRangeRequest | undefined;
        updateProtectedRange?: Sheets.Schema.UpdateProtectedRangeRequest | undefined;
        updateSheetProperties?: Sheets.Schema.UpdateSheetPropertiesRequest | undefined;
        updateSpreadsheetProperties?: Sheets.Schema.UpdateSpreadsheetPropertiesRequest | undefined;
      }
      interface Response {
        addBanding?: Sheets.Schema.AddBandingResponse | undefined;
        addChart?: Sheets.Schema.AddChartResponse | undefined;
        addDimensionGroup?: Sheets.Schema.AddDimensionGroupResponse | undefined;
        addFilterView?: Sheets.Schema.AddFilterViewResponse | undefined;
        addNamedRange?: Sheets.Schema.AddNamedRangeResponse | undefined;
        addProtectedRange?: Sheets.Schema.AddProtectedRangeResponse | undefined;
        addSheet?: Sheets.Schema.AddSheetResponse | undefined;
        createDeveloperMetadata?: Sheets.Schema.CreateDeveloperMetadataResponse | undefined;
        deleteConditionalFormatRule?: Sheets.Schema.DeleteConditionalFormatRuleResponse | undefined;
        deleteDeveloperMetadata?: Sheets.Schema.DeleteDeveloperMetadataResponse | undefined;
        deleteDimensionGroup?: Sheets.Schema.DeleteDimensionGroupResponse | undefined;
        duplicateFilterView?: Sheets.Schema.DuplicateFilterViewResponse | undefined;
        duplicateSheet?: Sheets.Schema.DuplicateSheetResponse | undefined;
        findReplace?: Sheets.Schema.FindReplaceResponse | undefined;
        updateConditionalFormatRule?: Sheets.Schema.UpdateConditionalFormatRuleResponse | undefined;
        updateDeveloperMetadata?: Sheets.Schema.UpdateDeveloperMetadataResponse | undefined;
        updateEmbeddedObjectPosition?: Sheets.Schema.UpdateEmbeddedObjectPositionResponse | undefined;
      }
      interface RowData {
        values?: Sheets.Schema.CellData[] | undefined;
      }
      interface SearchDeveloperMetadataRequest {
        dataFilters?: Sheets.Schema.DataFilter[] | undefined;
      }
      interface SearchDeveloperMetadataResponse {
        matchedDeveloperMetadata?: Sheets.Schema.MatchedDeveloperMetadata[] | undefined;
      }
      interface SetBasicFilterRequest {
        filter?: Sheets.Schema.BasicFilter | undefined;
      }
      interface SetDataValidationRequest {
        range?: Sheets.Schema.GridRange | undefined;
        rule?: Sheets.Schema.DataValidationRule | undefined;
      }
      interface Sheet {
        bandedRanges?: Sheets.Schema.BandedRange[] | undefined;
        basicFilter?: Sheets.Schema.BasicFilter | undefined;
        charts?: Sheets.Schema.EmbeddedChart[] | undefined;
        columnGroups?: Sheets.Schema.DimensionGroup[] | undefined;
        conditionalFormats?: Sheets.Schema.ConditionalFormatRule[] | undefined;
        data?: Sheets.Schema.GridData[] | undefined;
        developerMetadata?: Sheets.Schema.DeveloperMetadata[] | undefined;
        filterViews?: Sheets.Schema.FilterView[] | undefined;
        merges?: Sheets.Schema.GridRange[] | undefined;
        properties?: Sheets.Schema.SheetProperties | undefined;
        protectedRanges?: Sheets.Schema.ProtectedRange[] | undefined;
        rowGroups?: Sheets.Schema.DimensionGroup[] | undefined;
      }
      interface SheetProperties {
        gridProperties?: Sheets.Schema.GridProperties | undefined;
        hidden?: boolean | undefined;
        index?: number | undefined;
        rightToLeft?: boolean | undefined;
        sheetId?: number | undefined;
        sheetType?: string | undefined;
        tabColor?: Sheets.Schema.Color | undefined;
        title?: string | undefined;
      }
      interface SortRangeRequest {
        range?: Sheets.Schema.GridRange | undefined;
        sortSpecs?: Sheets.Schema.SortSpec[] | undefined;
      }
      interface SortSpec {
        dimensionIndex?: number | undefined;
        sortOrder?: string | undefined;
      }
      interface SourceAndDestination {
        dimension?: string | undefined;
        fillLength?: number | undefined;
        source?: Sheets.Schema.GridRange | undefined;
      }
      interface Spreadsheet {
        developerMetadata?: Sheets.Schema.DeveloperMetadata[] | undefined;
        namedRanges?: Sheets.Schema.NamedRange[] | undefined;
        properties?: Sheets.Schema.SpreadsheetProperties | undefined;
        sheets?: Sheets.Schema.Sheet[] | undefined;
        spreadsheetId?: string | undefined;
        spreadsheetUrl?: string | undefined;
      }
      interface SpreadsheetProperties {
        autoRecalc?: string | undefined;
        defaultFormat?: Sheets.Schema.CellFormat | undefined;
        iterativeCalculationSettings?: Sheets.Schema.IterativeCalculationSettings | undefined;
        locale?: string | undefined;
        timeZone?: string | undefined;
        title?: string | undefined;
      }
      interface TextFormat {
        bold?: boolean | undefined;
        fontFamily?: string | undefined;
        fontSize?: number | undefined;
        foregroundColor?: Sheets.Schema.Color | undefined;
        italic?: boolean | undefined;
        strikethrough?: boolean | undefined;
        underline?: boolean | undefined;
      }
      interface TextFormatRun {
        format?: Sheets.Schema.TextFormat | undefined;
        startIndex?: number | undefined;
      }
      interface TextPosition {
        horizontalAlignment?: string | undefined;
      }
      interface TextRotation {
        angle?: number | undefined;
        vertical?: boolean | undefined;
      }
      interface TextToColumnsRequest {
        delimiter?: string | undefined;
        delimiterType?: string | undefined;
        source?: Sheets.Schema.GridRange | undefined;
      }
      interface TreemapChartColorScale {
        maxValueColor?: Sheets.Schema.Color | undefined;
        midValueColor?: Sheets.Schema.Color | undefined;
        minValueColor?: Sheets.Schema.Color | undefined;
        noDataColor?: Sheets.Schema.Color | undefined;
      }
      interface TreemapChartSpec {
        colorData?: Sheets.Schema.ChartData | undefined;
        colorScale?: Sheets.Schema.TreemapChartColorScale | undefined;
        headerColor?: Sheets.Schema.Color | undefined;
        hideTooltips?: boolean | undefined;
        hintedLevels?: number | undefined;
        labels?: Sheets.Schema.ChartData | undefined;
        levels?: number | undefined;
        maxValue?: number | undefined;
        minValue?: number | undefined;
        parentLabels?: Sheets.Schema.ChartData | undefined;
        sizeData?: Sheets.Schema.ChartData | undefined;
        textFormat?: Sheets.Schema.TextFormat | undefined;
      }
      interface UnmergeCellsRequest {
        range?: Sheets.Schema.GridRange | undefined;
      }
      interface UpdateBandingRequest {
        bandedRange?: Sheets.Schema.BandedRange | undefined;
        fields?: string | undefined;
      }
      interface UpdateBordersRequest {
        bottom?: Sheets.Schema.Border | undefined;
        innerHorizontal?: Sheets.Schema.Border | undefined;
        innerVertical?: Sheets.Schema.Border | undefined;
        left?: Sheets.Schema.Border | undefined;
        range?: Sheets.Schema.GridRange | undefined;
        right?: Sheets.Schema.Border | undefined;
        top?: Sheets.Schema.Border | undefined;
      }
      interface UpdateCellsRequest {
        fields?: string | undefined;
        range?: Sheets.Schema.GridRange | undefined;
        rows?: Sheets.Schema.RowData[] | undefined;
        start?: Sheets.Schema.GridCoordinate | undefined;
      }
      interface UpdateChartSpecRequest {
        chartId?: number | undefined;
        spec?: Sheets.Schema.ChartSpec | undefined;
      }
      interface UpdateConditionalFormatRuleRequest {
        index?: number | undefined;
        newIndex?: number | undefined;
        rule?: Sheets.Schema.ConditionalFormatRule | undefined;
        sheetId?: number | undefined;
      }
      interface UpdateConditionalFormatRuleResponse {
        newIndex?: number | undefined;
        newRule?: Sheets.Schema.ConditionalFormatRule | undefined;
        oldIndex?: number | undefined;
        oldRule?: Sheets.Schema.ConditionalFormatRule | undefined;
      }
      interface UpdateDeveloperMetadataRequest {
        dataFilters?: Sheets.Schema.DataFilter[] | undefined;
        developerMetadata?: Sheets.Schema.DeveloperMetadata | undefined;
        fields?: string | undefined;
      }
      interface UpdateDeveloperMetadataResponse {
        developerMetadata?: Sheets.Schema.DeveloperMetadata[] | undefined;
      }
      interface UpdateDimensionGroupRequest {
        dimensionGroup?: Sheets.Schema.DimensionGroup | undefined;
        fields?: string | undefined;
      }
      interface UpdateDimensionPropertiesRequest {
        fields?: string | undefined;
        properties?: Sheets.Schema.DimensionProperties | undefined;
        range?: Sheets.Schema.DimensionRange | undefined;
      }
      interface UpdateEmbeddedObjectPositionRequest {
        fields?: string | undefined;
        newPosition?: Sheets.Schema.EmbeddedObjectPosition | undefined;
        objectId?: number | undefined;
      }
      interface UpdateEmbeddedObjectPositionResponse {
        position?: Sheets.Schema.EmbeddedObjectPosition | undefined;
      }
      interface UpdateFilterViewRequest {
        fields?: string | undefined;
        filter?: Sheets.Schema.FilterView | undefined;
      }
      interface UpdateNamedRangeRequest {
        fields?: string | undefined;
        namedRange?: Sheets.Schema.NamedRange | undefined;
      }
      interface UpdateProtectedRangeRequest {
        fields?: string | undefined;
        protectedRange?: Sheets.Schema.ProtectedRange | undefined;
      }
      interface UpdateSheetPropertiesRequest {
        fields?: string | undefined;
        properties?: Sheets.Schema.SheetProperties | undefined;
      }
      interface UpdateSpreadsheetPropertiesRequest {
        fields?: string | undefined;
        properties?: Sheets.Schema.SpreadsheetProperties | undefined;
      }
      interface UpdateValuesByDataFilterResponse {
        dataFilter?: Sheets.Schema.DataFilter | undefined;
        updatedCells?: number | undefined;
        updatedColumns?: number | undefined;
        updatedData?: Sheets.Schema.ValueRange | undefined;
        updatedRange?: string | undefined;
        updatedRows?: number | undefined;
      }
      interface UpdateValuesResponse {
        spreadsheetId?: string | undefined;
        updatedCells?: number | undefined;
        updatedColumns?: number | undefined;
        updatedData?: Sheets.Schema.ValueRange | undefined;
        updatedRange?: string | undefined;
        updatedRows?: number | undefined;
      }
      interface ValueRange {
        majorDimension?: string | undefined;
        range?: string | undefined;
        values?: any[][] | undefined;
      }
      interface WaterfallChartColumnStyle {
        color?: Sheets.Schema.Color | undefined;
        label?: string | undefined;
      }
      interface WaterfallChartCustomSubtotal {
        dataIsSubtotal?: boolean | undefined;
        label?: string | undefined;
        subtotalIndex?: number | undefined;
      }
      interface WaterfallChartDomain {
        data?: Sheets.Schema.ChartData | undefined;
        reversed?: boolean | undefined;
      }
      interface WaterfallChartSeries {
        customSubtotals?: Sheets.Schema.WaterfallChartCustomSubtotal[] | undefined;
        data?: Sheets.Schema.ChartData | undefined;
        hideTrailingSubtotal?: boolean | undefined;
        negativeColumnsStyle?: Sheets.Schema.WaterfallChartColumnStyle | undefined;
        positiveColumnsStyle?: Sheets.Schema.WaterfallChartColumnStyle | undefined;
        subtotalColumnsStyle?: Sheets.Schema.WaterfallChartColumnStyle | undefined;
      }
      interface WaterfallChartSpec {
        connectorLineStyle?: Sheets.Schema.LineStyle | undefined;
        domain?: Sheets.Schema.WaterfallChartDomain | undefined;
        firstValueIsTotal?: boolean | undefined;
        hideConnectorLines?: boolean | undefined;
        series?: Sheets.Schema.WaterfallChartSeries[] | undefined;
        stackedType?: string | undefined;
      }
    }
  }
  interface Sheets {
    Spreadsheets?: Sheets.Collection.SpreadsheetsCollection | undefined;
    // Create a new instance of AddBandingRequest
    newAddBandingRequest(): Sheets.Schema.AddBandingRequest;
    // Create a new instance of AddChartRequest
    newAddChartRequest(): Sheets.Schema.AddChartRequest;
    // Create a new instance of AddConditionalFormatRuleRequest
    newAddConditionalFormatRuleRequest(): Sheets.Schema.AddConditionalFormatRuleRequest;
    // Create a new instance of AddDimensionGroupRequest
    newAddDimensionGroupRequest(): Sheets.Schema.AddDimensionGroupRequest;
    // Create a new instance of AddFilterViewRequest
    newAddFilterViewRequest(): Sheets.Schema.AddFilterViewRequest;
    // Create a new instance of AddNamedRangeRequest
    newAddNamedRangeRequest(): Sheets.Schema.AddNamedRangeRequest;
    // Create a new instance of AddProtectedRangeRequest
    newAddProtectedRangeRequest(): Sheets.Schema.AddProtectedRangeRequest;
    // Create a new instance of AddSheetRequest
    newAddSheetRequest(): Sheets.Schema.AddSheetRequest;
    // Create a new instance of AppendCellsRequest
    newAppendCellsRequest(): Sheets.Schema.AppendCellsRequest;
    // Create a new instance of AppendDimensionRequest
    newAppendDimensionRequest(): Sheets.Schema.AppendDimensionRequest;
    // Create a new instance of AutoFillRequest
    newAutoFillRequest(): Sheets.Schema.AutoFillRequest;
    // Create a new instance of AutoResizeDimensionsRequest
    newAutoResizeDimensionsRequest(): Sheets.Schema.AutoResizeDimensionsRequest;
    // Create a new instance of BandedRange
    newBandedRange(): Sheets.Schema.BandedRange;
    // Create a new instance of BandingProperties
    newBandingProperties(): Sheets.Schema.BandingProperties;
    // Create a new instance of BasicChartAxis
    newBasicChartAxis(): Sheets.Schema.BasicChartAxis;
    // Create a new instance of BasicChartDomain
    newBasicChartDomain(): Sheets.Schema.BasicChartDomain;
    // Create a new instance of BasicChartSeries
    newBasicChartSeries(): Sheets.Schema.BasicChartSeries;
    // Create a new instance of BasicChartSpec
    newBasicChartSpec(): Sheets.Schema.BasicChartSpec;
    // Create a new instance of BasicFilter
    newBasicFilter(): Sheets.Schema.BasicFilter;
    // Create a new instance of BatchClearValuesByDataFilterRequest
    newBatchClearValuesByDataFilterRequest(): Sheets.Schema.BatchClearValuesByDataFilterRequest;
    // Create a new instance of BatchClearValuesRequest
    newBatchClearValuesRequest(): Sheets.Schema.BatchClearValuesRequest;
    // Create a new instance of BatchGetValuesByDataFilterRequest
    newBatchGetValuesByDataFilterRequest(): Sheets.Schema.BatchGetValuesByDataFilterRequest;
    // Create a new instance of BatchUpdateSpreadsheetRequest
    newBatchUpdateSpreadsheetRequest(): Sheets.Schema.BatchUpdateSpreadsheetRequest;
    // Create a new instance of BatchUpdateValuesByDataFilterRequest
    newBatchUpdateValuesByDataFilterRequest(): Sheets.Schema.BatchUpdateValuesByDataFilterRequest;
    // Create a new instance of BatchUpdateValuesRequest
    newBatchUpdateValuesRequest(): Sheets.Schema.BatchUpdateValuesRequest;
    // Create a new instance of BooleanCondition
    newBooleanCondition(): Sheets.Schema.BooleanCondition;
    // Create a new instance of BooleanRule
    newBooleanRule(): Sheets.Schema.BooleanRule;
    // Create a new instance of Border
    newBorder(): Sheets.Schema.Border;
    // Create a new instance of Borders
    newBorders(): Sheets.Schema.Borders;
    // Create a new instance of BubbleChartSpec
    newBubbleChartSpec(): Sheets.Schema.BubbleChartSpec;
    // Create a new instance of CandlestickChartSpec
    newCandlestickChartSpec(): Sheets.Schema.CandlestickChartSpec;
    // Create a new instance of CandlestickData
    newCandlestickData(): Sheets.Schema.CandlestickData;
    // Create a new instance of CandlestickDomain
    newCandlestickDomain(): Sheets.Schema.CandlestickDomain;
    // Create a new instance of CandlestickSeries
    newCandlestickSeries(): Sheets.Schema.CandlestickSeries;
    // Create a new instance of CellData
    newCellData(): Sheets.Schema.CellData;
    // Create a new instance of CellFormat
    newCellFormat(): Sheets.Schema.CellFormat;
    // Create a new instance of ChartData
    newChartData(): Sheets.Schema.ChartData;
    // Create a new instance of ChartSourceRange
    newChartSourceRange(): Sheets.Schema.ChartSourceRange;
    // Create a new instance of ChartSpec
    newChartSpec(): Sheets.Schema.ChartSpec;
    // Create a new instance of ClearBasicFilterRequest
    newClearBasicFilterRequest(): Sheets.Schema.ClearBasicFilterRequest;
    // Create a new instance of ClearValuesRequest
    newClearValuesRequest(): any; // Schema.ClearValuesRequest;
    // Create a new instance of Color
    newColor(): Sheets.Schema.Color;
    // Create a new instance of ConditionValue
    newConditionValue(): Sheets.Schema.ConditionValue;
    // Create a new instance of ConditionalFormatRule
    newConditionalFormatRule(): Sheets.Schema.ConditionalFormatRule;
    // Create a new instance of CopyPasteRequest
    newCopyPasteRequest(): Sheets.Schema.CopyPasteRequest;
    // Create a new instance of CopySheetToAnotherSpreadsheetRequest
    newCopySheetToAnotherSpreadsheetRequest(): Sheets.Schema.CopySheetToAnotherSpreadsheetRequest;
    // Create a new instance of CreateDeveloperMetadataRequest
    newCreateDeveloperMetadataRequest(): Sheets.Schema.CreateDeveloperMetadataRequest;
    // Create a new instance of CutPasteRequest
    newCutPasteRequest(): Sheets.Schema.CutPasteRequest;
    // Create a new instance of DataFilter
    newDataFilter(): Sheets.Schema.DataFilter;
    // Create a new instance of DataFilterValueRange
    newDataFilterValueRange(): Sheets.Schema.DataFilterValueRange;
    // Create a new instance of DataValidationRule
    newDataValidationRule(): Sheets.Schema.DataValidationRule;
    // Create a new instance of DateTimeRule
    newDateTimeRule(): Sheets.Schema.DateTimeRule;
    // Create a new instance of DeleteBandingRequest
    newDeleteBandingRequest(): Sheets.Schema.DeleteBandingRequest;
    // Create a new instance of DeleteConditionalFormatRuleRequest
    newDeleteConditionalFormatRuleRequest(): Sheets.Schema.DeleteConditionalFormatRuleRequest;
    // Create a new instance of DeleteDeveloperMetadataRequest
    newDeleteDeveloperMetadataRequest(): Sheets.Schema.DeleteDeveloperMetadataRequest;
    // Create a new instance of DeleteDimensionGroupRequest
    newDeleteDimensionGroupRequest(): Sheets.Schema.DeleteDimensionGroupRequest;
    // Create a new instance of DeleteDimensionRequest
    newDeleteDimensionRequest(): Sheets.Schema.DeleteDimensionRequest;
    // Create a new instance of DeleteEmbeddedObjectRequest
    newDeleteEmbeddedObjectRequest(): Sheets.Schema.DeleteEmbeddedObjectRequest;
    // Create a new instance of DeleteFilterViewRequest
    newDeleteFilterViewRequest(): Sheets.Schema.DeleteFilterViewRequest;
    // Create a new instance of DeleteNamedRangeRequest
    newDeleteNamedRangeRequest(): Sheets.Schema.DeleteNamedRangeRequest;
    // Create a new instance of DeleteProtectedRangeRequest
    newDeleteProtectedRangeRequest(): Sheets.Schema.DeleteProtectedRangeRequest;
    // Create a new instance of DeleteRangeRequest
    newDeleteRangeRequest(): Sheets.Schema.DeleteRangeRequest;
    // Create a new instance of DeleteSheetRequest
    newDeleteSheetRequest(): Sheets.Schema.DeleteSheetRequest;
    // Create a new instance of DeveloperMetadata
    newDeveloperMetadata(): Sheets.Schema.DeveloperMetadata;
    // Create a new instance of DeveloperMetadataLocation
    newDeveloperMetadataLocation(): Sheets.Schema.DeveloperMetadataLocation;
    // Create a new instance of DeveloperMetadataLookup
    newDeveloperMetadataLookup(): Sheets.Schema.DeveloperMetadataLookup;
    // Create a new instance of DimensionGroup
    newDimensionGroup(): Sheets.Schema.DimensionGroup;
    // Create a new instance of DimensionProperties
    newDimensionProperties(): Sheets.Schema.DimensionProperties;
    // Create a new instance of DimensionRange
    newDimensionRange(): Sheets.Schema.DimensionRange;
    // Create a new instance of DuplicateFilterViewRequest
    newDuplicateFilterViewRequest(): Sheets.Schema.DuplicateFilterViewRequest;
    // Create a new instance of DuplicateSheetRequest
    newDuplicateSheetRequest(): Sheets.Schema.DuplicateSheetRequest;
    // Create a new instance of Editors
    newEditors(): Sheets.Schema.Editors;
    // Create a new instance of EmbeddedChart
    newEmbeddedChart(): Sheets.Schema.EmbeddedChart;
    // Create a new instance of EmbeddedObjectPosition
    newEmbeddedObjectPosition(): Sheets.Schema.EmbeddedObjectPosition;
    // Create a new instance of ErrorValue
    newErrorValue(): Sheets.Schema.ErrorValue;
    // Create a new instance of ExtendedValue
    newExtendedValue(): Sheets.Schema.ExtendedValue;
    // Create a new instance of FilterView
    newFilterView(): Sheets.Schema.FilterView;
    // Create a new instance of FindReplaceRequest
    newFindReplaceRequest(): Sheets.Schema.FindReplaceRequest;
    // Create a new instance of GetSpreadsheetByDataFilterRequest
    newGetSpreadsheetByDataFilterRequest(): Sheets.Schema.GetSpreadsheetByDataFilterRequest;
    // Create a new instance of GradientRule
    newGradientRule(): Sheets.Schema.GradientRule;
    // Create a new instance of GridCoordinate
    newGridCoordinate(): Sheets.Schema.GridCoordinate;
    // Create a new instance of GridData
    newGridData(): Sheets.Schema.GridData;
    // Create a new instance of GridProperties
    newGridProperties(): Sheets.Schema.GridProperties;
    // Create a new instance of GridRange
    newGridRange(): Sheets.Schema.GridRange;
    // Create a new instance of HistogramChartSpec
    newHistogramChartSpec(): Sheets.Schema.HistogramChartSpec;
    // Create a new instance of HistogramRule
    newHistogramRule(): Sheets.Schema.HistogramRule;
    // Create a new instance of HistogramSeries
    newHistogramSeries(): Sheets.Schema.HistogramSeries;
    // Create a new instance of InsertDimensionRequest
    newInsertDimensionRequest(): Sheets.Schema.InsertDimensionRequest;
    // Create a new instance of InsertRangeRequest
    newInsertRangeRequest(): Sheets.Schema.InsertRangeRequest;
    // Create a new instance of InterpolationPoint
    newInterpolationPoint(): Sheets.Schema.InterpolationPoint;
    // Create a new instance of IterativeCalculationSettings
    newIterativeCalculationSettings(): Sheets.Schema.IterativeCalculationSettings;
    // Create a new instance of LineStyle
    newLineStyle(): Sheets.Schema.LineStyle;
    // Create a new instance of ManualRule
    newManualRule(): Sheets.Schema.ManualRule;
    // Create a new instance of ManualRuleGroup
    newManualRuleGroup(): Sheets.Schema.ManualRuleGroup;
    // Create a new instance of MergeCellsRequest
    newMergeCellsRequest(): Sheets.Schema.MergeCellsRequest;
    // Create a new instance of MoveDimensionRequest
    newMoveDimensionRequest(): Sheets.Schema.MoveDimensionRequest;
    // Create a new instance of NamedRange
    newNamedRange(): Sheets.Schema.NamedRange;
    // Create a new instance of NumberFormat
    newNumberFormat(): Sheets.Schema.NumberFormat;
    // Create a new instance of OrgChartSpec
    newOrgChartSpec(): Sheets.Schema.OrgChartSpec;
    // Create a new instance of OverlayPosition
    newOverlayPosition(): Sheets.Schema.OverlayPosition;
    // Create a new instance of Padding
    newPadding(): Sheets.Schema.Padding;
    // Create a new instance of PasteDataRequest
    newPasteDataRequest(): Sheets.Schema.PasteDataRequest;
    // Create a new instance of PieChartSpec
    newPieChartSpec(): Sheets.Schema.PieChartSpec;
    // Create a new instance of PivotGroup
    newPivotGroup(): Sheets.Schema.PivotGroup;
    // Create a new instance of PivotGroupRule
    newPivotGroupRule(): Sheets.Schema.PivotGroupRule;
    // Create a new instance of PivotGroupSortValueBucket
    newPivotGroupSortValueBucket(): Sheets.Schema.PivotGroupSortValueBucket;
    // Create a new instance of PivotGroupValueMetadata
    newPivotGroupValueMetadata(): Sheets.Schema.PivotGroupValueMetadata;
    // Create a new instance of PivotTable
    newPivotTable(): Sheets.Schema.PivotTable;
    // Create a new instance of PivotValue
    newPivotValue(): Sheets.Schema.PivotValue;
    // Create a new instance of ProtectedRange
    newProtectedRange(): Sheets.Schema.ProtectedRange;
    // Create a new instance of RandomizeRangeRequest
    newRandomizeRangeRequest(): Sheets.Schema.RandomizeRangeRequest;
    // Create a new instance of RepeatCellRequest
    newRepeatCellRequest(): Sheets.Schema.RepeatCellRequest;
    // Create a new instance of Request
    newRequest(): Sheets.Schema.Request;
    // Create a new instance of RowData
    newRowData(): Sheets.Schema.RowData;
    // Create a new instance of SearchDeveloperMetadataRequest
    newSearchDeveloperMetadataRequest(): Sheets.Schema.SearchDeveloperMetadataRequest;
    // Create a new instance of SetBasicFilterRequest
    newSetBasicFilterRequest(): Sheets.Schema.SetBasicFilterRequest;
    // Create a new instance of SetDataValidationRequest
    newSetDataValidationRequest(): Sheets.Schema.SetDataValidationRequest;
    // Create a new instance of Sheet
    newSheet(): Sheets.Schema.Sheet;
    // Create a new instance of SheetProperties
    newSheetProperties(): Sheets.Schema.SheetProperties;
    // Create a new instance of SortRangeRequest
    newSortRangeRequest(): Sheets.Schema.SortRangeRequest;
    // Create a new instance of SortSpec
    newSortSpec(): Sheets.Schema.SortSpec;
    // Create a new instance of SourceAndDestination
    newSourceAndDestination(): Sheets.Schema.SourceAndDestination;
    // Create a new instance of Spreadsheet
    newSpreadsheet(): Sheets.Schema.Spreadsheet;
    // Create a new instance of SpreadsheetProperties
    newSpreadsheetProperties(): Sheets.Schema.SpreadsheetProperties;
    // Create a new instance of TextFormat
    newTextFormat(): Sheets.Schema.TextFormat;
    // Create a new instance of TextFormatRun
    newTextFormatRun(): Sheets.Schema.TextFormatRun;
    // Create a new instance of TextPosition
    newTextPosition(): Sheets.Schema.TextPosition;
    // Create a new instance of TextRotation
    newTextRotation(): Sheets.Schema.TextRotation;
    // Create a new instance of TextToColumnsRequest
    newTextToColumnsRequest(): Sheets.Schema.TextToColumnsRequest;
    // Create a new instance of TreemapChartColorScale
    newTreemapChartColorScale(): Sheets.Schema.TreemapChartColorScale;
    // Create a new instance of TreemapChartSpec
    newTreemapChartSpec(): Sheets.Schema.TreemapChartSpec;
    // Create a new instance of UnmergeCellsRequest
    newUnmergeCellsRequest(): Sheets.Schema.UnmergeCellsRequest;
    // Create a new instance of UpdateBandingRequest
    newUpdateBandingRequest(): Sheets.Schema.UpdateBandingRequest;
    // Create a new instance of UpdateBordersRequest
    newUpdateBordersRequest(): Sheets.Schema.UpdateBordersRequest;
    // Create a new instance of UpdateCellsRequest
    newUpdateCellsRequest(): Sheets.Schema.UpdateCellsRequest;
    // Create a new instance of UpdateChartSpecRequest
    newUpdateChartSpecRequest(): Sheets.Schema.UpdateChartSpecRequest;
    // Create a new instance of UpdateConditionalFormatRuleRequest
    newUpdateConditionalFormatRuleRequest(): Sheets.Schema.UpdateConditionalFormatRuleRequest;
    // Create a new instance of UpdateDeveloperMetadataRequest
    newUpdateDeveloperMetadataRequest(): Sheets.Schema.UpdateDeveloperMetadataRequest;
    // Create a new instance of UpdateDimensionGroupRequest
    newUpdateDimensionGroupRequest(): Sheets.Schema.UpdateDimensionGroupRequest;
    // Create a new instance of UpdateDimensionPropertiesRequest
    newUpdateDimensionPropertiesRequest(): Sheets.Schema.UpdateDimensionPropertiesRequest;
    // Create a new instance of UpdateEmbeddedObjectPositionRequest
    newUpdateEmbeddedObjectPositionRequest(): Sheets.Schema.UpdateEmbeddedObjectPositionRequest;
    // Create a new instance of UpdateFilterViewRequest
    newUpdateFilterViewRequest(): Sheets.Schema.UpdateFilterViewRequest;
    // Create a new instance of UpdateNamedRangeRequest
    newUpdateNamedRangeRequest(): Sheets.Schema.UpdateNamedRangeRequest;
    // Create a new instance of UpdateProtectedRangeRequest
    newUpdateProtectedRangeRequest(): Sheets.Schema.UpdateProtectedRangeRequest;
    // Create a new instance of UpdateSheetPropertiesRequest
    newUpdateSheetPropertiesRequest(): Sheets.Schema.UpdateSheetPropertiesRequest;
    // Create a new instance of UpdateSpreadsheetPropertiesRequest
    newUpdateSpreadsheetPropertiesRequest(): Sheets.Schema.UpdateSpreadsheetPropertiesRequest;
    // Create a new instance of ValueRange
    newValueRange(): Sheets.Schema.ValueRange;
    // Create a new instance of WaterfallChartColumnStyle
    newWaterfallChartColumnStyle(): Sheets.Schema.WaterfallChartColumnStyle;
    // Create a new instance of WaterfallChartCustomSubtotal
    newWaterfallChartCustomSubtotal(): Sheets.Schema.WaterfallChartCustomSubtotal;
    // Create a new instance of WaterfallChartDomain
    newWaterfallChartDomain(): Sheets.Schema.WaterfallChartDomain;
    // Create a new instance of WaterfallChartSeries
    newWaterfallChartSeries(): Sheets.Schema.WaterfallChartSeries;
    // Create a new instance of WaterfallChartSpec
    newWaterfallChartSpec(): Sheets.Schema.WaterfallChartSpec;
  }
}

declare var Sheets: GoogleAppsScript.Sheets;