Weekly Google Search Console Performance Tracker and Alert System - n8n Workflow

• SEO managers and analysts who need timely data on performance shifts.


• Marketing teams focused on organic search optimization.


• Users looking for advanced examples of data manipulation and WoW analysis within an n8n node structure.


• Anyone seeking robust n8n templates for scheduled data reporting.

Managing large websites means tracking thousands of keywords, making manual weekly performance checks tedious and prone to missing critical changes. This sophisticated n8n workflow solves this by automating the entire Week-over-Week (WoW) analysis using Google Search Console (GSC) data.

The core value of this n8n automation is its ability to not only pull the data but also normalize, compare, and segment it (e.g., Brand, Nonbrand, Specific Content Categories). It calculates the absolute delta and percentage change for clicks, impressions, and position. By focusing on customizable thresholds (e.g., >200 click change and >30% change), the n8n trigger ensures you only receive alerts for genuinely significant shifts via Slack, while a detailed HTML report is compiled and sent via Gmail, providing maximum visibility with minimal noise. This complex n8n node arrangement transforms raw data into actionable insights.

This powerful n8n workflow executes weekly, typically on a Monday, using a scheduled n8n trigger.

1. Scheduling and Date Definition: The process starts with the Schedule Trigger (set to run every Monday). The Define Weeks n8n node then calculates the exact date ranges for 'last week' (7 days prior) and 'prior week' (14 days prior).


2. Data Extraction: The workflow splits using an If n8n node to fetch GSC data for both weeks separately via HTTP Request nodes (acting as the GSC connector).


3. Data Preparation: Custom Code n8n nodes (label, Flatten) enrich the GSC responses, ensuring each data point (query/page) is tagged with its corresponding week and standardized metrics.


4. WoW Comparison: A Merge n8n node combines the data streams. The Merge Weeks Code n8n node then executes the crucial Week-over-Week calculation, computing the clicks, impressions, CTR, and position deltas.


5. Segmentation: The Tag Brand / Recipes / Nonbrand Code n8n node applies custom logic to categorize each query/page combination into defined segments. Crucially, users must update this n8n node with their own brand terms and URL structures.


6. Parallel Processing: A Switch n8n node routes items based on their assigned segment (Brand, Recipes, Nonbrand), enabling parallel analysis tailored to each traffic type.


7. Alerting: For each segment, a Top Movers Filter Code n8n node checks if the movement exceeds the defined critical threshold (default: ±200 clicks AND ±30%). If breached, a Slack n8n node sends an immediate alert.


8. Reporting: Separately, a Top 25 Filter Code n8n node generates an HTML table highlighting the Top 25 highest click gainers and losers for that specific segment.


9. Final Delivery: The Merge4 n8n node brings all four segment reports back together. A final Code n8n node formats these into a single, comprehensive HTML email body, which is delivered via the Gmail n8n node.

To deploy this automated n8n workflow, follow these steps:

1. Import the n8n Workflow: Copy the provided JSON data and paste it into your n8n instance using the 'New' -> 'Import from JSON' option.


2. Set Credentials: This n8n template requires three types of credentials:

1. Customize Segmentation: Open the Tag Brand / Recipes / Nonbrand Code n8n node and update the example segmentation logic (e.g., "BRAND TERM 1", "BRAND TERM 2" and page paths like /recipes) to match your organization's keyword segments.


2. Review Thresholds: Check the four Top Movers Filter Code n8n nodes to adjust the alert criteria (default: Math.abs(delta) >= 200 && Math.abs(pct) >= 30).


3. Activate: Ensure the Schedule Trigger is configured correctly (default: Monday 15:00 UTC) and activate the n8n workflow.

Schedule Trigger:
Function: Serves as the primary n8n trigger, initiating the weekly audit cycle.
Key Configuration: Set to run using a cron expression (0 15 1), meaning 3:00 PM every Monday.
Define Weeks (Code):
Function: A custom n8n node that calculates precise start and end dates for the prior and last 7-day windows, feeding these variables into the GSC requests.
priorWeek & lastWeek (HTTP Request):
Function: Connects to the Google Search Console API (using Google OAuth2 credentials) to pull key performance data (clicks, impressions, position) segmented by 'page' and 'query' dimensions.
Merge Weeks (Code):
Function: The analytical heart of this n8n workflow. This node indexes prior week data and iterates through last week's data to calculate the WoW delta and percentage changes for all core metrics.
Tag Brand / Recipes / Nonbrand (Code):
Function: Customizes data classification based on user-defined logic (query keywords, page path matching) and sorts all items by deltaClicks (descending).
Switch:
Function: Routes the full dataset into four independent flows based on the 'segment' tag (Brand, Brand+Recipes, Recipes, Nonbrand).
Top Movers Filter (Code):
Function: Filters data specifically for high-impact changes (delta clicks >= 200 AND % change >= 30%) for immediate alerting.
Top WoW Movers Alert (Slack):
Function: Receives the flagged high-impact movers and delivers a formatted, urgent alert message via a Slack n8n node.
Top 25 Filter (Code):
Function: Processes the segmented data to identify and format the top 25 up and top 25 down movers into clean HTML table snippets, ready for the final email report. This demonstrates advanced use of a Code n8n node for visualization preparation.
Top WoW Movers Email (Gmail):
* Function: Combines the HTML output from all segments into a single, comprehensive email and sends it to the SEO team, finalizing the execution of this complex n8n workflow.