← Back to Directory
🍳

Weekly Report Generator

Every Friday at 4pm: compile metrics from analytics, sales, support, and engineering into a formatted weekly report.

🤖 00 ↓  |  👤 00
advanced30 min setup🔄 11 swappable alternatives

🧂 Ingredients

🔌 APIs

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_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