← Back to Directory
🍳
Weekly Report Generator
Every Friday at 4pm: compile metrics from analytics, sales, support, and engineering into a formatted weekly report.
🤖 0 ↑ 0 ↓ | 👤 0 ↑ 0 ↓
advanced⏱ 30 min setup🔄 11 swappable alternatives
🧂 Ingredients
🔌 APIs
Pull website traffic metricsrequired
pull_website_traffic_metrics
🔄 Alternatives:
Posthog — Open-source, privacy-friendlyPlausible — Simple, GDPR-compliantMixpanel — Better event/funnel analytics
pull_revenue_and_subscription_data
🔄 Alternatives:
Square — Better for in-person payments tooPaddle — Handles tax/compliance as MoRLemonsqueezy — Simple SaaS payments
pull_engineering_velocity_metrics
🔄 Alternatives:
Gitlab — Built-in CI/CD, self-hostableBitbucket — Atlassian ecosystem integration
Email report to stakeholdersrequired
email_report_to_stakeholders
🔄 Alternatives:
Outlook — Microsoft ecosystem integrationSendgrid — Transactional email at scaleMailgun — Developer-friendly email API
📋 Step-by-Step Build Guide
STEP 1
Pull website traffic from Google Analytics (pageviews, sessions, bounce rate)
Pull website traffic from Google Analytics (pageviews, sessions, bounce rate)
Pull website traffic from Google Analytics (pageviews, sessions, bounce rate) Steps: 1. Validate all required inputs are available 2. Execute the operation described above 3. Verify the result meets expected output format 4. Handle errors gracefully — retry transient failures, log and alert on persistent ones 5. Return structured output with status and any relevant data If any required data is missing, request it from the user before proceeding.
STEP 2
Pull revenue metrics from Stripe (MRR, new customers, churn)
Pull revenue metrics from Stripe (MRR, new customers, churn)
Pull revenue metrics from Stripe (MRR, new customers, churn) Steps: 1. Validate all required inputs are available 2. Execute the operation described above 3. Verify the result meets expected output format 4. Handle errors gracefully — retry transient failures, log and alert on persistent ones 5. Return structured output with status and any relevant data If any required data is missing, request it from the user before proceeding.
STEP 3
Pull engineering metrics from GitHub (PRs merged, issues closed)
Pull engineering metrics from GitHub (PRs merged, issues closed)
Pull engineering metrics from GitHub (PRs merged, issues closed) Steps: 1. Validate all required inputs are available 2. Execute the operation described above 3. Verify the result meets expected output format 4. Handle errors gracefully — retry transient failures, log and alert on persistent ones 5. Return structured output with status and any relevant data If any required data is missing, request it from the user before proceeding.
STEP 4
Pull support metrics (tickets opened/closed, avg response time)
Pull support metrics (tickets opened/closed, avg response time)
Pull support metrics (tickets opened/closed, avg response time) Steps: 1. Validate all required inputs are available 2. Execute the operation described above 3. Verify the result meets expected output format 4. Handle errors gracefully — retry transient failures, log and alert on persistent ones 5. Return structured output with status and any relevant data If any required data is missing, request it from the user before proceeding.
STEP 5
Compile into formatted report with week-over-week comparisons
Compile into formatted report with week-over-week comparisons
Compile the gathered data into a structured report. Format as clean Markdown with: - Title/date header - Executive summary (2-3 sentences) - Key metrics section with actual numbers - Detailed sections with bullet points - Action items or recommendations at the end Keep it scannable — busy people read reports in 30 seconds. Use emoji sparingly for visual anchors (📊 metrics, ✅ wins, ⚠️ concerns, 📋 action items). Include data comparisons: "X this period vs Y last period (↑Z%)" If any data source was unavailable, note it clearly: "⚠️ [Source] data unavailable — excluded from this report."
STEP 6
Save as PDF and email to stakeholders
Save as PDF and email to stakeholders
Persist the data to the configured storage. Data structure: - Include timestamp (ISO 8601) with every record - Use consistent field names across entries - Store raw values (not formatted) for future analysis - Add a source/origin field for audit trail Storage operation: 1. Validate the data before writing 2. Check for duplicates (by timestamp + unique key) 3. Append to existing records — never overwrite 4. Verify the write succeeded 5. Return the stored record ID/reference
🤖 Example Agent Prompt
Pull website traffic from Google Analytics (pageviews, sessions, bounce rate) Steps: 1. Validate all required inputs are available 2. Execute the operation described above 3. Verify the result meets expected output format 4. Handle errors gracefully — retry transient failures, log and alert on persistent ones 5. Return structured output with status and any relevant data If any required data is missing, request it from the user before proceeding.
Copy this prompt into your agent to get started.
⏰ Automation Ideas
- • 0 16 * * 5