⭐Spread Sheet interface slack emoji counter.

↓ Run

↓ Record

↓ Post(Example: Top 3)

👀Overview

0. (Set Reacji Channeler)
1. Get Slack token(enable conversation scope)
2. Set GAS properties(SLACK_TOKEN, POST_URL(post_url can fill dummy))
3. Run init() - initialize option/save sheet
4. Fill your slack channel_id in option sheet
5. Run loadToSheet(): load channel conversation data. You can specify the condition by filling sheet!
6. (testing) latestMonthAndPost() ... loadToSheet() + post top-3 reaction count comment

🔑Required Slack token scope

• channels:history

Set GAS Properties

Set your SLACK_TOKEN and POST_URL and to run. New GAS visual editor not support to set property.

function setProperty() {
  PropertiesService.getScriptProperties().setProperty("SLACK_TOKEN","xxxx-0000-...");
  PropertiesService.getScriptProperties().setProperty("POST_URL","https://...");
}

✋Auth test

curl -X POST -H "Authorization: Bearer token0000000" "https://slack.com/api/conversations.history?channel=channel0000000"

conversations.history method | Slack

📖Reference

Original code referenced site: https://zenn.dev/barusu/articles/0454005fc556dd

(This code doesn't work as channels.history API was deprecated.)