Apps/Google Sheets/Extract a random row
Google Sheets
Google Sheets Trigger

Extract a random row

Extract randomly each row of a sheet.

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 randomly extract rows from a Google Sheets spreadsheet, facilitating data selection without manual intervention. You can set filters to include or exclude rows based on specific values, thereby optimizing the process according to your needs.

Additionally, the function memorizes the last 10 extracted rows, preventing repetitions and ensuring a truly random selection. This tool is ideal for automating tasks that require unpredictable and efficient data selection.



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

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.

URL of your sheet document
Exclude first row
Fast! Improve speed by not processing spreadsheet formulas
Filter rows based on column values
Filters
How to select the sheet
Sheet Number
Sheet name

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.


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

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 → read_random_row
  • linkedin → post_link
Publish content to LinkedIn from a Google Sheets sheet
  • type
  • gspreadsheet → read_random_row
  • telegrambot → send_message_photo
Every hour post a random row of a spreadsheet on a Telegram channel

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