Skip to main content

I want to build a round robin type of zap but for hundreds of people which is why I’m hesitant to use the Storage function. 

Ideally, I would be able to post a trigger word into a designated Slack channel and the zap would pull a random name from a spreadsheet that hasn’t been used yet. I would be able to post the trigger word multiple times if need be, i case the person sent back was out or otherwise too busy. 

Below is a sample of the spreadsheet I have set up. I want the zap to only send back a name if their ‘Spotlight Date’ cell is empty. 

 

 

@creasetoefurr hopefully I gotcha right. It is doable!

Our approach of the Zap: Slack chanel new message - filter against a keyword/password (to have some safety and a protection) - get the list by new file in folder drive - pull in the length of the rows (sheets) - randomly pick (js/python random number

) - pick the row :)