Googlesheets Aggregate Column Data

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

料金

無料 Action

統合支払い

現在未対応

• operationstring

  必須
  The mathematical operation to perform on the target column values.
• sheet_namestring

  必須
  The name of the specific sheet within the spreadsheet. Matching is case-insensitive. If no exact match is found, partial matches will be attempted (e.g., 'overview' will match 'Overview 2025').
• search_valuestring
  The exact value to search for in the search column. Case-sensitive by default. If not provided (or if search_column is not provided), all rows in the target column will be aggregated without filtering.
• search_columnstring
  The column to search in for filtering rows. Can be a letter (e.g., 'A', 'B') or column name from header row (e.g., 'Region', 'Department'). If not provided, all rows in the target column will be aggregated without filtering.
• target_columnstring

  必須
  The column to aggregate data from. Can be a letter (e.g., 'C', 'D') or column name from header row (e.g., 'Sales', 'Revenue').
• case_sensitiveboolean
  Whether the search should be case-sensitive.
• has_header_rowboolean
  Whether the first row contains column headers. If True, column names can be used for search_column and target_column.
• spreadsheet_idstring

  必須
  The unique identifier of the Google Sheets spreadsheet.
• percentage_totalnumber
  For percentage operation, the total value to calculate percentage against. If not provided, uses sum of all values in target column.
• additional_filtersarray
  Extra column=value conditions applied with AND logic on top of search_column/search_value. Use this to filter on multiple columns simultaneously. Example: [{"column": "Region", "value": "APAC"}] combined with search_column=Product/search_value=Beacon returns only rows where Prod…

• data

  必須
  Data from the action execution
• errorstring
  Error if any occurred during the execution of the action
• successfulboolean

  必須
  Whether or not the action execution was successful or not

検証済みの関連ユースケースはまだリンクされていません。