Weekly Google Search Console Performance Reporting and Brand Segmentation - n8n Workflow

• SEO Managers and Specialists who need consistent, automated performance monitoring.


• Digital Marketing Analysts responsible for organic search reporting.


• Teams looking for a robust, flexible n8n template to customize complex data aggregation tasks.


• Users who want to utilize the core logic flow control capabilities of n8n for custom data manipulation.

This powerful n8n workflow provides SEO specialists and digital marketing teams with a critical weekly pulse check on organic search performance. Instead of manually exporting data from Google Search Console (GSC) and running comparisons, this automated n8n template handles the entire process. The unique value of this n8n workflow is its ability to segment traffic into Brand and Non-Brand clicks using custom criteria defined within an n8n node, offering deeper performance insights. It automatically calculates week-over-week percentage changes for key metrics (clicks, impressions, position, CTR) and formats the results into a clean, color-coded HTML table. This table is then delivered directly via a Gmail n8n node. This solution ensures timely, actionable reporting without manual effort, leveraging the strength of the n8n platform for complex data retrieval and data manipulation.

The process begins with the Schedule Trigger n8n trigger, configured to run weekly (e.g., every Monday). The Define Weeks n8n node calculates the exact start and end dates for the two periods being compared: 'Last Week' and '2 Weeks Ago'. The flow then branches using an If n8n node to process the two distinct time periods separately. For both periods, two parallel API calls are made to GSC via HTTP Request n8n node instances: one to retrieve total metrics (clicks, impressions, etc.) and another to retrieve data dimensioned by search query.

Custom code n8n node implementations (Brand Filter, Brand Filter1) analyze the query data to segment clicks into Brand and Non-Brand groups based on user-defined keywords. After the data is pulled and cleaned, Merge n8n node operations combine the segmented clicks and total metrics for each respective week. Finally, the two complete weekly reports are combined using the Merge Time Periods n8n node. The Generate Brand Performance Table n8n node executes complex JavaScript logic to compare the two periods, calculate percentage changes, apply color coding (green/red for movement), and generate the final comprehensive HTML table structure. This structured output is then sent using the Weekly GSC Metric Email Gmail n8n node, completing the automated n8n workflow.

1. Import the n8n Workflow: Copy the provided JSON data and paste it directly into your n8n canvas using the 'Import Workflow' function.


2. Google Search Console Credentials: You must configure a Google OAuth2 API credential specifically for Google Search Console access. Connect this credential to the Brand/NB Pull, Brand/NB Pull1, Total Metrics Pull, and Total Metrics Pull1 HTTP Request n8n node instances.


3. Brand Term Configuration: Navigate to the Brand Filter and Brand Filter1 Code n8n node instances. Update the placeholder ['BRAND TERMS'] array with the actual keywords, phrases, or brand names that define your brand searches.


4. Brand Name: Update the Add Brand Name Code n8n node with your actual brand name placeholder.


5. Gmail Setup: Configure your Gmail credentials in the Weekly GSC Metric Email n8n node. Set the recipient email address, subject line, and ensure the body uses the dynamically generated HTML table.


6. Activate: Ensure the Schedule Trigger n8n trigger is set to the desired weekly schedule and activate the n8n workflow.

Schedule Trigger (n8n trigger): Initiates the entire n8n workflow weekly on a specified day and time (default is Monday at 3 PM).
Define Weeks (Code n8n node): Calculates precise date ranges for 'Last Week' and '2 Weeks Ago' to ensure accurate week-over-week comparison using standard JavaScript date functions.
If4 (If n8n node): A core logic node that routes the date objects into two distinct parallel paths based on the label ('2 Weeks Ago' vs. 'Last Week') for independent data retrieval.
Brand/NB Pull & Total Metrics Pull (HTTP Request n8n node): These nodes connect to the Google Search Console API. They retrieve raw performance data—one path pulls query data for segmentation, the other pulls overall metrics (clicks, impressions, position).
Brand Filter & Brand Filter1 (Code n8n node): Essential custom scripting n8n node used to iterate over the GSC query results and manually segment clicks into brandClicks and nonBrandClicks. Requires manual configuration of brand terms.
Merge 2 Weeks Ago & Merge Last Week (Merge n8n node): Combines the brand segmentation data with the overall metrics for its respective time period, preparing a unified dataset for comparison.
Generate Brand Performance Table (Code n8n node): The core reporting n8n node. It compares the two merged datasets, calculates week-over-week percentage change (including position inversion logic), and outputs a robust, style-injected, color-coded HTML table ready for email delivery.
Weekly GSC Metric Email (Gmail n8n node): The final action n8n node. It sends the generated HTML report table via email, providing a polished and timely performance update.