Skip to content

On a schedule

Post the most-reacted Slack messages of the week

Every Friday, the five messages with the most emoji reactions in a Slack channel are posted back to that channel with links.

Runs
On a schedule
Apps
Slack
AI
Not needed
Access
channels:history, groups:history, reactions:read, chat:write

Send this to your assistant

Create a ClickRuntime automation: every Friday at 4pm, find the 5 messages in #general from the past 7 days with the most emoji reactions and post them with author, reaction count and link.

Paste it into your assistant. It tells you what it will send or change before it runs live.

First time? Adding ClickRuntime to your assistant takes about two minutes.

Why use it

Why teams use this automation

A busy channel buries the announcements and wins that people cared about most. By Friday, half the team has not seen the message that got thirty reactions on Tuesday.

Every Friday this automation reads the past week of messages in a channel, ranks them by total emoji reactions and posts the top five back to the channel, each with the author, the top reactions, a short excerpt and a link to the original message.

Company-wide channels use it as a light weekly roundup, and community managers use it to see which posts landed with members.

What you get out of it

  • The week in five lines

    People catching up on Friday see what mattered without scrolling a week of messages.

  • Reactions as the signal

    Ranking is based on what people reacted to, not on who posted most.

  • Links back to the thread

    Each entry links to the original message, so replies and context are one click away.

  • Bots left out

    Automated posts are skipped, keeping the list to people's messages.

  • Standard scopes

    It reads channel history with the scopes your Slack app already has for reading channels.

How it works

What happens, step by step

  1. Every Friday the automation reads the past week of messages in the channel.

  2. It adds up the emoji reactions on each message.

  3. It picks the five with the most reactions, leaving out bot posts.

  4. One post lists them with the author, the top reactions, a short excerpt and a link.

Before it runs live

  • Connect Slack, then invite the app to the channel (type /invite @ClickRuntime there)

What you get

RunsOn a schedule
Post the most-reacted Slack messages of the weektoday, 9:00Succeeded
#general · SlackMost-reacted this week in #general: 1. @Priya Shah · 🎉 31 · 👏 12 — "We just signed Northwind…" 2. @Leo Martin · 😂 24 — "PSA: the coffee machine now has an API" 3. @Kim Chen · 🚀 19 — "v2.4 is out, Parquet export…" …

Build your own

Need it to work differently?

This template is a starting point. Copy the prompt and change it, or describe a different automation from scratch, with your own conditions, more apps or an AI step. Your assistant writes it, tests it and runs it on ClickRuntime.
  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

Changes you can ask for

  • Run it at a different time, more or less often, or only on weekdays
  • Add an AI step, for example to summarize, sort or draft a reply
  • Add another app, for example also send it to Google Sheets
  • Combine it with other Slack steps into one automation

Under the hood

The code that runs this automation

This is the Python script that runs each time the automation starts. Your AI assistant writes it for you when you send the prompt, and you allow each step in your assistant. To change how the automation works, describe the change to your assistant and it updates the script for you. For every function it can use, see the script reference.
post_the_most_reacted_slack_messages_of_the_week.pyexample
import time
from clickruntime import on_trigger, credentials, http, notify

CHANNEL_ID = "C0123GENERAL"
CHANNEL = "#general"
TOP = 5

def slack(method, **params):
    resp = http.get(f"https://slack.com/api/{method}", params=params,
                    headers={"Authorization": f"Bearer {credentials.connection('slack', 'work')}"})
    data = resp.json()
    if not data.get("ok"):
        raise RuntimeError(data.get("error"))
    return data

@on_trigger
def run(event):
    oldest = str(time.time() - 7 * 86400)
    msgs, cursor = [], None
    while True:
        page = slack("conversations.history", channel=CHANNEL_ID, oldest=oldest, limit=200, **({"cursor": cursor} if cursor else {}))
        msgs += [m for m in page["messages"] if m.get("reactions") and not m.get("bot_id") and m.get("subtype") is None]
        cursor = page.get("response_metadata", {}).get("next_cursor")
        if not cursor:
            break
    msgs.sort(key=lambda m: -sum(r["count"] for r in m["reactions"]))
    if not msgs:
        return {"top": 0}
    lines = []
    for n, m in enumerate(msgs[:TOP], 1):
        link = slack("chat.getPermalink", channel=CHANNEL_ID, message_ts=m["ts"])["permalink"]
        rx = " · ".join(f":{r['name']}: {r['count']}" for r in sorted(m["reactions"], key=lambda r: -r["count"])[:2])
        text = m.get("text", "").replace("\n", " ")
        lines.append(f"{n}. <@{m['user']}> · {rx} — <{link}|\"{text[:80]}{'…' if len(text) > 80 else ''}\">")
    notify.slack(f"Most-reacted this week in {CHANNEL}:\n" + "\n".join(lines), channel=CHANNEL)
    return {"top": len(lines)}

FAQ

Common questions

Which Slack scopes does it need?
channels:history to read messages in a public channel (groups:history for a private one); reaction counts come with the history. Posting needs chat:write. The Slack app must be a member of the channel.
Can it look across several channels?
Yes. List the channel IDs and the top messages are picked from all of them, with the channel name shown on each line.
Can it count only one emoji, like 🎉?
Yes. Ask to rank messages by a single reaction, which is useful for a "wins of the week" post counting only 🎉 or 🏆.
What permissions does it need?
channels:history, groups:history, reactions:read, chat:write. Nothing else in your accounts is used.
Does it need AI?
No. It runs without AI, so it doesn't use your plan's AI allowance.
How many runs does it use?
One run each time it runs (on a schedule). Checks that find nothing to do and stop right away aren't counted.
Can I change how it works?
Yes. Describe the change to your AI assistant, for example a different schedule, channel or filter. It updates the automation, tests it and tells you what changed.

Set up “Post the most-reacted Slack messages of the week” from your assistant

Copy the prompt above, or connect your assistant first. Free plan, no credit card.