Automate a daily analytics summary to Slack with Claude Code
- Source date:
- Last verified:
- Method:
- How we verify
Evidence: Described by posterThe person describes what happened in words, without screenshots or video.
Outcome
Claude Code set up a GitHub Actions cron that pulls PostHog data at 8am, summarizes it in Python and posts to Slack; the first report arrived the next morning.
Agent
Prompt Recreated prompt
The source did not publish its exact prompt. This one is our reconstruction from what the source describes.
Not sure how to start? Tell me what you're trying to get done and I'll help you turn it into a clear request. Goal: Automate my morning analytics check: every day at 8am, pull yesterday's PostHog numbers, summarize them and post the summary to Slack. Quick check first: Should it run even when your laptop is off? What I need from you: - Access to your PostHog data (an API key) - The Slack channel or DM where the summary should go - A GitHub account if you want it to run in the cloud Rules: - Explain the options for running it on a schedule before setting anything up. - Store keys safely (for example in GitHub's built-in secrets) and never put them in the code. - If something is missing or unclear, ask me instead of guessing. - Stop once it's set up, and let the first run confirm it works. Output: The working setup, plus plain-language steps for how it runs and how to change it. If any of this is unclear, tell me what you have and I'll help fill the gaps. You'll know it worked when: the summary shows up in Slack the next morning without you doing anything.
Source
https://x.com/PranavDate/status/2031210925806530779
By Pranav Date (@PranavDate) · Published Mar 10, 2026 · Added Oct 15, 2026 · Last verified Oct 15, 2026
Related cases
- Build a weekly business KPI dashboard workflow with Claude Code + n8nRecreated promptEvidence: Article or interview
Claude Code built a complex n8n workflow for a client's weekly KPI dashboard in about 15 minutes; the workflow then runs unattended on n8n.
Claude Code, n8n · Ops · Source date:
- Find smarter buying patterns in office supply order history with Claude CodeRecreated promptEvidence: Described by poster
Alex Hillman had Claude Code go through Indy Hall's paper products order history to suggest buying patterns that avoid costly last-minute orders.
Claude Code · Data · Source date:
- Let a whole team self-serve data via an agent-written schema guideRecreated promptEvidence: Described by poster
Claude Code wrote a markdown guide to the company's data model and business terms from SQLMesh context and past queries; Hex's agent now answers the team's data requests, and the analyst hire was dropped.
Claude Code, Hex agent · Data · Source date: