Random rows from a long list

How To
1

Hi everyone,

I’m building a Words of the Day e-mail automation for a language study group from a long list of arabic words in a specific dialect I scraped from different websites. The list is being continuously expanded.

The part is where I’m stuck is that I can’t get Make.com to randomize the rows from me, gets the 10th, 100th, 1000th, 1001st, 1002nd etc. The words are categorized in the Sheet, so I’d prefer if they were random in the e-mails.

I have a column where I checkmark if the word is already been sent.

Any ideas?

Thank you!

2

Hey Omar,

you can find a variable called “random” under math functions. You can use it to create a formula that will get you a random row from the sheet.

3

Hey Stoyan,
Thank you, that I have done so far. My problem is that I need 5 of them, and need to check if they haven’t been sent yet, and then save the bundles individually.

4

Use a Search row module that returns only the rows that haven’t been sent yet followed by an aggregator to build an array, shuffle the array and get the first (or last, or whichever you want) 5 items, then update the sheet that these 5 have been sent already.

1 Like