Aggregate Cells

Google / Google Sheets

Aggregate Cells

Aggregate values within a specific A1 range in a Google Sheet (e.g. SUM, AVG, MIN, MAX, COUNT, ARRAY_AGG, STRING_AGG).

googleSheetsAggregateCells

Permissions

Optional permissions

There are no items to display.

Parameters

Name	Type	Description	Required
spreadsheetId	file	Select the Google Sheets file that contains the range to aggregate.	Yes
sheetName	mustache	Name of the sheet (tab) to read from (e.g. "Sheet1").	Yes
range	mustache	A1 range to aggregate (e.g. "A2:A100", "B2:D10").	Yes
aggregation	string	Aggregation function to apply to the cells in the range.	Yes
delimiter	mustache	Delimiter to use for STRING_AGG. Ignored for other aggregation types.	No
topN	mustache	Number of top values to return for APPROX_TOP_COUNT. Ignored for other aggregation types.	No
numQuantiles	mustache	Number of quantiles for APPROX_QUANTILES (e.g. 4 = quartiles). Ignored for other aggregation types.	No

Returns

Name	Type	Description
status	string	DONE.
result	any	Aggregation result. For SUM/AVG/MIN/MAX/COUNT/COUNT(DISTINCT) returns a number. For STRING_AGG returns a string. For ARRAY_AGG returns an array of values. For APPROX_TOP_COUNT returns an array of { value, count } objects. For APPROX_QUANTILES returns an array of numeric quantile boundaries.

Step 01

Open your tool setup

Start from the tool workspace where you want to add a new app.

Step 02

Go to tools and create button

Open the Tools page, then click the Create button to start adding a new app.

Step 03

Choose Internal or External work

Choose Internal or External work, then select an app action.

Step 04

Select app to install to Knoon

Pick the app you want to install to Knoon and complete the setup flow.

Step 05

Success!

The app has been installed successfully and is ready to use in your workflow.

Power your business with Knoon's Agentic AI today.

Join businesses already resolving thousands of customer inquiries and sales leads with Knoon.

See how to install an app in your tool