Automated Reporting Workflow

Generate and distribute reports automatically

What you’ll build

A workflow that pulls data from multiple sources, generates AI-powered insights, creates a presentation, and distributes it to stakeholders — all automatically.

Time to build: 25 minutes

Nodes used: Google Analytics, Google Sheets, LLM, Google Slides, Email Sender

The problem

Weekly reporting is tedious:

• Logging into multiple tools
• Copying data into spreadsheets
• Creating charts and slides
• Writing commentary and insights
• Sending to stakeholders

This workflow handles it all automatically.

Workflow overview

graph LR
    A[Google Analytics] --> D[Merge Data]
    B[Google Sheets Sales] --> D
    C[BigQuery Custom] --> D
    D --> E[LLM Analysis]
    E --> F[Google Slides]
    F --> G[Email Report]

Step-by-step guide

Step 1: Define your metrics

Decide what to include in your report:

Step 2: Create the workflow

1. Click New Workflow
2. Name it “Weekly KPI Report”

Step 3: Fetch data from sources

Step 4: Merge and transform data

Step 5: Generate AI insights

Analyze this week's KPI data and generate executive insights.

Data:
{{output}}

Previous Week Data (for comparison):
{{previousWeekData}}

Generate:
1. Executive Summary (3-4 sentences)
2. Key Wins (3 bullet points)
3. Areas of Concern (2-3 bullet points)
4. Recommendations (3 action items)
5. Week-over-Week Changes (% changes for key metrics)

Tone: Professional, data-driven, actionable

Output as JSON:
{
  "executive_summary": "",
  "key_wins": [],
  "concerns": [],
  "recommendations": [],
  "wow_changes": {}
}

Step 6: Create presentation

{
  "{{WEEK}}": "Week of {{date}}",
  "{{SUMMARY}}": "{{executive_summary}}",
  "{{WINS}}": "{{key_wins)}}",
  "{{CONCERNS}}": "{{concerns}}",
  "{{RECOMMENDATIONS}}": "{{recommendations}}",
  "{{SESSIONS}}": "{{sessions}}",
  "{{REVENUE}}": "{{total_revenue}}"
}

Step 7: Distribute report

Hi team,

Here's this week's KPI report.

Executive Summary:
{{executive_summary}}

Key Wins:
{{key_wins}}

View the full report: {{GoogleSlidesUrl}}

Best,
Automated Reports

Sample output

Email preview

Subject: Weekly KPI Report - Jan 15, 2024

Hi team,

Here's this week's KPI report.

Executive Summary:
Strong week with 23% increase in website traffic driven by 
the new blog content. Revenue hit $125K, up 15% WoW. 
Product adoption for the new feature exceeded targets.

Key Wins:
• Website traffic up 23% (organic search +31%)
• Revenue $125K vs. $108K target (+15%)
• New feature adoption at 45% (target was 30%)

View the full report: [Google Slides Link]

Best,
Automated Reports

Advanced options

Add charts to slides

Generate charts programmatically:

1. Calculate data in the workflow
2. Use Google Sheets as chart data source
3. Embed charts in slides template

Multi-format distribution

Output to different channels:

graph LR
    A[Report Data] --> B[Google Slides]
    A --> C[PDF Export]
    A --> D[Slack Message]
    A --> E[Dashboard Update]

Historical comparison

Track trends over time:

1. Store weekly data in BigQuery
2. Query last 4-12 weeks
3. Generate trend analysis
4. Show graphs in slides

Conditional alerts

Add alerts for critical thresholds:

Conditional:
  If revenue < target * 0.8
    → Send urgent alert to leadership
  If churn > 5%
    → Notify customer success team

Best practices

Design your template

Create a Google Slides template with:

• Clear placeholders: {{METRIC_NAME}}
• Consistent styling
• Charts linked to data sources
• Company branding

Schedule appropriately

Include context

AI-generated insights are better with context:

• Previous period data
• Targets/goals
• Seasonal factors
• Recent changes

Archive reports

Keep historical reports:

1. Save each report to a dated folder
2. Log metrics to BigQuery
3. Build trend analysis over time

Results you can expect

Template workflow

Next steps