gspreadsheet

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.

Google Sheets Trigger




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





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




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.

Write us

By email or by Telegram.
Monday to Friday from 7 a.m. to 1 p.m. (Spain).

Let's talk

Choose day and time.
We share the screen and answer all your questions.