Track Google rankings & analyze search intent directly

This workflow automates the collection of Google search rankings for specific keywords and uses AI to classify the user intent behind top-ranking pages. Results are structured and saved into Google Sheets for SEO analysis and content strategy planning. Ideal for professionals who need to understand whether queries are informational, commercial, or transactional.

## Who it´s for
- SEO specialists monitoring keyword rankings and competitor content
- Marketers researching user intent to guide content creation
- Website owners optimizing pages for specific query types
- Agencies automating client SEO reporting

## What the automation does
- Triggered manually via n8n execution trigger
- Fetches keywords and country codes from Google Sheets
- Queries Google Search using Bright Data SERP API
- Extracts organic results: titles, descriptions, positions
- Sends top page data to Google Gemini for intent classification (informational, navigational, commercial, transactional)
- Stores structured results back in Google Sheets for analysis

## What´s included
- Ready-to-use n8n workflow
- Logic for manual trigger and batch keyword processing
- Integrations with Google Sheets, Bright Data, Google Gemini, and HTTP API
- Basic text instructions for launch and adaptation

## Requirements for setup
- n8n account (cloud or self-hosted)
- Access to Google Sheets with source keyword list
- Bright Data API key for SERP API access
- Google Gemini API key (via Vertex AI or direct access)

## Benefits and outcomes
- Saves time on manual SERP and intent analysis
- Clear insight into user intent per keyword
- Enables strategic content decisions: blog posts vs. landing pages
- Builds structured dataset for trend comparison over time
- Streamlines client or internal reporting

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.