Skip to main content
Question

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

  • May 8, 2024
  • 5 replies
  • 35 views

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

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

5 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • May 8, 2024

Hi @yagel 

Try these Zap steps:

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

  • Author
  • New
  • May 8, 2024

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!


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • May 8, 2024

@yagel 

Action: Slack - Send Channel Message


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • May 8, 2024

SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • May 17, 2024

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!