Summary of "How I Automated Google Search Console Analysis With n8n for Free"
The video explains how the creator automated the analysis of Google Search Console (GSC) data using the automation tool n8n, enabling efficient monthly performance checks of their website without manual repetitive work.
Key Technological Concepts and Features:
- automation workflow in n8n:
- Data is extracted from Google Search Console, filtered, and analyzed automatically.
- The workflow compares website performance metrics over two consecutive 7-day periods (configurable to other time frames like 28 days or custom dates).
- It identifies pages and keywords with declining, stable, growing, or strong growth in clicks and impressions.
- Data Handling and Filtering:
- Thresholds are applied to filter out noisy data (e.g., queries with very few clicks or impressions).
- Data is grouped by pages and keywords and aggregated over the chosen time period rather than daily data.
- The automation sorts and filters data to highlight URLs and keywords that lost or gained visibility.
- Output:
- Results are organized into a Google Spreadsheet with eight sheets: four sheets for pages and four for keywords, each categorized by performance status (declining, stable, growing, strong growth).
- Technical Details:
- Uses Google BigQuery for querying and processing large datasets from GSC.
- The workflow includes nodes for configuration, data retrieval, filtering, grouping, and saving data to spreadsheets.
- The user can customize domain, date ranges, table names, and thresholds via an edit node.
- Cost Efficiency:
- The bulk export from Google Search Console is free.
- BigQuery costs are minimized by using the free tier (first terabyte of data processed is free).
- Since the automation runs monthly or quarterly, it remains cost-effective for websites without millions of clicks.
- Additional Resources:
- The creator provides a GitHub repository with a downloadable n8n workflow JSON file for users without BigQuery access or bulk export enabled.
- This alternative workflow includes nodes to fetch overall and daily GSC data and inspect URL indexing and crawl status.
Guides/Tutorials Provided:
- Step-by-step explanation of the automation setup in n8n.
- How to configure thresholds and date ranges.
- How to interpret the output spreadsheet to identify pages and keywords requiring attention.
- Instructions on using the GitHub template for users with limited access.
Main Speaker/Source:
- The video is presented by the creator of the automation workflow, who shares personal experience and technical insights about automating Google Search Console analysis using n8n and BigQuery.
Category
Technology