Google Sheets
GOOGLESHEETS_AGGREGATE_COLUMN_DATA
Searches for rows where a specific column matches a value and performs mathematical operations on data from another column.
Remote googlesheets
Other tools also called GOOGLESHEETS_AGGREGATE_COLUMN_DATA?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"operation": {
"enum": [
"sum",
"average",
"count",
"min",
"max",
"percentage"
],
"type": "string",
"description": "The mathematical operation to perform on the target column values.\nExamples:\n \"sum\"\n \"average\"\n \"count\"\n \"min\"\n \"max\"\n \"percentage\""
},
"sheet_name": {
"type": "string",
"description": "The name of the specific sheet within the spreadsheet.\nExamples:\n \"Sheet1\"\n \"Sales Data\""
},
"search_value": {
"type": "string",
"description": "The exact value to search for in the search column. Case-sensitive by default.\nExamples:\n \"HSR\"\n \"Sales\"\n \"North Region\""
},
"search_column": {
"type": "string",
"description": "The column to search in. Can be a letter (e.g., 'A', 'B') or column name from header row (e.g., 'Region', 'Department').\nExamples:\n \"A\"\n \"Region\"\n \"Department\""
},
"target_column": {
"type": "string",
"description": "The column to aggregate data from. Can be a letter (e.g., 'C', 'D') or column name from header row (e.g., 'Sales', 'Revenue').\nExamples:\n \"D\"\n \"Sales\"\n \"Revenue\""
},
"case_sensitive": {
"type": "boolean",
"default": true,
"description": "Whether the search should be case-sensitive.\nExamples:\n true\n false"
},
"has_header_row": {
"type": "boolean",
"default": true,
"description": "Whether the first row contains column headers. If True, column names can be used for search_column and target_column.\nExamples:\n true\n false"
},
"spreadsheet_id": {
"type": "string",
"description": "The unique identifier of the Google Sheets spreadsheet.\nExample: \"1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms\""
},
"percentage_total": {
"type": [
"number",
"null"
],
"default": null,
"description": "For percentage operation, the total value to calculate percentage against. If not provided, uses sum of all values in target column.\nExamples:\n 10000\n 50000.5"
}
}
}