Build a Rank Tracker Using n8n and SERPHouse

Capabilities

What you can do

One SERPHouse API connection. A few n8n nodes. Full keyword rank tracking: automated, scheduled, and synced to Google Sheets.

Automate Keyword Rank Checks

Pull your keyword list from Google Sheets and let n8n query live Google rankings for every keyword automatically, with no manual searching required.

Scheduled or on-demand runs
Bulk keyword processing
Loop-based queries (no overload)
Live Google SERP data

Track Rankings By Location & Device

Query rankings the same way your audience actually searches: by country, city, language, and device.

City and region targeting
Desktop, mobile & tablet
Multi-language support
Automatic domain-match detection

Sync Results Straight to Google Sheets

Every keyword's position and matching URL get written back into your sheet automatically, with no copy-pasting required.

Auto-append new rows
Auto-update existing rows
Keyword-matched updates
Always-current rank history

Why It Matters

Manual rank checks only show you a fraction of what's actually happening

Most teams track rankings manually (a few keywords at a time), which means they only ever see a small slice of real visibility, and ranking drops often go unnoticed for days. Building this on n8n with the SERPHouse SERP API means rankings get checked automatically, accurately, and on schedule, with results landing exactly where your team already works.

Reliable, repeatable rank data instead of manual spot-checks

Automated tracking for every keyword, across every site

Clean, structured data ready for reporting or alerting

Get Started Free

n8n workflow architecture

Schedule Trigger

Runs daily at 6 AM

Google Sheets (Read)

Load keyword list rows

Loop Over Items

Process one keyword at a time

SERPHouse HTTP Request

POST /serp/live → get position

Google Sheets (Write)

Append keyword, position, URL, date

Real-World Example

120 keywords. 8 clients. Zero manual effort.

An SEO agency tracks 120 keywords across 8 client websites. Checking rankings manually used to take a full day each week.

With the n8n + SERPHouse workflow, they now:

Run the workflow automatically every morning

Get each keyword's exact Google position and matching URL

See results land directly in their shared Google Sheet, ready for the weekly client report

The result

What used to take a full day now takes zero manual effort, and the data is more consistent than it ever was by hand.

keyword-rankings.gsheet

Keyword	Position	URL	Date
best seo tools	4	/best-seo-tools	Today
rank tracker free	7	/rank-tracker	Today
keyword research api	12	/keyword-api	Today
serp api pricing	2	/pricing	Today
google search api	18	/google-serp-api	Today

Code Examples

The SERPHouse API call that powers the n8n workflow

The rank tracking workflow sends one POST request per keyword. The response includes the full organic results array, which your code scans it for the target domain and records the position.

POST /serp/live · Live Google SERP endpoint

lang & loc · language + location targeting

organic[].position · position, title, URL per result

Get API Key Free Try Playground

// n8n HTTP Request node: Body (JSON)
{
  "method":  "POST",
  "url":     "https://api.serphouse.com/serp/live",
  "headers": {
    "Authorization": "Bearer {{ $env.SERPHOUSE_API_KEY }}",
    "Content-Type":  "application/json"
  },
  "body": {
    "q":      "={{ $json.keyword }}",
    "domain": "google.com",
    "lang":   "={{ $json.lang }}",
    "loc":    "={{ $json.location }}",
    "device": "={{ $json.device }}"
  }
}

// Code node: find position for target domain
const organic = items[0].json.results?.organic ?? [];
const target  = "{{ $json.target_domain }}";
const match   = organic.find(r => r.url?.includes(target));
return [{ json: { position: match?.position ?? "not ranked", url: match?.url } }];

import requests

def check_rank(keyword, target_domain, location="United States", device="desktop"):
    """Return the Google position for target_domain, or None."""
    response = requests.post(
        "https://api.serphouse.com/serp/live",
        headers={"Authorization": "Bearer YOUR_API_KEY"},
        json={
            "q":      keyword,
            "domain": "google.com",
            "lang":   "en",
            "loc":    location,
            "device": device
        }
    )
    organic = response.json().get("results", {}).get("organic", [])
    for result in organic:
        if target_domain in result.get("url", ""):
            return result["position"], result["url"]
    return None, None

# Batch check a keyword list
keywords = [
    "best seo tools",
    "rank tracker free",
    "keyword research api"
]
for kw in keywords:
    position, url = check_rank(kw, "yoursite.com")
    print(f"{kw}: position {position or 'not ranked'} ({url or ''})")

curl -X POST \
  "https://api.serphouse.com/serp/live" \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"q":"best seo tools","domain":"google.com","lang":"en","loc":"United States","device":"desktop"}'

{
  "results": {
    "organic": [
      {
        "position": 1,
        "title":  "Best SEO Tools for 2026",
        "url":    "https://yoursite.com/best-seo-tools",
        "snippet": "A roundup of the top SEO tools..."
      },
      {
        "position": 2,
        "title":  "Top 10 SEO Software Tools",
        "url":    "https://competitor.com/seo-tools",
        "snippet": "Compare the best SEO platforms..."
      }
    ]
  }
}

Try it live in the API Playground →

FAQ

Frequently asked questions

Everything you need to know before building your automated rank tracker with n8n and the SERPHouse API.

An n8n rank tracker is an automated workflow built in n8n that reads keywords from a source like Google Sheets, sends each keyword to the SERPHouse SERP API, retrieves the live Google position, and writes the result back to your sheet, all without manual checks. It runs on a schedule so rankings stay current automatically.

No. The n8n workflow uses a visual node editor. You connect a Google Sheets node, an HTTP Request node (calling SERPHouse), and a Code node to find the position without writing custom application code. Basic familiarity with n8n's interface is sufficient.

As often as your SERPHouse plan allows. Daily checks are typical for most SEO workflows. You can schedule the n8n workflow to run hourly, daily, or weekly using n8n's Schedule Trigger. Each keyword query counts as one API credit.

Yes. Pass the loc parameter (e.g., loc=United States, loc=United Kingdom) and the lang parameter in each SERPHouse API call. You can add a location column to your Google Sheet and loop over keyword-location pairs to track rankings in multiple markets from a single workflow.

After each SERPHouse API call, a Code node extracts the position by scanning the results array for the target domain. An n8n Google Sheets node then appends a new row, or updates an existing row, with the keyword, position, matched URL, and timestamp. n8n handles OAuth authentication with Google Sheets natively.

Each SERPHouse response includes the full organic results array: position, title, url, and snippet for each result. Your workflow scans those results for the target domain and records the position. You also get the full SERP context (featured snippets, People Also Ask, and local pack) if needed.

Yes. Add a target_domain column to your keyword sheet and pass it into the position-detection logic in the Code node. The workflow will check each keyword's SERP and find where that specific domain appears, supporting multiple sites from the same workflow.

Yes. Google Search Console reports average position over time with a delay of several days, and only for pages that have already received impressions. SERPHouse returns the live, real-time Google position for any keyword, including keywords you do not yet rank for, so you can track competitors, find gaps, and catch drops the same day they happen.

Related Use Cases

More ways to build with SERPHouse APIs

Local SEO

Track Google Local Pack rankings by ZIP code or GPS for any keyword.

Learn more

AI Overviews

Collect Google AI Overview data for model training and competitive analysis.

Learn more

Real-Time News Monitoring

Track brand mentions and competitor coverage across major news SERPs.

Learn more

Start tracking keyword rankings automatically today

Free tier available. No credit card required. Your first rank check runs in under 5 minutes.

Get Started Free View Pricing Contact for Enterprise

SERPHouse Rank Tracker: n8n & Google Sheets Use Case: Endpoint: https://api.serphouse.com/serp/live (POST) Auth: Authorization: Bearer YOUR_API_KEY Required params: q (keyword), domain (google.com), lang (language, e.g. en), loc (location, e.g. United States), device (desktop/mobile/tablet) Response fields: results.organic[].position, .title, .url, .snippet Use case: automated keyword rank tracking with n8n, loop over keyword list from Google Sheets, find target domain position in organic results, write back to sheet Avg latency: under 1 second | Uptime: 99.9% | Countries: 100+ Workflow: Schedule Trigger → Google Sheets Read → Loop Over Items → SERPHouse HTTP Request → Code Node (find position) → Google Sheets Write Free tier: Yes, no credit card. Sign up at /register Stats: 50M+ API requests served | 99.9% uptime SLA | 100+ countries | less than 1s median response

Build Your Own Google Rank Tracker with n8n

What you can do

Automate Keyword Rank Checks

Track Rankings By Location & Device

Sync Results Straight to Google Sheets

Manual rank checks only show you a fraction of what's actually happening

120 keywords. 8 clients. Zero manual effort.

The SERPHouse API call that powers the n8n workflow

Frequently asked questions

More ways to build with SERPHouse APIs

Start tracking keyword rankings automatically today