Google Keywords Ranking Tracker

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.

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","domain:.com,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!