GA4 & SegMetrics Weekly Marketing Brief to Slack (n8n)

GA4, Search Console, and SegMetrics Weekly Brief—Automatically Posted to Slack (with MP3)

Get a complete weekly marketing performance update from Google Analytics 4, Google Search Console, and SegMetrics—generated automatically every Monday and delivered to your team’s Slack channel with both a written summary and an MP3 audio narration.

What this workflow does

This n8n workflow scheduled for every Monday pulls the right metrics, validates tracking quality, and uses OpenAI to produce an executive-ready brief.

• Runs on a Monday schedule and loads client settings (properties, API key, Slack channel, and date ranges).
• Fetches GA4 weekly performance for the current week and previous week, including channel and UTM campaign breakdowns.
• Queries Google Search Console Search Analytics API for current vs. previous week performance, including top queries and top pages.
• Requests SegMetrics reports for revenue, leads, and ad spend for both the current and previous week.
• Validates GA4 UTM tagging completeness and calculates a UTM health score based on the most common issues.
• Aggregates all sources, calculates week-over-week changes, and sends the dataset to OpenAI to generate a structured weekly brief in JSON.
• Formats the brief for Slack, creates an audio script, converts it to MP3 via OpenAI text-to-speech, and uploads the MP3 to Slack alongside the summary.

Use cases

• SaaS marketing ops teams needing consistent weekly KPIs across GA4, Search Console, and SegMetrics.
• Automation engineers building reporting pipelines that combine data validation (UTM health) with exec-ready communication.
• Founders and growth leaders who want a Slack-first brief plus an audio recap for faster weekly review.

Technical details

• Integrations/Credentials: GA4 (OAuth), Google (OAuth for Search Console API requests), OpenAI, and Slack (OAuth2 with permission to upload files).
• Nodes / building blocks: set, code, merge, slack, http request, and supporting workflow steps (including sticky note for documentation).

Ideal if you’re looking for an n8n marketing automation workflow that delivers a complete weekly brief to Slack, with audio narration and measurable week-over-week insights.