Google Sheets Rank Tracker

Track where your site ranks on Google for every keyword, city and device, logged to a sheet every day.

Set up in four steps.

About two minutes from copy to first results.

  1. 1

    Copy the sheet

    Make your own copy in Google Drive. Nothing is shared back with us.

  2. 2

    Get a free API key

    Sign up for Geekflare: 500 free credits a month, about 250 checks, no card needed.

  3. 3

    Add your key

    In the sheet, open Rank Tracker → Set API key and paste it.

  4. 4

    List keywords and run

    Add keywords on the Keywords tab, then Rank Tracker → Check rankings now, or schedule a daily run.

What every run logs.

Each check adds one row to the Rankings tab, so the sheet builds its own history to chart.

DateThe day of the check, so every run stays in the log.
Keyword, Location, DeviceWhat was searched, from where, and on desktop or mobile.
PositionYour organic rank on the first page, or “Not in top 10”.
Ranking URLThe page of yours that ranks. If it keeps changing, two pages compete for the keyword.
Current #1Who holds the top spot, to track the competition for free.
AI OverviewWhether Google showed an AI Overview for the search.
Cited in AI OverviewWhether your domain is one of its sources.

What it costs to run.

Every run uses the same credits as every Geekflare API. Failed checks cost nothing.

2 months free
  • Free
    $0/mo
    No card
    Credits a month
    500
    Checks2 credits
    250
    Requests per second
    1
  • Starter
    $19/mo
    Credits a month
    20,000
    Checks2 credits
    10,000
    Requests per second
    5
  • GrowthMost popular
    $69/mo
    Credits a month
    100,000
    Checks2 credits
    50,000
    Requests per second
    10
  • Business 500K
    $299/mo
    Credits a month
    500,000
    Checks2 credits
    250,000
    Requests per second
    25
  • Business 1M
    $499/mo
    Credits a month
    1,000,000
    Checks2 credits
    500,000
    Requests per second
    25
Start freeCompare plans and credit packsEvery account starts free. Upgrade when you need more, or buy a credit pack from $10.

Before you copy it.

Yes. The sheet calls the Geekflare SERP API with your key, and every check uses your credits. A free account includes 500 credits a month, about 250 checks, with no card required.

In the sheet's script settings for your Google account only, set through Rank Tracker → Set API key. It's never written to a cell, and it isn't included when someone copies the sheet.

Yes. Add a city from the supported cities list, written exactly as listed, and set Device to mobile or desktop. Each row is checked separately.

Open Rank Tracker → Run daily at 6 AM. Google runs it from your account every morning and adds a row per keyword to the Rankings tab. Stop daily runs turns it off.

The tracker reads Google's first results page. If your domain isn't on it for that keyword, location and device, it's logged as not in the top 10.

Copy it, add your key, and start tracking.

500 free credits a month. No card required.