Automatically If it contains rows, select a random one

Google Sheets

Trigger

Extract randomly each row of a sheet.

  • You can exclude rows that contain or do not contain certain words or values.



Extract random rows avoiding repetitions

Although the rows are selected in strict random order, we memorize the last 10 rows extracted, thus avoiding reselecting them. In the case of spreadsheets with less than 10 rows, the memory is reset when there are no new rows to select.


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


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.