Weekly GSC SEO Pulse: Brand vs Non-Brand Performance

This n8n workflow delivers a structured weekly SEO performance summary from Google Search Console (GSC), focusing on organic traffic segmented by brand vs. non-brand. It fetches data for the last week and two weeks ago, computes key metrics (clicks, impressions, CTR, average position), and calculates percentage changes. The output is a professionally formatted table with color-coded highlights—green for improvements, red for declines—making it easy to spot trends at a glance.

Ideal for SEO and marketing teams, it saves hours of manual reporting by automating data pulls, analysis, and delivery. Customize brand segmentation via domains, labels, or filters to match your tracking setup. Benefits include consistent monitoring of brand health, quick identification of performance shifts, and actionable insights to guide optimization efforts.

Use cases: Track directional SEO trends for multiple brands, share with stakeholders via email (adaptable to Slack/Teams), or integrate into dashboards. Runs on a schedule (e.g., Mondays), requires GSC connection, and setup takes 5-10 minutes. Supports deeper analysis by flagging anomalies for investigation.