Google Sheets로 돌아가기

Knoon AI를 Google Sheets (Google)과 연결하여 AI 워크플로우를 자동화하세요.

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

googleSheetsAggregateCells

베타

권한

https://www.googleapis.com/auth/drive.file

선택사항 권한

https://www.googleapis.com/auth/drive

매개변수

이름	유형	설명	필수
spreadsheetId	file	Select the Google Sheets file that contains the range to aggregate.	네
sheetName	mustache	Name of the sheet (tab) to read from (e.g. "Sheet1").	네
range	mustache	A1 range to aggregate (e.g. "A2:A100", "B2:D10").	네
aggregation	string	Aggregation function to apply to the cells in the range.	네
delimiter	mustache	Delimiter to use for STRING_AGG. Ignored for other aggregation types.	아니요
topN	mustache	Number of top values to return for APPROX_TOP_COUNT. Ignored for other aggregation types.	아니요
numQuantiles	mustache	Number of quantiles for APPROX_QUANTILES (e.g. 4 = quartiles). Ignored for other aggregation types.	아니요

반환값

이름	유형	설명
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.