Skip to main content
Question

How do I track Slack channels named "bug-*" and update a Google Sheets?


Hi guys, I appreciate your help here.

I’m trying to track type of slack channels that start with the word ‘bug’ - we use these type of slack channel to report severe bugs in the system. They will always start with the word ‘bug’. I only need to work with these type of Slack channels

What I need in particularly is to either automatically fill in a row of a specific column in a google spreadsheet we use every time a channel with the word ‘bug’ in it is opened in slack, with the slack channel URL or the full name of it 
Or another option will be to automatically add a link to the spreadsheet every time a channel opened that starts with the word ‘bug’

Do you have any solution in mind for me?

Thanks a lot!

Yagel

5 replies

Userlevel 7
Badge +14

Hi @yagel 

Try these Zap steps:

  1. Trigger: Slack - New Channel
  2. Action: Filter
  3. Action: GSheets - Create Row

Appreciate Troy. Also wanted to ask, is there a way to automate inserting the spreadsheet URL to each Slack channel that starts with the word “bug” ?

 

Thanks a lot!

Userlevel 7
Badge +14

@yagel 

Action: Slack - Send Channel Message

Userlevel 7
Badge +14

@yagel 

Available Zap triggers/actions for each app...

GSheets: https://zapier.com/apps/google-sheets/integrations#triggers-and-actions

Slack: https://zapier.com/apps/slack/integrations#triggers-and-actions

Userlevel 7
Badge +11

Hey there @yagel! 👋

Just wanted to check in here to see how you’re getting on. Were you able to get the desired workflow set up? 

Happy to help if you’re stuck at all, just let us know! 

Reply