News 9 min read February 20, 2018

Serpstat API SDK: Get Your Own SEO Tool In Google Sheets

Serpstat API SDK: Get Your Own SEO Tool In Google Sheets
Picture by Maria Marikutsa

Oleg Salamaha
Founder and VP
of Product at Serpstat
To ease the life of our users, Serpstat team has developed a full-fledged SEO tool in the Google Spreadsheet that pulls Serpstat data via API. In this post, I'll show you how to set up a spreadsheet to get Serpstat analytics data through API in a quick and efficient way.
API (application program interface) allows to pull large amounts of data without using Serpstat website. You can also embed Serpstat analytics data into your own internal software or reporting system.

The tool we created allows to get all the data found under Domain Analysis and Keyword Research sections without having to manually research search terms, URLs or domains one by one which can be quite a tedious job for you digital marketers and business owners in a high-paced digital environment.
Do you want to learn more about Serpstat API? What data can you get from it? How to filter and sort the results? Then read our detailed guide on Serpstat API ↓
If you've already used our API, then don't hesitate to start saving your time with this brand new tool ↓
Keep reading to learn how to use this tool.

Instantiating an SEO tool in your Google Spreadsheet

To start getting Serpstat API data right into your spreadsheet, you need to make a few tweaks:
Open the document. You'll have the rights to view it only.
Make a copy of the document.
After making a copy, you'll see the "Configure" tab. Please note that it may take some time until the tab appears in your copy of the document. Click on "Configure" to give your permission to run this document on your Google account.

Giving your permission to the script to run in your Google account

Log in to your Google account and give the script your permission to run in your spreadsheet: view and manage spreadsheets that this application has been installed in.
After allowing Serpstat – Google Spreadsheet API SDK to use your information in accordance to their terms and privacy policies, a window will appear prompting you to enter an API token. A unique API token will allow fetching Serpstat data through API according to the limits of your plan.

Getting your API token and setting up API access

You can create a unique API token in your account details. APi access is available to subscribers of Plan B or higher.

If API access is not available on your account, please contact us through a
demo request form or a live chat on the website.

Make sure to write "API token" in the comment section.
After getting a token, paste it into the API token field in your document. The field's background will become blue if the entered token is valid. Now you're good to go.

Setting parameters

Choose the language . The spreadsheet interface supports two languages: English and Russian.

please refresh the document after selecting a language.
Next, you need to select one of the supported search engines. You can learn about the stats of all available Serpstat databases on this page.
The main worksheet of the spreadsheet also has a link to the API documentation which you can refer to for a detailed description of methods and responses.


The first version of the document allows fetching data from 16 reports:

  1. Advertising report – a worksheet used to pull ads that are displayed in paid search for a seed keyword.
  2. Competitors report – a worksheet used to pull the most powerful competitors for your keyword and its associated search terms.
  3. Domain history report – a worksheet used to pull historical data on the domain's visibility trend and number of keywords.
  4. Domain info report – a worksheet used to pull the overall performance of a domain: number of keywords ranked for, number of paid keywords, direct competitors, pages with the highest visibility score, current visibility score etc.)
  5. Domain Keywords Report – a worksheet used to pull all keywords a domain is ranking for in Top 100 search results in the specified search engine.
  6. Domain Intersection report – a worksheet used to pull common keywords among compared domains.
  7. Domain unique keywords report – a worksheet used to pull unique keywords of one of the compared domains.
  8. Domain urls report – a worksheet used to pull domain's URLs that rank for at least one search term in Google's Top 100 search results. The report also features the number of keywords each of these URLs ranks for.
  9. Keyword info report – a worksheet used to pull keyword metrics: monthly search volume, cost per click, keyword SEO difficulty etc.
  10. Keywords report – a worksheet used to pull associated search terms for your seed keyword based on full-text search. The report contains all crucial metrics for returned keywords: monthly search volume, cost per click, keyword SEO difficulty etc
  11. Keyword top report – a worksheet used to pull the Top 100 search results for a keyword.
  12. Related keywords report – a worksheet used to pull keywords that produce 1 to 20 listings that are identical to the listings for your seed keyword in Top 20 search results.
  13. Suggestions report – a worksheet used to pull search suggestions for your seed keyword based on full-text search.
  14. URL competitors report – a worksheet used to pull competitors for the researched URL.
  15. URL keywords report – a worksheet used to pull keywords that the researched URL ranks for.
  16. URL missing keywords report – a worksheet used to pull keywords that competitors of the researched URL rank for in Top 10 search results, while your URL doesn't rank for them even in Top 100 search results.

    Sample report

    Let's take some worksheet for a sample report. Let it be Advertising report that returns all ads displayed for our search terms and the associated keywords based on the full-text search.
    A link to the page with detailed description of the API method.
    A green button to refresh the report. If an error occurred at the script runtime, just click on the button to pull the data anew.
    Pagination. Here you can specify how many results and from what pages will be pulled (like the ones that you see on the website).

    The number of API rows you'll be charged for an API query depends on the number of returned results each data item in the results takes away one API row from your account. The number of available API rows depends on your plan.

    A single query for your domain keywords or related keywords is made by the script, but multiple items are returned in the response, each of them being considered as an API row withdrawn from your account.

    As a real world example, you'll be charged 200 API rows for a seed keyword that returned 200 related keywords.
    Choosing a search engine
    • click on the drop-down list icon
    • remove the field value if you want to choose another search engine
    • after deleting the field value, you'll be able to choose another search engine
    The workflow is similar in all worksheets of the Serpstat — Google Spreadsheet API SDK.
    Please don't change the internal settings of the script if you're not an experienced developer. In case of any issues, please contact Serpstat support team.

    Download this manual in PDF format to get back to it whenever you want.
    Don't hesitate to ask if you have any questions!

    Recommended articles

    Subscribe to our newsletter
    Keep up to date with our latest news, events and blog posts!


    Sign In Free Sign Up

    You’ve reached your query limit.

    Or email
    Forgot password?
    Or email
    By clicking 'Sign Up Free' I agree to Serptat's
    Terms of Service and Privacy Policy
    Back To Login

    Don’t worry! Just fill in your email and we’ll send over your password.

    Are you sure?
    Please pick the project to work on

    Personal demonstration

    Serpstat is all about saving time, and we want to save yours! One of our specialists will contact you and discuss options going forward. These may include a personal demonstration, a trial period, comprehensive training articles & webinar recordings, and custom adivce from a Serpstat specialist. It is our goal to make you feel comfortable while using Serpstat.

    Skype or Google Hangouts

    Upgrade your plan

    Sign Up Free

    Спасибо, мы с вами свяжемся в ближайшее время


    You have run out of limits

    You have reached the limit for the number of created projects. You cannot create new projects unless you increase the limits or delete existing projects.

    I want more limits

    Christmas is a time for miracles.

    You are almost on the finish line of our Christmas quest. The last brick of your lego-promocode is left on the way up 55% discount.

    Did not find previous lego-bricks? Fill the form anyway.

    Skype or Google Hangouts
    Write your discount code