how to pick random row in google sheet

[serwar24554]

Consent to Access & Modify

I authorize Pabbly Support to log in to my account and make changes to the specified workflow for troubleshooting.

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

 

[serwar24554]

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

hi can you tell me how you did this?

 

[Preeti Paryani]

Hey @serwar24554,

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

RANDBETWEEN

RANDBETWEEN(-1, 1)

[Random integer between bottom and top]

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.

 

[serwar24554]

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.

 

[serwar24554]

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

 

[Preeti Paryani]

Hey @serwar24554,

Thanks for the update.