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
Copy the sheet
Make your own copy in Google Drive. Nothing is shared back with us.
- 2
Get a free API key
Sign up for Geekflare: 500 free credits a month, about 250 checks, no card needed.
- 3
Add your key
In the sheet, open Rank Tracker → Set API key and paste it.
- 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
| Covered per month | Free $0/mo No card | Starter $19/mo | Most popular Growth $69/mo | Business 500K $299/mo | Business 1M $499/mo |
|---|---|---|---|---|---|
Credits a month | 500 | 20,000 | 100,000 | 500,000 | 1,000,000 |
ChecksOne keyword, in one city, on one device: Google's full results page.2 credits | 250 | 10,000 | 50,000 | 250,000 | 500,000 |
| Requests per second | 1 | 5 | 10 | 25 | 25 |
- Free$0/moNo 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.