Google Keywords Ranking Tracker

Effortlessly monitor your organic rankings with Google Sheets.

To help you get started right away, you can use this free Google Sheets template

With =IMPORTFROMGOOGLE(), you extract the organic results on a list of keywords and monitor your SEO performances overtime. And this directly from Google Sheets!

See all available Google Search data points

First of all, make sure you have installed the ImportFromWeb add-on from the Google Workspace Marketplace.

Then, just follow these easy steps:

Open a new Google Sheets and activate ImportFromWeb

To activate the add-on, go to Extensions > ImportFromWeb > Activate add-on.

activate ImportFromWeb add-on

Enter the website domain and input the keywords in the 1st column

Input your domain or the domain you want to analyze in any cells, let’s say in A1.

Then, add the keywords you want to query on Google Search. For performance concerns, we recommend you to start with a maximum of 50 keywords. Simply add them in a column, as shown here:

Use the =IMPORTFROMGOOGLE() formula to extract the Google Search results

Let’s extract the title and the link of each result, for each keyword.

Just write the formula:  =IMPORTFROMGOOGLE(A4:A52,"keyword,title,link",",country_code:us")

Besides the 3 selectors we have entered (“keyword”, “title”, “link”), the domain option we added as the 3d parameter of the formula specifies the Google domain we want to retrieve the results from, and the country_code option specifies from which country we scrape Google Search results (in this example we chose the US).

After a few seconds, the first 10 organic results for eack keyword or query are loaded in a table.

Add the Google ranking beside each result

Now, we want to add the rank of each result. Simply add the following formula in cell C4: =IF(D4<>D3,1,C3+1)

Then drag it down till your last row and you’re done!

We’ve designed an easy-to-use template so you can try our Google Keyword Ranking Tracker.
Make sure you have installed and activated ImportFromWeb in your Google Sheets.