Skip to content
ClickRuntime

Automate PostHog

Run your PostHog queries on a schedule and send the results where you will read them. Get daily active users and sign-ups by email, a Slack message when an hour looks very different from last week, and a Monday summary of your saved insights. Describe what you want to your AI assistant, check what it will do, and it keeps running.

Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Try asking

Create a ClickRuntime automation: every morning at 7:30, run my PostHog queries for daily active users and sign-ups and email me yesterday's numbers next to the same day last week.

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

Ideas

What you can automate in PostHog

Scheduled HogQL results, hour-by-hour anomaly checks and a written recap of your saved insights. These are ready-made starting points. Anything else you can describe works too.
Daily

Email yourself yesterday's PostHog numbers

Each morning you get daily active users and sign-ups with the change from the same day last week.

See how it works
Hourly

Get a Slack alert when PostHog sign-ups dip

If an hour's sign-ups are 30% below the same hour last week, you know before the day is over.

See how it works
WeeklyAI

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.

See how it works Your own logic

Any other automation you can describe in words

Your own rules, schedule and AI steps with PostHog, plus any other app. Describe it and your assistant builds it.

See how to build your own

Build your own

Build any PostHog automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what PostHog should do in your own words, with your conditions, other apps or an AI step, and 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.

For example, ask your assistant

Every morning, run my PostHog query for signups by source and tell me if any source dropped to zero or doubled compared with its usual day.

Every Monday, run my saved PostHog insights and post the key numbers to our #growth Slack channel with a short AI summary.

Every day, find users in PostHog who signed up 3 days ago but never created a project, add them to HubSpot as a list and send each a short Gmail check-in.

Beyond chat

Have PostHog work when you're not in the chat

Connecting PostHog to ChatGPT or Claude lets you ask about it while you chat. ClickRuntime handles the part that should happen on its own: checks on a schedule and actions on each new event, set up from the same chat and running after you close it.

Setup

Connect PostHog

You connect PostHog with a personal API key that you create and scope yourself. The `phc_` project key is only for sending events, so it is not the one to use here.

PostHog

Product analytics

  1. In PostHog, open your avatar, then Settings, then Personal API keys, and create a key.
  2. Pick only the scopes the automation needs, such as query:read or insight:read, and choose which projects or organization it can reach.
  3. Copy the key, which starts with phx_. It is shown only once.
  4. In the ClickRuntime dashboard, save it as a secret on Connections & secrets, and say whether you use US cloud, EU cloud or your own host.

Good to know

PostHog limits that affect automations

  • Query calls are limited to 2,400 an hour per team, with 3 running at once.
  • Analytics endpoints allow 240 calls a minute and 1,200 an hour per team.
  • Create, update and delete calls allow 480 a minute.
  • US cloud, EU cloud and self-hosted PostHog each use a different host, so the automation needs the right one.

FAQ

Questions about automating PostHog

What can ClickRuntime access in PostHog?
Only what your personal API key's scopes and projects allow. A key with `query:read` and `insight:read` can run queries and read saved insights, but cannot change them.
Does it work with self-hosted PostHog?
Yes. Give your own host when you set it up, and the automation sends its requests there.
Why not use the project API key?
The `phc_` project key only captures events. Reading data needs a personal API key (`phx_`).
Can it run my own HogQL queries?
Yes. Describe the query or paste it, and the automation runs it on the schedule you set.
Do I need AI for PostHog automations?
Only for the written summary of insights. Query digests and anomaly checks are plain numbers. AI comes with every ClickRuntime plan, so you don't need your own AI key.
Is this a PostHog connector for ChatGPT or Claude?
Not for chatting with PostHog data. A chat connector lets your assistant read and change PostHog while you're in the conversation. ClickRuntime is for the work that should happen without you: you set up an automation from the chat once, and it keeps running on a schedule or on each PostHog event.

Related pages

Keep exploring

Tell your assistant what PostHog should do

Free plan. No credit card.

Add to ChatGPTAdd to Claude