Weekly Analytics Report

Productivityadvanced50 minutes setup

Overview

All the workflows, credentials and data tables you have access to

Create workflow
Prod. executions
0
Failed prod. executions
0
Failure rate
0%
Time saved
—
Run time (avg.)
0s
WorkflowsCredentialsExecutionsData tables
Search workflows...
Last updated
Gmail AI Categorizer
Updated 2 days ago
Personal
Abandoned Cart Recovery
Updated 5 days ago
Personal

$69

Sign in to purchase

Or get 20% off with Pro — $55, $19/month

Updated Jul 2, 2026

100% n8n compatible

Every Monday at 9am, this workflow pulls last week's analytics and revenue data, generates an AI summary, and posts it to your team Slack channel.

Business Impact

  • Get a weekly business summary without opening 3 dashboards
  • Save 2–3 hours/week on manual reporting
  • Keep leadership aligned with AI-generated insights every Monday
  • Combine GA4 + Stripe data in one automated Slack update

Who is this for?

Perfect for:

  • Founders and CEOs
  • Growth and marketing teams
  • Agencies reporting to clients weekly
  • SaaS companies tracking MRR and traffic together
  • Teams that currently compile reports manually

What's included

  • n8n JSON workflow file
  • Step-by-step setup guide
  • All AI prompts included
  • Lifetime updates

Setup Guide

  1. 1Download the workflow JSON file and import it into n8n
  2. 2Open Workflow Settings and edit the CONFIG block: ga4_property_id, slack_channel_id, openai_model, default_currency, timezone
  3. 3Find your GA4 Property ID in GA4 Admin → Property Settings (numeric ID, not the G-XXXX measurement ID)
  4. 4Connect a Google Analytics OAuth2 credential on Fetch GA4 Data
  5. 5Connect a Stripe API key on Fetch Stripe Revenue
  6. 6Connect an OpenAI API key on Generate AI Summary (ensure your account has credits)
  7. 7Create a Slack app with chat:write scope, invite the bot to your reporting channel, and connect the Bot Token
  8. 8Copy your Slack channel ID and set slack_channel_id in Workflow Settings
  9. 9Click Save → Activate the workflow
  10. 10Manually execute once to verify GA4 data, Stripe revenue, AI summary, and Slack message all work
  11. 11Confirm the schedule runs every Monday at 9am in your configured timezone

Required Credentials

  • Google Analytics OAuth2 (GA4 Data API)Configure in n8n
  • Stripe API KeyConfigure in n8n
  • OpenAI API KeyConfigure in n8n
  • Slack Bot Token (xoxb-)Configure in n8n

Nodes Used

ScheduleGoogle AnalyticsStripeOpenAISlack

Common Mistakes

  • Using the G-XXXX measurement ID instead of the numeric GA4 Property ID — reports return empty data
  • Using a Slack channel name instead of channel ID — slack_channel_id must be the ID (e.g. C0123456789)
  • Forgetting to invite the Slack bot to the reporting channel — messages will fail to post
  • Invalid timezone in Workflow Settings — must be a valid IANA timezone (e.g. America/New_York)
  • OpenAI API key has no credits — the workflow falls back to a template summary without AI insights
  • Stripe account has no charges in the date range — revenue shows as N/A in the report
  • GA4 property has no traffic data for the week — sessions and users show as N/A

Architecture

Schedule
Google Analytics
Stripe
OpenAI
Slack
Output

Tags

analyticsreportingslackstripe