Best answer

How would you query a digest before release?


Hi there,

I would like to re-post the top 3 emoji’d slack messages once a week. 

Is there a way to query a digest so it only releases it if the it’s one of the top most reacted posts for that week? 
 

Best, 

 

Tarun

icon

Best answer by nicksimard 8 May 2021, 00:29

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 +14

Hi @zcbttp0

Not sure Digest is going to be the right app for your use case.

Perhaps consider using Airtable to log all the reacted posts.

Then you can use the Airtable API to just pull the Top 3 for a given time range: https://airtable.com/api

App API’s can be leveraged with a Webhooks step in a Zap: https://zapier.com/apps/webhook/integrations#triggers-and-actions

Userlevel 7
Badge +11

Hi @zcbttp0!

I think you could use a Zap to trigger on slack reactions, then the Storage app to increment the value by 1 each time for that message ID, then adding to Google Sheets. Then use this technique to only show the top 3 results in a worksheet. 

Since you have to search for something in order to find rows, you could use any keyword you want, like this (I used top3): 

Hope that helps point you in the right direction!

Userlevel 7
Badge +11

Hey @zcbttp0,

Did you manage to get this working using a Webhook or Storage step? Or did you figure out a different solution here?

Please let us know! :)