Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hello 

I have this usecase:

 

A channel with +60 people where we want to have some automation set up so that everyweek the “bot” at Monday will write something like “what are you up to this week - Brandon” and next week it does the same only difference is that it now tags Henry, instead of Brandon

Hope this is somehow possible with zapier

 

Feel free to contact me if you have any solutions

You might not need Zapier for this. There are native apps like Picker seems to do something like what you want.

You are absolutely correct! Adam, but i am not able to do this by automatic (or at least I can't figure out to) - I cant set it to fx /reminder #channel /picker to do stuff every week

Hey there @MTA ! We’ve got a few different bots that do this in the Zapier Slack workspace, so I know it’s possible. 

One way I can think of to do this would be to set something up like:

  1. Schedule by Zapier (trigger every Monday at the time you want)
  2. Formatter » Numbers » Spreadsheet-style formula, and then a random selection formula—RANDBETWEEN(1,60)—where the larger number would be whatever number is in the spreadsheet you’ll set up in the next step
  3. Google Sheets » Lookup Spreadsheet Row (or another spreadsheet program with that action step)
  4. Slack » Find user by email (use the email address from the Google Sheets step)
  5. Slack » Send channel message (In this step, to get Slack to tag the person randomly selected from your spreadsheet, you’ll want to format the results from the fourth step like this <@ID>, where the ID is pulled in from the output of the fourth step. It would look like this: https://cdn.zappy.app/33fbd86fb1f6b56ba618d1afb7635119.png

A few notes on this method:

  1. Set the spreadsheet up in advance. It should include one column called “numbers” and one called “email addresses.” Numbers would just go in order from 1 to whatever your upper limit is.
  2. You’d have to update the spreadsheet when new people join or leave the channel, and change the RANDBETWEEN numbers when that happens (so, if someone new joins, you’d need to add their email address and a number, and change the number in your Formatter step from 60 to 61). 

Hi Janine! 

 

That is a super awesome solution! - I don't see any problems with the updating group with email, since it is going to be a pretty much-locked group of people! 

 

I will be diving headfirst into this later today! =) 

Terms & Conditions