Serpstat API Batch Analysis Add-on For Google Sheets: Data Analysis In One Click

Setting up the add-on

Step 1. Go to Chrome marketplace and press the Install button.

Step 2. Go through a short authorization with your Google account:

Step 3. Go to the Extensions section and select Serpstat Batch Analysis. There are two buttons in the menu: Create report and Settings.

Creating a report

To use the add-on and generate the necessary data, you need to copy the API key (token) in My account and enter it into the appropriate field.

You can later change linked token in Settings.

After that, you'll see a sidebar.

In the menu on the right, you are to:

1. Select a search region. Choose a regional database for which you want to get a report.

2. Select a cell range. It displays a cell value in which the cursor was placed by default. It must be set manually.

To change the range, select the desired cells in the table. Click the icon near the corresponding field to save the changes.

If you need to select multiple ranges, click "Add another range". You can seperate ranges by commas in the right menu.

3. Select a report. Choose the API method for the data extraction. After that, filters will be opened (if they are provided for this method). Set up the filters and click Create Report.

The report appears in a new table sheet:

You can share a report with your team or client.

How are credits charged?

To get data using the Serpstat Batch Analysis add-on for Google Sheets, you need:

Serpstat API Batch Analysis add-on spends API credits:

API credits are spent according to the following formula: 1 domain / 1 URL / 1 keyword = 1 request.

Use Cases

The tool is primarily used by teams of specialists who require bulk analysis: SEO specialists, PPC specialists, copywriters, blog editors, SMM specialists, marketers.

If you still have questions, you can find answers in our FAQ, use cases or contact the technical support chat.