Google Super
GOOGLESUPER_AGGREGATE_COLUMN_DATA
Searches for rows where a specific column matches a value and performs mathematical operations on data from another column.
Remote googlesuper
Other tools also called GOOGLESUPER_AGGREGATE_COLUMN_DATA?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"operation": {
"enum": [
"sum",
"average",
"count",
"min",
"max",
"percentage"
],
"type": "string",
"title": "Operation",
"examples": [
"sum",
"average",
"count",
"min",
"max",
"percentage"
],
"description": "The mathematical operation to perform on the target column values."
},
"sheet_name": {
"type": "string",
"title": "Sheet Name",
"examples": [
"Sheet1",
"Sales Data"
],
"description": "The name of the specific sheet within the spreadsheet."
},
"search_value": {
"type": "string",
"title": "Search Value",
"examples": [
"HSR",
"Sales",
"North Region"
],
"description": "The exact value to search for in the search column. Case-sensitive by default."
},
"search_column": {
"type": "string",
"title": "Search Column",
"examples": [
"A",
"Region",
"Department"
],
"description": "The column to search in. Can be a letter (e.g., 'A', 'B') or column name from header row (e.g., 'Region', 'Department')."
},
"target_column": {
"type": "string",
"title": "Target Column",
"examples": [
"D",
"Sales",
"Revenue"
],
"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')."
},
"case_sensitive": {
"type": "boolean",
"title": "Case Sensitive",
"default": true,
"examples": [
true,
false
],
"description": "Whether the search should be case-sensitive."
},
"has_header_row": {
"type": "boolean",
"title": "Has Header Row",
"default": true,
"examples": [
true,
false
],
"description": "Whether the first row contains column headers. If True, column names can be used for search_column and target_column."
},
"spreadsheet_id": {
"type": "string",
"title": "Spreadsheet Id",
"examples": [
"1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"
],
"description": "The unique identifier of the Google Sheets spreadsheet."
},
"percentage_total": {
"type": "number",
"title": "Percentage Total",
"default": null,
"examples": [
10000,
50000.5
],
"nullable": true,
"description": "For percentage operation, the total value to calculate percentage against. If not provided, uses sum of all values in target column."
}
}
}