Tool
Find row
The Google Sheets Find Row tool enables users to quickly locate one or multiple rows in a spreadsheet by searching a specific column for a given value. This integration is ideal for automating data retrieval and streamlining spreadsheet workflows.
Features
- Search rows by specifying a column letter and matching value.
- Supports selection of custom Shared Drives or default to My Drive.
- Option to return the entire row's cell values for comprehensive data access.
- Seamlessly integrates with Google Sheets API for efficient spreadsheet management.
- User-friendly setup with configurable spreadsheet, worksheet, and drive options.
Benefits
- Enhances productivity by automating row search processes in spreadsheets.
- Reduces manual errors associated with data lookup tasks.
- Speeds up data-driven decision-making with instant access to relevant rows.
- Flexible configuration supports diverse spreadsheet structures and permissions.
- Simplifies integration into existing workflows for effortless data management.
Description
Find one or more rows by a column and value. See the documentation
Parameters
6 parameters
| Name | Type | Description |
|---|---|---|
| drive | string | Defaults to |
| sheetIdrequired | string | Select a spreadsheet or provide a spreadsheet ID |
| worksheetIdrequired | string | Select a worksheet or provide a worksheet ID |
| columnrequired | string | Column Letter |
| valuerequired | string | The value to search for |
| exportRow | boolean | Set to |