Get random value from Google Sheet Get Range Values

How To
, ,
1

I’m trying to get a random value from a Google Sheet.

My Google Sheet has one column (A) with many rows.

I’m using Get Range Values to get all values. Then I want to get a random value and set a variable but it doesn’t work.

Is it possible to do this with Set Variable? If yes how can i proceed?

2

Aggregate to an array, then use shuffle-first functions.

For more information, see Search results for '@samliew shuffle first' - Make Community

Hope this helps! Let me know if there are any further questions or issues.

— @samliew