This tool will help you to easily check rankings for up to about 1000 keywords at a time. It uses the AuthorityLabs Partner API to aggregate ranking data quickly and scalably.
Once you have the link, copy the spreadsheet into your Google Sheets account – File > Make a copy.
Then deploy the doc as a web app by clicking Tools > Script Editor then Publish > Deploy as Web App.
When deploying as web app make sure to select “Anyone, even anonymous” for the “Who has access to the app:” option. This allows the AuthorityLabs Partner API to talk to Google Sheets.
Click Rank Checker > Setup and use the API key: spMpfgLDFL8lY8J5r8HG
Setup the Rank sheet with your keywords. For the locale, check http://api.authoritylabs.com/supported/google.json for country codes to use.
Click submit. After ~45 seconds you should see results start to populate.
You can watch the Engine tab as the Partner API starts to send results back to Google Sheets. For more locales to use see:
The number of keywords that can be done with this will vary but you should be able to do about 1,000 in one shot and get all those results back very quickly. This API key is shared by everyone who uses this tool. There are limits in place on that API account. If you’d like your own API key please email email@example.com.