Apps/Google Sheets/Find a row according to a column value
Google Sheets
Google Sheets Action

Find 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.

200+ apps to connect·Tested & maintained tasks·Human support in English & Spanish

In detail

What it does and what it's for

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.
  • If no row matches, this step still answers: the Row found tag is set to no and the task carries on. To stop the task in that case, add the rule “Row found = yes” on the next step. If your task predates this change, that rule is already in place — we added it so the task would keep behaving as before.

Already using Botize?

Connect your Google Sheets

Add a profile to use it in your tasks. There's a step-by-step guide if you need it.

Add a new profile Step-by-step guide

Your profiles

Your connected Google Sheets accounts

These are the accounts you already have linked to Botize, ready to use in your tasks. You can reconnect or remove any of them.

Setup

Customization options

Fields you can adjust when using it 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

Output data

Information provided

When executed, this operation delivers the following data, which can be used in the same automatic task.

  • Tags

  • Row found {{found}}

  • 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}}

Learn by watching

Video tutorials

Short videos where you watch a real task being built from start to finish.

Need a hand?

Real people behind it

Email us

info@botize.com
Monday to Friday from 7 a.m. to 1 p.m. (Spain).

Message us on Telegram

t.me/botizesupport
Monday to Friday from 7 a.m. to 1 p.m. (Spain).

Come with an idea.
Leave with an automation.

Create your first task in minutes. Do it once and forget about it forever.

Start automating