Extract JSON data from Semrush API with Google Apps Scripts

[Irfanabdulla1111]

Do you know how to extract JSON data from SEMrush API?
SEMrush is a great tool that offers many possibilities when it comes to researching keywords, searching for keywords, seeing changes in rankings, studying competitor ads, etc.

But there is not only SEMrush, there are many other tools that we would like to control and that we work with on a daily basis.

The problem is that we have to constantly open and close tabs and log into different tools to compare data and make decisions.

But what if we could extract this information and unify it within a single dashboard, offering all the data we need at a glance?

To make this easier for us, we have API connections, although unfortunately, programming knowledge is often required.

Today I'm going to explain how to extract information directly from your projects to send them to Google Spread Sheets with Google Apps Scripts.

Once there, you can use DataStudio or create your own reports from here, making it much more practical to work and analyze data.

When to use IMPORTDATA and when to use Google Apps Scripts?
Usually, the “ IMPORTDATA ” rule is sufficient if the information is given in vectors (arrays), this happens for the data from the SEMrush analytics API .

But when you request information from the SEMrush API, for the projects created within the tool that you track, the information is given in JSON.

Within the SEMrush documentation we can read:

All requests to the API use HTTP methods such as POST, PUT, GET or DELETE with JSON parameters and must contain the API Key

— SEMrush

So the IMPORTDATA function will leave us with a mess of data that is quite difficult to read if we use it.

The easiest solution is to use some javascript code, so I'm going to explain how to search for the information and the process to follow to extract all the information.

Even if you don't know much about programming, you'll be able to do it by the end of this article, but you'll need some concentration to understand everything.

By the end of this article you will be able to extract data with JSON and also work with other JSON email list providers in germany data by calling URLs.

Before moving on to see how to extract the information and the code I used to do so, it is important to understand what a JSON is and how the information in it is displayed.

What is a JSON?
It is a lightweight text format used in data exchange that is fairly easy to understand and read.

JSON example