Weekly SEO Performance Report with GSC Data

This n8n workflow automates the generation and email delivery of a weekly Google Search Console (GSC) performance report focused on brand versus non-brand SEO metrics. It compares key metrics such as clicks, impressions, CTR, and position between the last week and the previous two weeks, highlighting week-over-week changes through visual cues. The workflow starts with a scheduled trigger every week, calculates relevant date ranges, fetches GSC data via API requests, filters and segregates brand terms, and then consolidates the data to produce a comprehensive and formatted HTML report. This report, featuring color-coded performance changes, is automatically sent via Gmail, providing SEO teams with timely insights into brand performance trends, enabling quick decision-making and strategic adjustments.