Search API Connector Documentation

Print

Import Wildberries Data to Google Sheets

Last Updated On
byAna
< Knowledge Base

In this guide, we’ll walk through how to pull data from the Wildberries API directly into Google Sheets, using the API Connector add-on.

We'll first get an API token from Wildberries, and then set up a request to pull in metrics to your spreadsheet.

Contents

Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Get Your Wildberries API Key

  1. Log in to your Profile on the Wildberries Suppliers portal
  2. Click Настройки > Доступ к новому API > создать новый ключ ("Settings > Access to API > Create new key")
  3. Give your key a name, and select the Статистика ("Statistics") key type
  4. Click Создать ключ ("Create a Key")
    wildberries-createkey
  5. Your key will now be displayed. Copy it and keep it safe; we'll use it shortly.

Part 2: Pull Wildberries API Data into Sheets

You can access any of the endpoints and parameters listed in the API documentation.  Here's an example request setup showing how to fetch reporting stats from your account. Substitute in your API key where it says your_key.

  1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
  2. In the request form enter the following:
    • Application: Custom
    • Method: GET
    • Request URL: https://statistics-api.wildberries.ru/api/v1/supplier/reportDetailByPeriod?dateFrom=2023-08-06&dateTo=2023-09-21&rrdid=0&limit=100000
    • OAuth: None
    • Headers:
      • Authorization: your_key
  3. Create a new tab and click Set current to use that tab as your data destination.
  4. Name your request and click Run. A moment later you’ll see Wildberries data populate your sheet.
    wildberries-report

Part 3: API Documentation

Official API documentation: https://openapi.wildberries.ru/en/#tag/Statistics

Leave a Comment

Jump To