This site uses cookies and other tracking technologies to make possible your usage of the website, assist with navigation and your ability to provide feedback, analyse your use of our products and services, assist with our promotional and marketing efforts, and provide better user experience.

By using the website, you agree to our Privacy policy

Accept and continue


Report a bug

6061 14 3
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!

          Rate the article on a five-point scale

          The article has already been rated by 1 people on average 4 out of 5
          Found an error? Select it and press Ctrl + Enter to tell us

          Share this article with your friends

          Sign In Free Sign Up

          You’ve reached your query limit.

          Or email
          Forgot password?
          Or email
          Back To Login

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

          Are you sure?


          To complete your registration you need to enter your phone number


          We sent confirmation code to your phone number

          Your phone Resend code Queries left

          Something went wrong.

          Contact our support team
          Or confirm the registration using the Telegram bot Follow this link
          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 advice from a Serpstat specialist. It is our goal to make you feel comfortable while using Serpstat.




          We are glad of your comment
          Upgrade your plan

          Upgrade your plan

          Export is not available for your account. Please upgrade to Lite or higher to get access to the tool. Learn more

          Sign Up Free

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

          View Editing


          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