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.
-
addHow to loop through the rows of an empty column?The last row of a spreadsheet always depends on the column you select.
If the selected column is completely empty then the spreadsheet will not contain any rows, even if there are values in other columns.
To loop through all the rows in an empty column, always add a value to the end of the column. In this way, the spreadsheet will be considered to contain rows.
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.Let's talk
Choose day and time.
We share the screen and answer all your questions.