Best answer

Pull Unused Name from Google Sheet

  • 10 September 2020
  • 1 reply
  • 56 views

Userlevel 1

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. 

 

 

icon

Best answer by Wemakefuture 11 September 2020, 05:48

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 6
Badge +7

@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 :)