GoogleSheets

Google Sheets is a spreadsheet program that is part of the free web-based Google applications to create and format spreadsheets. Use this integration to create and modify spreadsheets.

Utilities · Google Sheets

Configuration parameters

  • service_account_credentials — (required)
  • insecure — Trust any certificate (not secure)
  • proxy — Use system proxy settings
  • user_id — Email - Associate to Google Drive

Commands (14)

  • google-sheets-data-paste

    Inserts data into the spreadsheet starting at the specified coordinate.

  • google-sheets-dimension-delete

    Deletes the dimensions from the sheet. Note that the indexing starts from 0.

  • google-sheets-find-replace

    Finds and replaces data in cells over a range, sheet, or all sheets.

  • google-sheets-range-delete

    Deletes a range of cells, shifting other cells into the deleted area.

  • google-sheets-sheet-clear

    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.

  • google-sheets-sheet-copy-to

    Copies a single sheet from a spreadsheet to another spreadsheet.

  • google-sheets-sheet-create

    Adds a new sheet. When a sheet is added at a given index, all subsequent sheet indexes are incremented.

  • google-sheets-sheet-delete

    Delete a sheet from a spreadsheet by ID.

  • google-sheets-sheet-duplicate

    Duplicates the contents of a sheet.

  • google-sheets-spreadsheet-create

    Create a new spreadsheet.

  • google-sheets-spreadsheet-get

    Returns the spreadsheet of the given ID. If include_grid_data is set to true and no ranges given, will defaultly return the first 500 rows and 20 columns of the first sheet.

  • google-sheets-spreadsheet-update

    This is a custom update command, used to apply any of the Google Sheets API options. Applies one or more updates to the spreadsheet. Each request is validated before being applied. If any request is not valid, the entire request will fail and nothing will be applied.

  • google-sheets-value-append

    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 (https://developers.google.com/sheets/api/guides/values#appending_values) and sample code (https://developers.google.com/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.

  • google-sheets-value-update

    Sets values in a range of a spreadsheet. The caller must specify the spreadsheet ID, range, and a valueInputOption.