
Get a row according to a column value
Extract first row of a sheet where a certain column has a specific value, such as a number, a text, empty value, etc.
Google Sheets Action
This integration allows you to automate the extraction of data from a Google Sheets spreadsheet based on the value of a specific column. You can set up rules to trigger the automation only when certain conditions are met, such as when a column contains a specific value, is empty, or does not contain a specific value. Additionally, you can limit the search to a specific sheet or apply it to all sheets in the document.
When this action is executed, you will obtain the data from the row that matches the established criteria, facilitating the management and analysis of information in your spreadsheets without the need for manual intervention. This functionality is particularly useful for tasks such as searching for specific records, updating data, or generating reports based on particular conditions.
- You can limit the search of the rows to a specific sheet or to all of them.
Customization Options
Configurable fields you can adjust in your automation
- Rules
- Run this step only if the following rules are met
- URL of your sheet document
- Exclude first row
- Fast! Improve speed by not processing spreadsheet formulas
- Only rows that have certain values in this column.
- Filters
- Sheet select mode
- Sheet Number
- Sheet name
- Customize tags
- Customize output variables
Information provided
When executed, this operation delivers the following data, which can be used in the same automatic task.
Tags
- Column A {{column_a}}
- Column B {{column_b}}
- Column C {{column_c}}
- Column D {{column_d}}
- Column E {{column_e}}
- Column F {{column_f}}
- Column G {{column_g}}
- Column H {{column_h}}
- Column I {{column_i}}
- Column J {{column_j}}
- Column K {{column_k}}
- Column L {{column_l}}
- Column M {{column_m}}
- Column N {{column_n}}
- Column O {{column_o}}
- Column P {{column_p}}
- Column Q {{column_q}}
- Column R {{column_r}}
- Column S {{column_s}}
- Column T {{column_t}}
- Column U {{column_u}}
- Column V {{column_v}}
- Column W {{column_w}}
- Column X {{column_x}}
- Column Y {{column_y}}
- Column Z {{column_z}}
- Number of Row {{row}}
- Sheet name {{sheet}}
Let's talk
Choose day and time.
We share the screen and answer all your questions.