Google Sheets en Skyller.

Mostrando 12 de 45

• Add Sheet to Existing Spreadsheet

  GOOGLESHEETS_ADD_SHEET

  Adds a new sheet to a spreadsheet. Supports three sheet types: GRID, OBJECT, and DATA_SOURCE. SHEET TYPES:

• Aggregate Column Data

  GOOGLESHEETS_AGGREGATE_COLUMN_DATA

  Searches for rows where a specific column matches a value and performs mathematical operations on data from another column.

• Append Dimension

  GOOGLESHEETS_APPEND_DIMENSION

  Tool to append new rows or columns to a sheet, increasing its size. Use when you need to add empty rows or columns to an existing sheet.

• Auto-Resize Rows or Columns

  GOOGLESHEETS_AUTO_RESIZE_DIMENSIONS

  Auto-fit column widths or row heights for a dimension range using batchUpdate.autoResizeDimensions. Use when you need to automatically adjust row heights or column widths to fit content after writing data.

• Batch Clear Values By Data Filter

  GOOGLESHEETS_BATCH_CLEAR_VALUES_BY_DATA_FILTER

  Clears one or more ranges of values from a spreadsheet using data filters. The caller must specify the spreadsheet ID and one or more DataFilters. Ranges matching any of the specified data filters will be cleared.

• Batch get spreadsheet

  GOOGLESHEETS_BATCH_GET

  Retrieves data from specified cell ranges in a Google Spreadsheet.

• Batch Update Values by Data Filter

  GOOGLESHEETS_BATCH_UPDATE_VALUES_BY_DATA_FILTER

  Tool to update values in ranges matching data filters. Use when you need to update specific data in a Google Sheet based on criteria rather than fixed cell ranges.

• Clear Basic Filter

  GOOGLESHEETS_CLEAR_BASIC_FILTER

  Tool to clear the basic filter from a sheet. Use when you need to remove an existing basic filter from a specific sheet within a Google Spreadsheet.

• Clear spreadsheet values

  GOOGLESHEETS_CLEAR_VALUES

  Clears cell content (preserving formatting and notes) from a specified A1 notation range in a Google Spreadsheet; the range must correspond to an existing sheet and cells.

• Create Chart in Google Sheets

  GOOGLESHEETS_CREATE_CHART

  Create a chart in a Google Sheets spreadsheet using the specified data range and chart type. Conditional requirements:

• Create a Google Sheet

  GOOGLESHEETS_CREATE_GOOGLE_SHEET1

  Creates a new Google Spreadsheet in Google Drive. If a title is provided, the spreadsheet will be created with that name.

• Create spreadsheet column

  GOOGLESHEETS_CREATE_SPREADSHEET_COLUMN

  Creates a new column in a Google Spreadsheet. Specify the target sheet using sheet_id (numeric) or sheet_name (text). If neither is provided, defaults to the first sheet (sheet_id=0).