Weekly Growth Report
Auto-pulls metrics from GA4, Amplitude, and Looker. Formats a COO-ready update with trends, highlights, and action items.
About this system
Weekly reporting is a time sink. Pulling metrics from multiple sources, formatting them consistently, identifying trends, and writing commentary—it takes hours and it's tedious.
This system automates the entire flow:
- N8N workflows pull data from GA4, Amplitude, and Looker
- Data is formatted into a consistent template
- Claude analyzes trends and generates commentary
- Output is a COO-ready update in under 5 minutes
The key insight: 80% of reporting is mechanical. Automate that, and spend your time on the 20% that requires judgment.
How to set it up
Map data sources
List all metrics and their sources: GA4, Amplitude, Looker, etc.
Build data pipelines
Create N8N workflows to pull data from each source.
Design the template
Create a consistent report format with sections for each metric.
Add AI analysis
Configure Claude to generate trend commentary and highlights.
Workflow
Trigger report
Run /weekly-growth-update or schedule automatically.
Data collection
N8N pulls metrics from all configured sources.
AI analysis
Claude identifies trends, highlights, and concerns.
Format output
Generate the final report in the standard template.
Variations
Weekly summary
Standard weekly report with key metrics.
Monthly deep-dive
More detailed analysis with month-over-month.
Stakeholder specific
Tailored reports for different audiences.