Google Sheets Search
This action is used to search a column in a google spreadsheet. Only matching cells from the specified tab and column will be searched and returned, this includes user-entered column headers.
Google Sheet APIIn order to use this action the steps to enable a new client or project listed here must be completed.
Spreadsheet FormattingValues can be searched in a spreadsheet even if some columns or rows are hidden. Matching cells will be returned from these ranges as well.
Inputs
Name | Type | Description |
|---|---|---|
Spreadsheet ID | String | ID of the spreadsheet to search. This ID can be found in the url of the sheet. |
Spreadsheet Tab | String | Tab in the spreadsheet to search. This will be the title of the tab/sheet. |
Search Column | String | The alphabetic index of the column to search (A for first column) |
Credentials | Object | The json api credentials associated with this project. Can be found using the steps here |
Search Value | String | Value to search |
Outputs
Name | Type | Description |
|---|---|---|
Success | Boolean | True if any matches were found, False if results list is empty |
Rows | Object | List of cells which match the search value. |
Updated 13 days ago