On a schedule
Post daily signup numbers to Slack and Microsoft Teams
Every morning, yesterday's signups are posted to the same channel in both Slack and Teams.
- Runs
- On a schedule
- Apps
- Microsoft Teams, Slack
- AI
- Not needed
- Access
- chat:write; ChannelMessage.Send
Send this to your assistant
Create a ClickRuntime automation: every morning at 9, post yesterday's signup numbers to #metrics in Slack and to our Metrics channel in Teams.
First time? Adding ClickRuntime to your assistant takes about two minutes.
Why use it
Why teams use this automation
After an acquisition or a merger, one half of the company uses Slack and the other uses Microsoft Teams. Daily metrics end up posted in only one of them, so half the company never sees them, or someone copies the numbers across every morning.
Sending the same message to both keeps the whole company looking at the same figures without anyone acting as the go-between. It also works for alerts that both groups need to see at once.
What you get out of it
One set of numbers for everyone
Both groups see exactly the same figures at the same time. Discussions start from shared facts rather than "which number are you looking at?".
Nobody relays messages by hand
Copying a post from one chat app to another is a small daily task that gets forgotten. Here it is done every morning without anyone thinking about it.
Works while teams are split
Moving everyone onto one chat app can take months. This keeps information flowing in the meantime without forcing a switch.
A daily habit around the numbers
A message at the same time every day becomes something people look for. Small changes in signups are noticed early instead of at the monthly review.
How it works
What happens, step by step
Every morning at 9, ClickRuntime fetches yesterday's signup count from your data source.
It writes one short message with the number and the change from the day before.
The message is posted to your Slack channel.
The same message is posted to your Microsoft Teams channel.
Before it runs live
- Connect Microsoft Teams
- Connect Slack, then invite the app to the channel (type /invite @ClickRuntime there)
What you get
Build your own
Need it to work differently?
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 Microsoft Teams and Slack steps into one automation
Under the hood
The code that runs this automation
from datetime import date, timedelta
from slack_sdk import WebClient
from clickruntime import on_trigger, credentials, http
STATS_URL = "https://admin.example.com/api/signups"
TEAM_ID, CHANNEL_ID = "your-team-id", "your-channel-id"
@on_trigger
def run(event):
day = date.today() - timedelta(days=1)
key = {"Authorization": f"Bearer {credentials.secret('STATS_API_KEY')}"}
today_n = http.get(STATS_URL, params={"date": day.isoformat()}, headers=key).json()["count"]
prev_n = http.get(STATS_URL, params={"date": (day - timedelta(days=1)).isoformat()}, headers=key).json()["count"]
text = f"Signups on {day:%a %d %b}: {today_n} ({today_n - prev_n:+d} vs previous day)"
WebClient(token=credentials.connection("slack", "work")).chat_postMessage(channel="#metrics", text=text)
http.post(f"https://graph.microsoft.com/v1.0/teams/{TEAM_ID}/channels/{CHANNEL_ID}/messages",
headers={"Authorization": f"Bearer {credentials.connection('microsoft', 'work')}"},
json={"body": {"content": text}})
return {"signups": today_n}FAQ
Common questions
Where do the signup numbers come from?
Can I add more numbers than signups?
Can the messages be formatted differently in each app?
What permissions does it need?
Does it need AI?
How many runs does it use?
Can I change how it works?
Related
You might also like
Get a weekly digest of Slack and Teams discussions
Every Friday you get one email with the decisions and open questions from your chosen Slack and Teams channels.
See how it worksKnow the moment your website goes down
Your team hears in Slack when the site stops responding or slows down, and again when it's back.
See how it worksPost a morning briefing to Slack
Your team starts the day with the weather, a reminder or anything else you'd like in #general.
See how it worksKeep exploring
Set up “Post daily signup numbers to Slack and Microsoft Teams” from your assistant
Copy the prompt above, or connect your assistant first. Free plan, no credit card.