Send weekly marketing performance briefs from GA4, GSC, SegMetrics and Slack
Ready for 3.0What this workflow does
This AI workflow has 23 nodes and runs on a schedule (every week at 09:00). Along the way it connects Slack, Google Analytics, OpenAI Chat Model and OpenAI.
How it runs
Trigger: On a schedule (every week at 09:00).
- Set client config (Edit Fields (Set)): sets 11 fields: client_name, website, ga4_property_id…
- GA4 - This week (Google Analytics): uses Google Analytics
- GA4 - Last week (Google Analytics): uses Google Analytics
- GA4 - Traffic channels (Google Analytics): uses Google Analytics
- GA4 - UTM data (Google Analytics): uses Google Analytics
- GSC - This week (HTTP Request): calls an HTTP API (POST)
- GSC - Last week (HTTP Request): calls an HTTP API (POST)
- GSC - Top queries (HTTP Request): calls an HTTP API (POST)
- GSC - Top pages (HTTP Request): calls an HTTP API (POST)
- SegMetrics - Revenue this week (HTTP Request): calls an HTTP API
…plus 11 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Slack
n8n-nodes-base.slack - Google Analytics
n8n-nodes-base.googleAnalytics - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Merge
n8n-nodes-base.merge - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI
@n8n/n8n-nodes-langchain.openAi - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set
From the author
Quick overview This workflow runs every Monday to pull weekly performance data from Google Analytics 4, Google Search Console, and SegMetrics, uses OpenAI to generate an executive marketing brief and audio narration, and posts the formatted summary with an…