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

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