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.

Category

Utilities

Pack

GoogleSheets

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.