posthog-webhooks-events

name	posthog-webhooks-events
description	Implement PostHog webhook destinations, Action-triggered notifications, and event querying via the Events API and HogQL. Trigger: "posthog webhook", "posthog events API", "posthog actions", "posthog notifications", "posthog event query", "posthog HogQL".
allowed-tools	Read, Write, Edit, Bash(curl:*)
version	1.12.0
license	MIT
author	Jeremy Longshore <[e-mail]>
tags	["saas","posthog","webhooks"]
compatibility	Designed for Claude Code

PostHog Webhooks & Events

Overview

PostHog sends webhooks via its CDP (Customer Data Platform) Destinations feature. You configure a Destination that fires when matching events are captured, sending an HTTP POST to your endpoint. This skill covers webhook destination setup, receiving and processing webhook payloads, querying events via the API, and using HogQL for custom event analysis.

Prerequisites

• PostHog project with personal API key (phx_...)
• HTTPS endpoint to receive webhooks
• Events being captured in PostHog

Instructions

Step 1: Create a Webhook Destination via API

set -euo pipefail
# Create a webhook destination that fires on specific events
curl -X POST "https://app.posthog.com/api/projects/$POSTHOG_PROJECT_ID/pipeline_destinations/" \
  -H "Authorization: Bearer $POSTHOG_PERSONAL_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "name": "Signup Notifications",
    "description": "Send webhook when user signs up",
    "config": {
      "url": "https://your-app.com/webhooks/posthog",
      "method": "POST",
      "headers": {
        "X-Webhook-Secret": "your-webhook-secret"
      },
      "body": {
        "event": "{event}",
        "distinct_id": "{distinct_id}",
        "person": "{person}",
        "properties": "{properties}",
        "timestamp": "{timestamp}"
      }
    },
    "filters": {
      "events": [
        {"id": "user_signed_up", "type": "events"},
        {"id": "subscription_started", "type": "events"}
      ]
    }
  }'

Step 2: Receive and Process Webhooks

// api/webhooks/posthog.ts
import { NextResponse } from 'next/server';
import crypto from 'crypto';

const WEBHOOK_SECRET = process.env.POSTHOG_WEBHOOK_SECRET!;

// Verify webhook authenticity
function verifySignature(payload: string, signature: string): boolean {
  const expected = crypto.createHmac('sha256', WEBHOOK_SECRET)
    .update(payload)
    .digest('hex');
  return crypto.timingSafeEqual(Buffer.from(signature), Buffer.from(expected));
}

interface PostHogWebhookPayload {
  event: string;
  distinct_id: string;
  properties: Record<string, any>;
  person: {
    properties: Record<string, any>;
  };
  timestamp: string;
}

   () {
   body =  request.();
   signature = request..() || ;

  
   ( && signature !== ) {
     .({ :  }, { :  });
  }

   :  = .(body);

  
   (payload.) {
     :
       (payload);
      ;
     :
       (payload);
      ;
     :
       (payload);
      ;
    :
      .();
  }

   .({ :  });
}

  () {
   { distinct_id, properties, person } = payload;
  .();

  
   (, {
    : ,
    : { :  },
    : .({
      : [
        { : , : person.. },
        { : , : distinct_id },
      ],
    }),
  });

  
   (process..!, {
    : ,
    : .({
      : ,
    }),
  });
}

  () {
  .();
}

  () {
  .();
}

Step 3: Query Events via the API

set -euo pipefail
# List recent events by type
curl "https://app.posthog.com/api/projects/$POSTHOG_PROJECT_ID/events/?event=user_signed_up&limit=10&orderBy=-timestamp" \
  -H "Authorization: Bearer $POSTHOG_PERSONAL_API_KEY" | \
  jq '.results[] | {
    distinct_id,
    event,
    timestamp,
    properties: (.properties | {source, plan, referrer: ."$referrer"})
  }'

# Get events for a specific person
curl "https://app.posthog.com/api/projects/$POSTHOG_PROJECT_ID/events/?distinct_id=user-123&limit=20" \
  -H "Authorization: Bearer $POSTHOG_PERSONAL_API_KEY" | \
  jq '.results[] | {event, timestamp}'

Step 4: Query Events with HogQL

// Complex event analysis with HogQL (PostHog's SQL dialect)
async function queryPostHog(hogql: string) {
  const response = await fetch(
    `https://app.posthog.com/api/projects/${process.env.POSTHOG_PROJECT_ID}/query/`,
    {
      method: 'POST',
      headers: {
        'Content-Type': 'application/json',
        Authorization: `Bearer ${process.env.POSTHOG_PERSONAL_API_KEY}`,
      },
      body: JSON.stringify({
        query: { kind: 'HogQLQuery', query: hogql },
      }),
    }
  );
  return response.json();
}

// Example: Signup funnel analysis
const funnelData = await queryPostHog(`
  SELECT
    properties.$referrer AS referrer,
    count() AS signups,
    uniq(distinct_id) AS unique_users
  FROM events
  WHERE event = 'user_signed_up'
    AND timestamp > now() - interval 30 day
  GROUP BY referrer
  ORDER BY signups DESC
  LIMIT 20
`);

// Example: Feature adoption by plan
const adoptionData = await queryPostHog(`
  SELECT
    person.properties.plan AS plan,
    properties.feature_name AS feature,
    count() AS usage_count,
    uniq(distinct_id) AS unique_users
  FROM events
  WHERE event = 'feature_used'
    AND timestamp > now() - interval 7 day
  GROUP BY plan, feature
  ORDER BY usage_count DESC
  LIMIT 50
`);

Step 5: Set Up Slack Webhook Destination (UI)

PostHog has built-in Slack integration via Data Pipelines > Destinations:

1. Go to Data Pipelines > Destinations > New Destination
2. Select "Slack" or "Webhook"
3. Configure event filters (which events trigger the notification)
4. Set the webhook URL and message template
5. Test with a sample event

Error Handling

Issue	Cause	Solution
Webhook not firing	No matching destination filter	Check event name matches filter exactly
Duplicate webhooks	Event matches multiple destinations	Narrow destination filters
Webhook timeout	Handler too slow	Acknowledge with 200 immediately, process async
HogQL query timeout	Unfiltered table scan	Add timestamp > filter and LIMIT
429 on events API	Too many queries	Cache results, reduce polling frequency

Output

• Webhook destination configured for specific events
• Express/Next.js webhook handler with event routing
• Event queries via REST API and HogQL
• Slack/CRM integration on user lifecycle events

Resources

• PostHog CDP Destinations
• PostHog Webhook Destination
• PostHog Events API
• HogQL Documentation

Next Steps

For deployment setup, see posthog-deploy-integration.