Weekly

Get a weekly summary of a Teams channel

Each Friday you get a short report of what each person discussed in the channel that week.

Runs: Weekly
Apps: Microsoft Teams
AI: Yes, uses the built-in AI allowance
Access: read (ChannelMessage.Read.All, admin consent)

Send this to your assistant

Create a ClickRuntime automation: every Friday at 4pm, summarise this week's messages and replies in our Project Atlas channel in Teams, grouped by person, and email it to me.

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

Add to ChatGPT Add to Claude

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

Why use it

Why teams use this automation

A team lead running a busy Teams channel wants to know who has been contributing what, but the channel holds hundreds of messages and replies each week. Reading them all is not realistic, so contributions go unnoticed: the engineer who quietly unblocked three colleagues, the designer who posted the key decision. Performance reviews end up favoring whoever is loudest or most recent in memory.

Each week, ClickRuntime lists the channel's messages and replies since the previous run, groups them by author, and has its built-in AI write a report of what each person discussed, decided or helped with. The report is emailed to you, and no OpenAI or Anthropic key is needed.

It is useful to managers, community leads and project owners who want an informed picture without reading every thread.

What you get out of it

Contributions become visible
Quiet but valuable work shows up in a written summary under the person's name. That helps managers give credit where it is due, not only to the most talkative people.
Reviews are based on evidence
When a review comes around, you have weekly reports to draw on instead of relying on memory. Feedback is more specific and fairer, and easier to defend. That also shortens review preparation time.
You stay informed without reading everything
A summary of a week's discussion takes a few minutes to read. You know what each person was working on and where help was needed, without scrolling the channel. A short read replaces scrolling.
Blocked work is noticed
If someone has raised the same issue in three threads, the report shows it. You can step in, instead of waiting until it is mentioned in a status meeting. Early help prevents delays that grow over time.
Remote teams feel seen
People in other time zones often feel invisible. Knowing that their work is summarized and read by their lead keeps motivation high, even when they are rarely online at the same time.
A record of how topics evolved
Over several weeks, the reports show how discussions developed and who shaped them. That is valuable when a new person joins or a decision needs to be retraced. That context saves a lot of rereading.

How it works

What happens, step by step

Once a week ClickRuntime reads the past seven days of messages and replies in your Microsoft Teams channel.
It notes who wrote what.
AI writes a short report of what each person worked on, decisions made and any risks raised.
The report is emailed to you.

Before it runs live

Connect Microsoft Teams

What you get

RunsWeekly

Get a weekly summary of a Teams channeltoday, 9:00Succeeded

Email · Project Atlas: this week in TeamsDana: finalised the Acme data mapping, asked for review by Tuesday. Jo: raised a risk on the Northwind SSO timeline.

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
Change what the AI looks for, or how it writes the result
Add another app, for example also send it to Slack
Combine it with other Microsoft Teams 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.

weekly_ai_summary_of_channel_activity_microsoft_teams.pyexample

import re
from datetime import datetime, timedelta, timezone
from clickruntime import on_trigger, credentials, http, ai, notify

GRAPH = "https://graph.microsoft.com/v1.0"
TEAM_ID, CHANNEL_ID = "your-team-id", "19:atlas-channel-id@thread.tacv2"

def line(m):
    who = (m.get("from") or {}).get("user", {}).get("displayName", "app")
    return f"{who}: {re.sub('<[^>]+>', '', m['body']['content'])[:400]}"

@on_trigger
def run(event):
    headers = {"Authorization": f"Bearer {credentials.connection('microsoft', 'work')}"}
    since = (datetime.now(timezone.utc) - timedelta(days=7)).isoformat()
    base = f"{GRAPH}/teams/{TEAM_ID}/channels/{CHANNEL_ID}/messages"
    lines = []
    for m in http.get(base, headers=headers, params={"$top": 50}).json()["value"]:
        if m["createdDateTime"] < since:
            continue
        lines.append(line(m))
        replies = http.get(f"{base}/{m['id']}/replies", headers=headers).json()["value"]
        lines += ["  " + line(r) for r in replies]
    summary = ai.generate("Summarise this week's channel activity grouped by person:\n" + "\n".join(lines),
                          max_output_tokens=900).text
    notify.email_me("Project Atlas: this week in Teams", summary)
    return {"messages": len(lines)}

FAQ

Common questions

Are private chats included?

No. The report covers the channel you connect, using the messages that the connected account can see. Direct messages and other channels are not read, unless you set up a separate report for them. Nothing outside that channel is read.

How does the AI handle people who posted very little?

They appear with a short note, or you can choose to leave out people with fewer than a minimum number of posts. The AI is told to describe only what is in the messages, and not guess about work that is not mentioned.

Who should receive the report?

By default it goes to you. Sharing it with the team can encourage openness, but individual summaries may be sensitive, so decide who sees it and have your AI assistant set the recipients. Sharing is always your decision.

What permissions does it need?

read (ChannelMessage.Read.All, admin consent). Nothing else in your accounts is used.

Does it need AI?

Yes. It uses ClickRuntime's built-in AI, so you don't need an OpenAI or Anthropic key. Every plan includes a monthly AI allowance.

How many runs does it use?

One run each time it runs (weekly). 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.

DailyAI