Google Sheets Tools の Googlesheets Aggregate Column Data |…

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…

Googlesheets Aggregate Column Data

プロバイダーの説明

Googlesheets Aggregate Column Data

プロバイダーの説明

料金と制限

入力

確認できる出力

この Action を使用する Skills

この Action を使用する Skills

関連ユースケース

公式ソース

この Action を使用する Skills