Google Sheets に戻る

Google Sheets (Google) と Knoon AI を接続して 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.