Find row
Google Sheets Find Row is a powerful tool that allows users to quickly locate one or more rows within a spreadsheet by specifying a column and search value. This tool streamlines data retrieval, making spreadsheet management more efficient and precise.
Features
- Search rows by specifying any column letter and the value to find.
- Supports selecting spreadsheets from personal or Shared Drives.
- Allows targeting specific worksheets within a spreadsheet by worksheet ID.
- Option to export entire matching rows for comprehensive data access.
- Integrates seamlessly with Google Sheets API for reliable performance.
Benefits
- Saves time by automating row lookup processes in large spreadsheets.
- Enhances data accuracy by precisely locating rows based on column values.
- Improves workflow efficiency in data management tasks.
- Supports collaboration by working with Shared Drives and multiple worksheets.
- Facilitates integration into broader automation and data processing pipelines.
Description
Find one or more rows by a column and value. See the documentation
Parameters
6 parameters
| Name | Type | Description |
|---|---|---|
| drive | string | Defaults to You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-find-row, propName: drive. |
| sheetIdrequired | string | Select a spreadsheet or provide a spreadsheet ID You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-find-row, propName: sheetId. |
| worksheetIdrequired | integer | Select a worksheet or provide a worksheet ID You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-find-row, propName: worksheetId. |
| columnrequired | string | Column Letter |
| valuerequired | string | The value to search for |
| exportRow | boolean | Set to |