Best answer

Action Dependent On Slack Reaction

  • 3 August 2021
  • 3 replies
  • 113 views

Badge

Hi There,

I want to create a new row in a google sheet whenever someone uses a certain emoji in a certain slack channel. If they use X reaction, it will post the message in sheet X, if they use Y it will go to Y etc.

My first thought would be that there’s a way to include a lookup table either in the trigger or before, however, its not possible.

Other than creating multiple identical zaps, anyone have any thoughts on how to do this?

Thanks.

Ilan

icon

Best answer by GetUWired 3 August 2021, 16:27

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.

3 replies

Userlevel 7
Badge +12

Hi @Ilan B 

It will cost you less in tasks to build multiple almost identical zaps however you can build it in one zap

 

Trigger: New Reaction added in slack. leave everything blank in set up to trigger off any channel, any user, any reaction

Step 2: Filter by Zapier to filter for only specific reactions

Step 3: Either use Look Up Table or Paths by Zapier. 

Step 4: Add Row to Sheet

Badge

Amazing! Thanks so much @GetUWired!

I knew there was a way to do this!

Userlevel 7
Badge +12

No problem! If you go the Look Up Table route these may be helpful

 

Lookup Table: https://zapier.com/help/create/format/create-lookup-tables-in-zaps 

 

Dynamically Mapping to different sheets: https://www.luhhu.com/blog/how-to-map-dynamically-created-google-sheets-in-zapier