Weekly

Get a Monday summary of your saved PostHog insights

Each week you read a short write-up of how your saved insights moved, instead of opening each one.

Runs: Weekly
Apps: PostHog
AI: Yes, uses the built-in AI allowance
Access: insight:read

Send this to your assistant

Create a ClickRuntime automation: every Monday at 9am, pull the results of my saved PostHog insights on the Growth dashboard and email me a short summary of what changed.

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 PostHog project can hold dozens of insights covering funnels, retention and trends. Few people read all of them every week, and even fewer write down what changed. Stakeholders who do not use PostHog, such as executives, investors and customer teams, ask what happened in the product this week, and the answer is a rushed summary typed from memory or a screenshot of one chart that may not be the one that matters.

Once a week, the results of the insights you choose are fetched from PostHog. ClickRuntime's built-in AI reads the numbers and writes a short plain-language summary of what moved and what stands out, and that summary arrives by email. No separate AI key is needed, and every figure comes from your own project's data.

It suits founders writing weekly updates and product managers who report to people outside the product team.

What you get out of it

Weekly updates without the writing
The email gives you a ready draft of what changed. You can paste it into a team note or investor update, and save the hour usually spent flipping between charts and typing sentences.
Changes you might have missed
The AI looks across many insights at once. A retention dip in one cohort, or a funnel step that quietly improved, is easier to catch when something has already pulled the pieces together for you.
Readable for non-technical colleagues
Plain-language summaries make product data accessible to executives and customer teams. They get the story of the week without needing to interpret each chart or learn how PostHog works. Everyone gets the same plain version of events.
Grounded in your own insights
The summary is based on the insights you select, so it reflects the metrics your business cares about. Nothing is invented from outside sources or generic benchmarks. Numbers behind it are always yours, never borrowed.
A weekly archive of the product's story
Over months, the emails form a history of how the product moved. That helps when you look back at the effect of a launch, a pricing change or a bug that hurt conversion.

How it works

What happens, step by step

Every Monday, ClickRuntime fetches the latest results of the PostHog insights you have saved.
AI reads them and writes a short summary of how each one moved and what seems to be behind it.
The summary arrives by email as a few bullet points, so you don't have to open each insight.

Before it runs live

Connect PostHog

What you get

RunsWeekly

Get a Monday summary of your saved PostHog insightstoday, 9:00Succeeded

Email · Growth: weekly summary• Sign-ups up 14% week over week, driven by Tuesday's launch post • Activation flat at 41%

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 PostHog 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_insights.pyexample

from clickruntime import on_trigger, credentials, http, ai, notify

PROJECT_ID = 12345
DASHBOARD_ID = 678

@on_trigger
def run(event):
    headers = {"Authorization": f"Bearer {credentials.secret('POSTHOG_API_KEY')}"}
    base = f"https://us.posthog.com/api/projects/{PROJECT_ID}"
    dash = http.get(f"{base}/dashboards/{DASHBOARD_ID}/", headers=headers).json()
    parts = []
    for tile in dash.get("tiles", []):
        if not tile.get("insight"):
            continue
        ins = http.get(f"{base}/insights/{tile['insight']['id']}/", headers=headers,
                       params={"refresh": "blocking"}).json()
        series = [f"{s.get('label')}: {s.get('data', [])[-14:]}" for s in (ins.get("result") or [])[:3]]
        parts.append(f"{ins['name']}\n" + "\n".join(series))
    summary = ai.generate("\n\n".join(parts)[:12000], max_output_tokens=500,
                          system="These are the last 14 days of each insight. Summarise what changed this week in short bullets.").text
    notify.email_me(f"{dash['name']}: weekly summary", summary)
    return {"insights": len(parts)}

FAQ

Common questions

Which insights does the summary use?

You choose them, usually a handful of saved insights covering your main funnel, retention and key trends. Tell your AI assistant which ones to include, and review the setup before it replaces the current version.

Can the AI get things wrong?

It summarizes the numbers it is given, so mistakes tend to be about emphasis rather than facts. The email includes the underlying figures, so you can check any statement against the data before forwarding it to others.

Is my product data sent to a separate AI vendor?

The summary is written by ClickRuntime's built-in AI, so you do not supply a separate AI provider key. The figures are used only to write the summary, and nothing is written back to PostHog. Your data stays within the process.

What permissions does it need?

insight:read. 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.

Daily