Apps/Google Sheets/Extract the next new row according to a value
Google Sheets
Google Sheets Trigger

Extract the next new row according to a value

Extract one by one, sequentially, each 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 sequential extraction of rows in Google Sheets, filtering by specific values in a designated column. You can configure the search to apply to a specific sheet or to all sheets in your document.

Upon execution, this operation delivers data such as the content of each column and the row number, which can be utilized in other automated tasks. Additionally, customization options and solutions to common errors are provided to optimize your workflow.



  • You can limit the search of the rows to a specific sheet or to all of them.

How it works

How it fits in an automated task

A Botize task pairs a trigger with one or more actions. This piece is one of them.

This is the trigger

Every time this event happens, the task kicks off on its own. You don't have to do anything.

Add one or more actions

What should happen next, in this app or in any of the 200+ connectable apps.

Turn it on and forget it

The task runs on its own from then on. If something's off, tweak it or we'll help you.

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
Filters for conditional step execution
URL of your sheet document
Exclude first row
Do not process cell formulas
Start from the last row
Sheet selection mode
Sheet Number (if selected by position)
Sheet name (if selected by name)
Column letter to filter by
Row filters configuration
Restart rules

Troubleshooting

Error messages and suggestions to fix it.


Output data

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 (DEPRECATED) {{row_number}}

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

Get inspired

Ready-to-use automations

Real tasks built with Google Sheets: switch them on in minutes and tweak them to your liking.

  • type
  • gspreadsheet → search_row_by_column_v2
  • telegrambot → send_message_photo
Post the rows that match a certain value to Telegram

Common Errors


Quota exceeded for quota metric 'Read requests' and limit 'Read requests per minute per user'

The quota and the limit of 'Read requests per minute per user' has been reached. Please note that the Google Sheets API currently imposes a maximum allowance of 60 queries per minute per user

HTTP Internal error code 28

The request has exceeded the maximum timeout of 10 seconds while waiting for a response from Google Sheets. This could be due to several reasons:

The spreadsheet is too large, which can cause Google Sheets to respond slowly if it contains hundreds or thousands of records or a lot of text in its various columns.

Complex formulas have been used in some cells. Some Excel formulas may take several seconds to complete, or there may be scripts, applications, or custom functions associated with different cells that require additional time to run, including external calls, which can slow down the response of Google Sheets. You can consider checking the 'Do not process cell formulas' option in the task settings.

The specified sheet does not exist in the spreadsheet

The automatic task has provided a sheet name or number that does not exist in the spreadsheet.

Please verify that there is indeed a sheet with the same name or number in the spreadsheet as specified in the task.

FAILED_PRECONDITION - This operation is not supported for this document

This error usually means that the file you're using is not in Google Sheets format, but instead saved as an XLSX (Excel) file.

To fix it, simply open the document in Google Drive and choose File > Save as Google Sheets. Once the file is in the correct format, Botize will be able to access it and run the automation properly.

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/botize
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