Buttondown | Slack Top Threads script

slack_top_discussions.txt

# A Bash script to pull the three most popular Slack threads from the last week and list them with their top three replies.
# Copy everything from line 7 on, add in your Slack token, channel ID, and workspace URL, then run in Terminal.
# See https://buttondown.com/blog/api-powered-email-newsletter for more details.

-----

SLACK_TOKEN="your-Slack-bot-token"
CHANNEL_ID="your_channel_ID"
WORKSPACE_URL="https://yourworkspace.slack.com"

seven_days_ago=$(date -v-7d +%s)

thread_data=$(curl -s -H "Authorization: Bearer $SLACK_TOKEN" \
  "https://slack.com/api/conversations.history?channel=$CHANNEL_ID&limit=200" \
  | jq -r --arg seven_days_ago "$seven_days_ago" '.messages[] | select(.thread_ts != null and .thread_ts == .ts and (.ts | tonumber) >= ($seven_days_ago | tonumber)) | "\(.ts)|\(.user)|\(.text)|\(.reply_count // 0)"' \
  | sort -t'|' -k4,4nr \
  | head -3)

thread_num=0
while IFS='|' read -r thread_ts user_id text reply_count; do
  thread_num=$((thread_num + 1))
  
  user_info=$(curl -s -H "Authorization: Bearer $SLACK_TOKEN" \
    "https://slack.com/api/users.info?user=$user_id")
  
  username=$(echo "$user_info" | jq -r '.user.name')
  real_name=$(echo "$user_info" | jq -r '.user.real_name')
  
  timestamp=$(echo "$thread_ts" | cut -d'.' -f1)
  formatted_date=$(date -r "$timestamp" "+%A, %B %d, %l:%M%p" | sed 's/  / /g' | sed 's/AM/am/g' | sed 's/PM/pm/g')
  
  links=$(echo "$text" | grep -oE 'https?://[^>|[:space:]]+' | tr '\n' ' ')
  
  thread_link="$WORKSPACE_URL/archives/$CHANNEL_ID/p$(echo "$thread_ts" | tr -d '.')"
  
  reply_data=$(curl -s -H "Authorization: Bearer $SLACK_TOKEN" \
    "https://slack.com/api/conversations.replies?channel=$CHANNEL_ID&ts=$thread_ts" \
    | jq -r '.messages[1:] | map(. + {reaction_count: ((.reactions // []) | map(.count) | add // 0)}) | sort_by(.reaction_count) | reverse | .[0:3] | .[] | "\(.user)|\(.text)"')
  
  reply_count=1
  while IFS='|' read -r reply_user reply_text; do
    if [[ -n "$reply_user" && -n "$reply_text" ]]; then
      reply_user_info=$(curl -s -H "Authorization: Bearer $SLACK_TOKEN" \
        "https://slack.com/api/users.info?user=$reply_user")
      reply_username=$(echo "$reply_user_info" | jq -r '.user.name')
      
      eval "THREAD_${thread_num}_TOP_REPLY_${reply_count}=\"@$reply_username: $reply_text\""
      ((reply_count++))
    fi
  done <<< "$reply_data"
  
  while [[ $reply_count -le 3 ]]; do
    eval "THREAD_${thread_num}_TOP_REPLY_${reply_count}=\"\""
    ((reply_count++))
  done
  
  eval "THREAD_${thread_num}_USERNAME=\"$username\""
  eval "THREAD_${thread_num}_REAL_NAME=\"$real_name\""
  eval "THREAD_${thread_num}_DATE_TIME=\"$formatted_date\""
  eval "THREAD_${thread_num}_TEXT=\"$text\""
  eval "THREAD_${thread_num}_LINKS=\"$links\""
  eval "THREAD_${thread_num}_LINK=\"$thread_link\""
  
done <<< "$thread_data"

for i in 1 2 3; do
  if eval "[[ -n \"\$THREAD_${i}_USERNAME\" ]]"; then
    eval "echo \"THREAD_${i}_USERNAME=\$THREAD_${i}_USERNAME\""
    eval "echo \"THREAD_${i}_REAL_NAME=\$THREAD_${i}_REAL_NAME\""
    eval "echo \"THREAD_${i}_DATE_TIME=\$THREAD_${i}_DATE_TIME\""
    eval "echo \"THREAD_${i}_TEXT=\$THREAD_${i}_TEXT\""
    eval "echo \"THREAD_${i}_LINKS=\$THREAD_${i}_LINKS\""
    eval "echo \"THREAD_${i}_LINK=\$THREAD_${i}_LINK\""
    eval "echo \"THREAD_${i}_TOP_REPLY_1=\$THREAD_${i}_TOP_REPLY_1\""
    eval "echo \"THREAD_${i}_TOP_REPLY_2=\$THREAD_${i}_TOP_REPLY_2\""
    eval "echo \"THREAD_${i}_TOP_REPLY_3=\$THREAD_${i}_TOP_REPLY_3\""
    echo "---"
  fi
done