Weekly SEO Performance Insights with Google Search Console

This workflow automates weekly tracking and analysis of Google Search Console (GSC) data to identify significant changes in website performance metrics such as clicks, impressions, CTR, and position. It compares last week’s data with the prior week, segments keywords by brand, recipe content, or non-brand categories, and calculates deltas and percentage changes. Key nodes include scheduled triggers, HTTP requests to GSC API, data processing and flattening, segmentation, and comparison logic. The workflow filters based on customizable thresholds (default: ±200 clicks and ±30% change), then sends Slack alerts for major movers. Additionally, it generates detailed email reports highlighting the top 25 upward and downward movements per segment, formatted as HTML tables. This automation helps SEO teams quickly spot impactful shifts, address anomalies, and optimize content strategies efficiently, making it an ideal tool for ongoing performance monitoring and rapid response.