n8n SEO Opportunity Finder: GSC + GA4 + GPT-4o to Notion

Find and prioritize SEO wins automatically—using GSC + GA4 data, GPT-4o planning, and Notion delivery

This n8n workflow runs daily to compare the last 28 days vs the prior 28 days across Google Search Console and Google Analytics 4, scores SEO opportunities, and turns the top items into an actionable plan powered by GPT-4o—then publishes results to Notion, sends updates to Slack, and emails an HTML report via Gmail.

What this workflow does

• Automates a daily analysis: calculates current and previous 28-day date ranges on a schedule.
• Pulls SEO performance from GSC: queries the Google Search Console Search Analytics API for query + page performance for both periods.
• Pulls engagement from GA4: fetches GA4 page metrics (sessions, page views, and engagement duration) for both periods.
• Detects and ranks opportunities: analyzes the combined datasets to surface signals such as quick wins, CTR gaps, content decay, cannibalization, new queries, and low-engagement, high-traffic pages, then ranks the top opportunities.
• Tracks backlog in Google Sheets: appends the ranked opportunity backlog to a designated Google Sheets tab.
• Generates an AI action plan: sends the top opportunities to OpenAI (GPT-4o) to produce a structured SEO plan.
• Shares results: publishes the plan to a Notion database page, posts to Slack, and emails the HTML report via Gmail.

Use cases

• SEO operators who want a daily opportunity backlog driven by real GSC + GA4 changes.
• SaaS teams monitoring content decay and CTR gaps without manual exports.
• Automation engineers building a repeatable SEO insight-to-task pipeline across Sheets, Notion, Slack, and email.

Technical details

• Integrations / nodes: code, HTTP Request (OAuth2 for Google Search Console), Google Analytics (GA4), Google Sheets OAuth, OpenAI (GPT-4o), Notion, Slack, and Gmail.
• Setup: connect Google OAuth credentials for GSC (HTTP Request OAuth2) and GA4, select your GA4 property ID, and replace the placeholder GSC API URL with your verified, URL-encoded site property.