how to pick random row in google sheet

how can i pick a random row in google sheet everytime workflow runs.

I got this. I used Random number to get a row of spreadsheet. thank you!

Hey @serwar24554,

You can generate a random number using Number Formatter (Pabbly) → Spreadsheet Formulas by applying the formula:

[TABLE]
[TR]
[TD]RANDBETWEEN[/TD]

[TD]RANDBETWEEN(-1, 1)[/TD]

[TD][Random integer between bottom and top][/TD]
[/TR]
[/TABLE]

This will return a random integer between the specified bottom and top values. Once the random number is generated, you can map it in the Google Sheets: Get Row(s) action to fetch the corresponding row from your sheet.

Please try this approach and let us know if you need any further clarification.

thank you. i was able to generate a random row. now how do i map the row by generated random number to delete exact row. because i believe if i have to delete row 8 then i would have to mention two numbers 7 and 8. then it will delete row 8. i have the number 8 but i dont have any number 7 that i could map. so i dont know how i delete the row 8. please advise.

i resolved it. i used subtraction to get 1 number lower.

Hey @serwar24554,

Thanks for the update.