Google Keywords Ranking Tracker

Effortlessly monitor your organic rankings with Google Sheets.

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

See all available Google Search data points

Step by step

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

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.

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 you want to scrape data (in this example we chose the US).

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

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

Add the Google ranking beside each result

Simply add the following formula in cell C4: =IF(D4<>D3,1,C3+1)

Then drag it down!

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.