Automated SEO performance collection from Google Search Console
Problem Monitoring SEO performance from Google Search Console (GSC) manually is repetitive and prone to human error. For marketers or analysts managing multi...
🔌 Nodes & Integrations Used (2)
📖 Implementation & Setup Guide
Problem
Monitoring SEO performance from Google Search Console (GSC) manually is repetitive and prone to human error. For marketers or analysts managing multiple domains, checking reports manually and copying data into spreadsheets or databases is time-consuming. There is a strong need for an automated solution that collects, stores, and updates SEO metrics regularly for easier analysis and dashboarding.
Solution
This workflow automatically pulls performance metrics from Google Search Console — including queries, pages, CTR, impressions, positions, and devices — and stores them in a structured format inside a NocoDB table. It’s ideal for SEO specialists, marketing teams, or data analysts who need to automate SEO reporting and centralize data for analytics or dashboards (like Superset or Metabase).
Setup Instructions
- **Authorize your Google Search Console account**
- Connect via OAuth2 (requires GSC API access).
2. **Create a NocoDB table** Define fields to match GSC response: - `query` (text) - `page` (URL) - `device` (text) - `clicks` (number) - `impressions` (number) - `ctr` (percentage) - `position` (number)
3. **Add credentials in n8n** Use credential nodes for both: - Google OAuth2 - NocoDB API Token
4. **Customize schedule trigger** Set the frequency (e.g., weekly) and adjust the domain/date range as needed.
5. **Generalize domains** Replace specific domains like `martechmafia.net` with `your-domain.com` before submission.
NocoDB Table Structure
The NocoDB table must match the fields coming from GSC's Search Analytics API. Here's a sample schema: ```json { "query": "string", "page": "string", "device": "string", "clicks": "number", "impressions": "number", "ctr": "number", "position": "number" }
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
Automated_SEO_performance_collection_from_Google_Search_Console.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related SEO & Marketing Workflows
View All in SEO & Marketing →AI-Powered WooCommerce Product Import SEO
Production-ready n8n automation template for AI-Powered WooCommerce Product Import SEO built by AhiXLight. Seamlessly connects Lm Chat Open Router, Chain Llm, Google Sheets with 16 configured nodes.
AI-Powered WooCommerce Product Import SEO
Production-ready n8n automation template for AI-Powered WooCommerce Product Import SEO built by AhiXLight. Seamlessly connects Lm Chat Open Router, Chain Llm, Google Sheets with 16 configured nodes.
Airtable SEO Meta Tag Auto-Fill
Production-ready n8n automation template for Airtable SEO Meta Tag Auto-Fill built by AhiXLight. Seamlessly connects Airtable, HTTP Request, Html with 6 configured nodes.
Airtable SEO Meta Tag Auto-Fill
Production-ready n8n automation template for Airtable SEO Meta Tag Auto-Fill built by AhiXLight. Seamlessly connects Airtable, HTTP Request, Html with 6 configured nodes.