Automatically If it contains rows, select next row according to a value

Google Sheets

Trigger

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.

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


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.

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.