Get a row according to a column value
Google Sheets
Action
Extract first row of a sheet where a certain column has a specific value, such as a number, a text, empty value, etc.
- You can limit the search of the rows to a specific sheet or to all of them.
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}}
Related automations
Find information in a spreadsheet and submit it to Dialogflow
Upon receiving an ASIN, respond with the affiliate link according to the Telegram user
Search a record in the database for the name, email or profile indicated
Bot that searches for users in Google Sheets and responds with their data if they are in the database; if not, it adds them to the sheet
Send publish followed by an ASIN code
Bot Adding Amazon products to Sheets
Let's talk
Choose day and time.
We share the screen and answer all your questions.