Weekly SEO & Competitor Reports (SEMrush, GA4) to Slack

Get a weekly SEO & competitor intelligence brief—automatically—sent to Slack and Email

This n8n workflow runs every Monday at 7am to pull your SEMrush SEO rankings, Google Analytics 4 (GA4) traffic metrics, and a competitor page snapshot—then uses OpenAI to generate a short weekly intelligence summary delivered via Gmail and Slack, with Slack alerts on failures.

What this workflow does

• Scheduled reporting: Triggers every Monday at 7am.
• Pulls SEO and traffic data: Requests organic ranking data from the SEMrush API and retrieves a 7-day landing page report from the Google Analytics Data API (GA4).
• Monitors competitor page changes: Downloads raw HTML from a specified competitor URL, hashes it, compares it to the previous run’s stored hash, and flags whether the page changed.
• Generates an AI summary: Sends the combined SEMrush + GA4 + competitor-change flag to an OpenAI chat model (gpt-5-mini) to produce a 4–5 sentence summary with one key action item.
• Delivers to your team: Sends the summary as an HTML email via Gmail and posts the same text to a Slack channel.
• Error handling: If any step fails, posts an error alert with the execution message to an ops Slack channel.

Use cases

• Weekly SEO reporting for SaaS operators who want SEMrush + GA4 insights without manual work.
• Competitor page change monitoring to quickly spot updates that may impact rankings or messaging.
• Automation engineers setting up reliable SEO analytics pipelines with Slack notifications for failures.

Technical details

• Nodes/stack: Code, Gmail, Merge, Slack, Sticky Note, HTTP Request.
• Integrations: SEMrush API (domain tracking), Google Analytics Data API (GA4 property), competitor HTML fetch + hashing.
• AI component: OpenAI chat model (gpt-5-mini) for weekly intelligence summaries.

Setup requirements

• Add your SEMrush API key and replace REPLACE_WITH_DOMAIN.
• Create a Google Cloud OAuth credential for Google Analytics Data API, connect it in the GA4 HTTP request, and replace YOUR_GA4_PROPERTY_ID in the request URL.