Implementing a Round Robin Value Assignment for Data Rows

Kate L. · 2024-09-05T15:26:27.579298+00:00

Hey everyone, wondering if there's a way to assign a value to a row, e.g. row 1, value = 1, through to row 4, value = 4, then from row 5 it's back to 1 again. Essentially want a way to send data from clay to instantly but "round robin" the campaign it's sent to so we can send from different people within the business.

Kate L.

·

Thinking the solution is probably:

1.
Use a formula on the Google sheet we add contacts to & assign the value here
2.
Lookup that value on the google sheet
3.
Restrict running campaign col based on the returned number

Muhammad S.

·

Generate a random number from 1-5 and assign the campaigns depending on the randomly generated number. it wont be perfectly 1-5 each time but will serve the rounrobin purpose of distributing leads to different campaigns/people