Get access to 30+ marketing and SEO tools. analyze competitors, keywords, and backlinks for free..

We use cookies to make Serpstat better. By clicking "Accept cookies", you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Learn more

One-click batch data analysis

We created Serpstat Google Sheets add-on to simplify and automate your work with analytical data.

In just a few clicks you can get information about domains or pages, grouped in separate tabs of Google Sheets.
Serpstat is a leader in SEO on G2
Serpstat is a leader in SEO on G2
Serpstat is a leader in SEO on G2
Serpstat - Content ideas from autocomplete suggestions | Product Hunt
How to start using Serpstat add-on for Google Sheets?
1
2
3
4
5
6
7
batch analysis
Go to Chrome marketplace and press the Install button.
Go to the Add-ons section and select Serpstat Batch Analysis. There are two buttons in the menu: Create report and Settings.
Creating the report
To use the add-on and upload the necessary data, you need to copy the API key (token) in the personal profile and enter it into the appropriate field. After that you'll see a sidebar.
But the first question that arises: is the indicator that we get good or bad? To do this, we derive a scale where we show the relevance, based on the competitor analysis. This is the average value indicated by the green area.

If we approach the minimum value, it means that the words from the query are too far apart in the text on the page, or are seldom used.

If we see that the indicator is approaching the maximum, then this indicates spam. You can remove some of the repeated words, or distribute them less often in the text.
In the menu on the right you need to:

- Select a search engine. Choose a regional database for which you want to get a report.
- Select a cell range. It displays the cell value in which the cursor was placed by default. It must be set manually.
Select a report. Choose the API method which you need to get data. After that, filters will open (if they are provided for this method). Set up the filters and click Create Report.
The report will appear on a new table sheet.
Access and limits
To receive Serpstat reports in Google Sheets you need to have:
Serpstat account
API access
Personal API token
If you don't have the API access, contact the support team by completing a product demonstration form, or you can use our live chat.
What are the benefits of the platform?
1
The use of the platform is completely free for all Google users.
2
Creating the reports doesn't take up so much time and doesn't require special knowledge or skills.
3
Reports can be tailored to your specific needs.
4
Data is automatically loaded from integrated sources and displayed in real time.
5
You can share dashboards via the link, and it is very convenient for teamwork
Open support chat

Share this article with your friends

Sign In Free Sign Up

You’ve reached your query limit.

Or email
Forgot password?
Or email
Optional
Back To Login

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

Are you sure?

Awesome!

To complete your registration you need to enter your phone number

Back

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

Introducing Serpstat

Find out about the main features of the service in a convenient way for you!

Please send a request, and our specialist will offer you education options: a personal demonstration, a trial period, or materials for self-study and increasing expertise — everything for a comfortable start to work with Serpstat.

Name

Email

Phone

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

Thank you, we have saved your new mailing settings.

Invite
View Editing

E-mail
Message
Optional
E-mail
Message
Optional

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
share telegram telegram_channel