Rank Tracker
A free Google Sheets add-on that tracks Google rankings for any keyword and location, right inside a spreadsheet, powered by the SERPHouse SERP API.
Rank Tracker is a Google Sheets add-on (built on Google Apps Script) that checks where your site ranks on Google for a list of keywords, across as many locations as you want, once a day. Everything, including the tracking grid, the history, and the charts, lives inside a spreadsheet you own. There's nothing to host and nothing to log into.
No coding required
Install it from the Google Workspace Marketplace, paste in a SERPHouse API key, and you have a working rank tracker in under five minutes. See Installation & Setup.
What it does
- Tracks rank, not just visibility. For every keyword + location pair, it records your site's exact organic position (1–100) once per day.
- Shows day-over-day movement. The Dashboard highlights whether each keyword moved up (green ▲), dropped (red ▼), or stayed put, automatically, every time you open the sheet.
- Keeps history. Every day gets its own sheet, so you can look back at any date. The Dashboard tooltips show the last 10 days at a glance, and the Summary sheet plots a sparkline trend over a configurable window.
- Tracks its own cost. Your SERPHouse credit balance is shown on the Dashboard and checked before every run, so you're never surprised by a bill. See Credits & Pricing.
- Runs itself. Turn on scheduling once (daily, every other day, or weekly), and new rankings appear automatically; you only need to open the sheet to read them.
- Recovers from failure on its own. A failed lookup is retried the next time you fetch. It never gets silently confused with "not ranked," and you're never billed twice for the same result. See Fetching Rankings.
How the spreadsheet is organized
Rank Tracker manages four kinds of sheet tabs for you. You only ever need to type into one of them.
| Sheet | Created by | What it's for | Do you edit it? |
|---|---|---|---|
| Dashboard | Setup guide | Your master list of keywords & locations, and the latest rank for each | Yes, this is your input |
Date sheets (YYYY-MM-DD) | Automatically, per day | The raw rank recorded for every pair on that day | No, read-only reference |
| Summary | Automatically | KPIs, trend sparklines, and biggest movers | No, rebuilt on every fetch |
| Logs | Automatically | A history of every fetch run (found / not ranked / failed counts) | No, rebuilt on every fetch |
Read Understanding the Dashboard for a full tour of what every cell, color, and symbol means.
Get started
Installation & Setup
Install the add-on and complete the 4-step guided setup.
Credits & Pricing
Understand the cost before you add hundreds of keywords.
Explore the docs
Understanding the Dashboard
Every color, arrow, and marker on the tracking grid explained.
Fetching Rankings
Manual fetches, scheduling, retries, and rate limits.
Keywords & Locations
Add, validate, and clean up what you track.
Settings
Every configuration field, explained.
Summary & Logs
KPIs, sparkline trends, and run history.
Quick Reference
A cheat sheet of every menu item and cell marker.
FAQ & Troubleshooting
Answers to the questions users ask most.
Under the hood
Rank Tracker isn't a separate product with its own API. It's a client of the same SERPHouse API documented elsewhere on this site, and every rank check is one call to the Google Advanced (Top 100) endpoint, filtered locally for your domain.
Last updated on
How is this guide?