Sign up
All data sources

Google Sheets

Your account

Eight direct, bounded Google Sheets API v4 primitives authorized by drive.file for spreadsheets PatchOps created or the user explicitly opened. The model selects the method and supplies exact spreadsheet IDs and A1 ranges. Reads are response-capped; writes use closed schemas, bounded cell counts, and bounded JSON bodies. Generic batchUpdate is not exposed as an unchecked escape hatch.

Set up this sourceGet the full contract and schemas as JSON

Sign in with your Google Sheets account. Included on Free.

What you can ask

  • “What does Google Sheets have for the area or asset I'm working on?”
  • “Pull the most recent Google Sheets records and put them in a table.”
  • “What does Google Sheets cover, and how fresh is the data?”

About this source

Eight direct, bounded Google Sheets API v4 primitives authorized by drive.file for spreadsheets PatchOps created or the user explicitly opened. The model selects the method and supplies exact spreadsheet IDs and A1 ranges. Reads are response-capped; writes use closed schemas, bounded cell counts, and bounded JSON bodies. Generic batchUpdate is not exposed as an unchecked escape hatch.

Connector ID sheets

Provenance

PublisherGoogle Sheets
API basehttps://sheets.googleapis.com/

Freshness & coverage

FreshnessFreshness not declared
GeographicNot declared
TemporalNot declared
AuthenticationCredentials required (OAuth)

› Methods (18)

Technical detail for developers: parameters, pagination, units, and freshness per method.

  • getSpreadsheet

    read

    Get bounded spreadsheet metadata; grid data is omitted unless explicitly requested and ranges can constrain it.

    Required paramsspreadsheetId
    Paginationnone

  • getSheetValues

    read

    Read one bounded A1 range using exact Sheets value-rendering options.

    Required paramsspreadsheetIdrange
    Paginationnone

  • batchGetSheetValues

    read

    Read up to 50 bounded A1 ranges in one exact Sheets batchGet request.

    Required paramsspreadsheetIdranges
    Paginationnone

  • createSpreadsheet

    write

    Create one spreadsheet with up to 20 explicitly bounded initial sheets.

    Required paramstitle
    Paginationnone

  • updateCells

    write

    Replace values in one exact A1 range; accepts at most 100,000 scalar cells and a 2 MB JSON body.

    Required paramsspreadsheetIdrangevalues
    Paginationnone

  • appendRows

    write

    Append bounded rows to the table found in one exact A1 range.

    Required paramsspreadsheetIdrangevalues
    Paginationnone

  • createSheet

    write

    Add one named sheet tab with optional bounded grid dimensions.

    Required paramsspreadsheetIdtitle
    Paginationnone

  • formatRange

    write

    Apply a closed subset of CellFormat to one sheet-qualified A1 range such as Sheet1!A1:D10 or 'Q1 Budget'!A1:D10.

    Required paramsspreadsheetIdrangeformat
    Paginationnone

  • spreadsheets_developermetadata_get

    read

    Official sheets.spreadsheets.developerMetadata.get operation. Returns the developer metadata with the specified ID. The caller must specify the spreadsheet ID and the developer metadata's unique metadataId. For more information, see [Read, write, and search metadata](https://developers.google.com/workspace/sheets/api/guides/metadata).

    Required paramsmetadataIdspreadsheetId
    Paginationnone

  • spreadsheets_getbydatafilter

    read

    Official sheets.spreadsheets.getByDataFilter operation. Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. For more information, see [Read, write, and search metadata](https://developers.google.com/workspace/sheets/api/guides/metadata). 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 returns the portions of the spreadsheet that intersect ranges matched by any of the filters. By default, data within grids is not returned. You can include grid data in one of two ways: * Specify a [field mask](https://developers.google.com/workspace/sheets/api/guides/field-masks) 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, as a best practice, retrieve only the specific spreadsheet fields that you want.

    Required paramsspreadsheetIdbody
    Paginationnone

  • spreadsheets_sheets_copyto

    write

    Official sheets.spreadsheets.sheets.copyTo operation. Copies a single sheet from a spreadsheet to another spreadsheet. Returns the properties of the newly created sheet.

    Required paramssheetIdspreadsheetIdbody
    Paginationnone

  • spreadsheets_values_batchclear

    write

    Official sheets.spreadsheets.values.batchClear operation. 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 and data validation) are kept.

    Required paramsspreadsheetIdbody
    Paginationnone

  • spreadsheets_values_batchclearbydatafilter

    write

    Official sheets.spreadsheets.values.batchClearByDataFilter operation. Clears one or more ranges of values from a spreadsheet. For more information, see [Read, write, and search metadata](https://developers.google.com/workspace/sheets/api/guides/metadata). 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.

    Required paramsspreadsheetIdbody
    Paginationnone

  • spreadsheets_values_batchgetbydatafilter

    read

    Official sheets.spreadsheets.values.batchGetByDataFilter operation. Returns one or more ranges of values that match the specified data filters. For more information, see [Read, write, and search metadata](https://developers.google.com/workspace/sheets/api/guides/metadata). 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.

    Required paramsspreadsheetIdbody
    Paginationnone

  • spreadsheets_values_batchupdate

    write

    Official sheets.spreadsheets.values.batchUpdate operation. Sets values in one or more ranges of a spreadsheet. The caller must specify the spreadsheet ID, a valueInputOption, and one or more ValueRanges.

    Required paramsspreadsheetIdbody
    Paginationnone

  • spreadsheets_values_batchupdatebydatafilter

    write

    Official sheets.spreadsheets.values.batchUpdateByDataFilter operation. Sets values in one or more ranges of a spreadsheet. For more information, see [Read, write, and search metadata](https://developers.google.com/workspace/sheets/api/guides/metadata). The caller must specify the spreadsheet ID, a valueInputOption, and one or more DataFilterValueRanges.

    Required paramsspreadsheetIdbody
    Paginationnone

  • spreadsheets_values_clear

    write

    Official sheets.spreadsheets.values.clear operation. 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.

    Required paramsrangespreadsheetIdbody
    Paginationnone