Find rows
Google Sheets Find Rows is a powerful AI tool designed to efficiently search and retrieve rows from your spreadsheets based on specific column values. It simplifies data management by enabling dynamic filtering and accurate data extraction within Google Sheets.
Features
- Supports searching by column header name or column letter for flexible querying.
- Allows three match types: exact, contains, and starts_with for precise search control.
- Returns matching rows as objects with their row numbers to facilitate further data operations like updates.
- Integrates seamlessly with Google Sheets, leveraging spreadsheet IDs and sheet names for targeted searches.
- User-friendly input schema ensures easy configuration and quick deployment without coding.
Benefits
- Enhances productivity by quickly locating relevant data within large spreadsheets.
- Improves data accuracy with customizable match criteria tailored to diverse needs.
- Streamlines workflow automation by providing row information for subsequent actions like updates.
- Reduces manual data handling, saving time and minimizing human errors.
- Facilitates better data organization and insights by enabling dynamic data retrieval.
Description
Search for rows matching a value in a specific column. Use Get Spreadsheet Info to discover column header names. Returns matching rows as objects with row numbers (useful for subsequent Update Rows calls). For simple reads without filtering, use Read Rows instead.
Parameters
5 parameters
| Name | Type | Description |
|---|---|---|
| spreadsheetIdrequired | string | The spreadsheet ID from the Google Sheets URL. |
| sheetNamerequired | string | The worksheet (tab) name. Use Get Spreadsheet Info to discover worksheet names. |
| columnrequired | string | Column header name (e.g., |
| searchValuerequired | string | The value to search for. |
| matchType | enum | How to match: |