Data-level Operations

Operations related to rows, cells, or data content

1. Lookup Spreadsheet Row

Component settings

Parameter Name	Description
Credentials	Connect your Google account to authorize access to Google Sheets. Required to perform any actions.
Action	Select the action: - Lookup Spreadsheet Row
Spreadsheet ID	Input the "Spreadsheet ID" you want to get the info
Query	Input the Query Example: "An" → Find rows that contain the word "An". "=23" → Find rows with a cell that contains the number 23. "=B2='Nam'" → Find rows where cell B2 contains the value "Nam".

2. Batch Get

Component settings

Parameter Name	Description
Credentials	Connect your Google account to authorize access to Google Sheets. Required to perform any actions.
Action	Select the action: - Batch Get
Spreadsheet ID	Input the "Spreadsheet ID" you want to get the info
Ranges	Input the ranges you want to get info Ex: [ "Sheet1!A1:C5", "Sheet2!A1:B10

3. Batch Update

Component settings

Parameter Name	Description
Credentials	Connect your Google account to authorize access to Google Sheets. Required to perform any actions.
Action	Select the action: - Batch Update
Spreadsheet ID	Input the "Spreadsheet ID" you want to update
Sheet Name	Input the "Sheet Name" you want to update
Values	Input the value you want to update Example: [ [ "name", "age", "class" ], [ "An", 18, "12A1" ], [ "Binh", 17, "11B2" ] ]