返回 Google Sheets

将 Knoon AI 与 Google Sheets (Google) 连接以自动化 AI 工作流。

Find the first cell in a sheet that matches the given search criteria such as EQUALS, CONTAINS, STARTS_WITH, or ENDS_WITH.

googleSheetsFindFirstCell

测试版

权限

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

可选权限

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

参数

名称	类型	描述	必填
spreadsheetId	file	Select the Google Sheets file to search.	是的
sheetName	mustache	Name of the sheet (tab) to search in (e.g. "Sheet1").	是的
range	mustache	Optional A1 range (e.g. "A1:D100") to limit the search area. If omitted, the entire sheet is scanned.	没有
searchText	mustache	The text to search for inside the cells.	是的
matchType	string	How to compare the text: EQUALS, CONTAINS, STARTS_WITH, or ENDS_WITH.	是的
caseSensitive	boolean	Whether the match should be case-sensitive. Default is false.	没有

回报

名称	类型	描述
status	string	DONE.
found	boolean	Whether a matching cell was found.
cell.value	string	Matched cell value.
cell.sensitive.rowIndex	number	1-based row index.
cell.sensitive.columnIndex	number	1-based column index.
cell.sensitive.columnLetter	string	Column letter.
cell.sensitive.a1Notation	string	Cell location in A1 notation.