If you want to improve your own productivity or that of your SEO team then why not try our simple add-on for Google Sheets that adds 3 really useful SEO tools to any Google sheet.
Listing updated:March 17, 2023
Works with:
707
Overview
3 Great SEO Tools for Google Sheets in 1 add-on!

The “Authoritas Really Useful Keyword Tool” add-on gives access to three core SEO tools powered by the Authoritas SERPs API.  You have the option to query all 3 tools at once or to just select the specific tools and output format you are interested in.

*** 1- Keyword Ranking for Google Sheets ***

Add a list of keywords to any sheet and get rankings for multiple domains from any search engine worldwide.

*** 2 - Top 100 SERP Results for Google Sheets ***

You can also get a list of the top 100 competing sites for every keyword.

*** 3 - Keyword Research with User Intent ***

Our keyword research tool gives you User Intent, Above the Fold analysis and comprehensive suggestions from related searches and People Also Ask results.

*** HOW TO GET STARTED ***

Get a free API key from Authoritas and get 1,000 keyword credits per month for free.  For further details see: https://www.authoritas.com/google-sheets-add-on-the-really-useful-keyword-tool/

*** Common SEO Use Cases & Challenges Solved by this Sheets add-on ***

- Perform one-off or regular scheduled keyword ranking tasks
- Check the rankings of multiple domains in one go (so you can track social media channels, sub-domains and microsites)
- Pull-in and analyse the top 100 competitors for any keyword in any major search engine worldwide
- Perform in-depth keyword research and get related keywords, questions people ask, universal SERP features and unique to Authoritas – the keyword or user intent for the keyword phrase
- Once the data is in Sheets you can easily visualise it in Google Data Studio and/or send it to Big Query
- If you are considering using the Authoritas SERPs API for your SEO project, then the Google Sheets add-on is a great way to test the API without having to get an engineer to do it for you

*** Further Details of these 3 great SEO tools ***

1. Keyword Ranking for Google Sheets

This tool replicates the keyword ranking functionality found in the Authoritas SEO platform.

If you have ever wanted to create your own keyword rank checking tool then we’ve just made the job really easy for you.

Simple enter a list of keywords and a search engine combination and click ‘RUN’.

You can run a request on-demand whenever you want and/or you can schedule lists of keywords to run on a regular schedule (daily, weekly or monthly).

Your Google Sheet will then call our Keyword Ranking API and create a task to collect all the data for you.  For each valid request we return the following data in a new sheet called “Keyword Rankings”:

Organic Rank – the position for your domains within organic ranking results only
Organic URL – the page(s) for your domain(s) which is ranking in the organic results
Above the Fold – a flag indicating whether the organic ranking page is above the fold of the page
Visible – a flag indicating whether the Organic URL is visible to a user without scrolling (e.g. It may appear but be hidden in a carousel)
Universal Rank – the position for your domains within all results types (e.g. Including organic, featured snippets, videos, images, social, etc).
SERP Feature – The type of Universal Search result – e.g. Video, News, Image, etc.
Universal URL – the page(s) for your domain(s) which is ranking in the Universal Ranking position
Above the Fold – a flag indicating whether the organic ranking page is above the fold of the page
Visible – a flag indicating whether the Universal URL is visible to a user without scrolling (e.g. It may appear but be hidden in a carousel)

We also record the full request details for each keyword request to help your analysis: Date and time, the Search Engine, Region, Language, Device, Town, Latitude & Longitude.

2 - Top 100 SERP Results for Google Sheets

This tool gives you the complete listing of all ranking URLs and universal search results for each keyword, as if you had made a request to the Authoritas SERPs API.

This is a great way of analysing the URLs you are competing with to diagnose competitors who are outperforming you and Universal Search opportunities to go after such as Featured Snippets, Videos, Images, People Also Ask, etc.

3 - Keyword Research with User Intent

N/B: You must select Google as your search engine if you want to use this tool.

This gives you deep information about your keyword and related keywords and replicates some of the advanced keyword research tools and data in the SEO platform.  It offers you a great way of improving your existing keyword research process.  Enter a seed list of keywords and the service will return a list of up to 8 related keywords and up to 4 questions that people also ask (this may not appear for all keywords).

Uniquely, the service will also return you the User Intent for each keyword which should help you determine what type of content you need to write for each keyword phrase.

Local Intent – Do local listings appear for this keyword. This flag is a signal that local businesses have a good opportunity to compete with major national brands.

Dominant User Intent – This indicates the primary intent of the user across the 4 types of User Intent.

Navigational Intent Score – Search terms that are centered on a brand, company or person.

Informational Intent Score – Keywords that have low commercial intent.
Research Intent Score – Search phrases with strong commercial intent earlier in the buyer journey.

Transactional Intent Score – Search phrases with high purchase intent and value close to the end of the buyer journey
Additional information
PricingNot available
Developer
Non-trader
Privacy policy
Terms of service
Authoritas SEO - The Really Useful Keyword Tool will ask for the permissions shown below. Learn more
Authoritas SEO - The Really Useful Keyword Tool will need access to your Google account
This will allow Authoritas SEO - The Really Useful Keyword Tool to :
See, edit, create, and delete only the specific Google Drive files you use with this app
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Mike Lawrie
October 19, 2021
What an amazing tool - generous credit allowance to get a comprehensive taste of what is under the hood. The quality and accuracy of the tool are amazing. An absolute must to get your SEO foundations right. Support is excellent had an answer via email within an hour, unheard of in this game. Strongly recommended...
Is this review helpful?
Yes
No
1-1 of 1
Search
Clear search
Close search
Google apps
Main menu