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/statistics/api/en/#tag/Statistics

5 thoughts on “Import Wildberries Data to Google Sheets”

  1. Good afternoon! Specify how to display column headers, I have data output as a result of an API request, but without column headers, the values go immediately.

    Reply

    • Column headers should be included automatically by default. Can you please double check a) you're in overwrite (not append) mode, and b) you haven't ticked the "Remove headers" box? Both settings are located under Output options.

      Reply

  3. tell me what I'm doing wrong?

    https://common-api.wildberries.ru/api/v1/tariffs/box?date=+++Sheet2!A1+++

    1) 11: Completed with errors
    - We received an error from wildberries.ru (400) show response
    Invalid date param

    Reply

    • Based on the error message, looks like the date is in the wrong format. Make sure you've converted it into the YYYY-MM-DD format required by Wildberries, 1) i.e. add your date into a cell, 2) convert that cell with a function like =text(A1,"yyyy-mm-dd"), and then 3) reference that second cell.

      Reply

Leave a Comment

Jump To