Data-level Operations
Operations related to rows, cells, or data content
Last updated
Was this helpful?
Operations related to rows, cells, or data content
Last updated
Was this helpful?
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".
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:
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: