Exporting Sales Report to Google Sheet

Why use Google Sheets

---

Advantages

1. Efficiency. Reduces manual labor.
2. Accuracy. Minimizes the risk of errors.
3. Scalability. Works with large volumes of data.
4. Relevance. Fresh data will always be at hand.

In this article, we will explain how to set up this integration.

---

---

Step 2: Set up Google Sheets

1. Open Google Sheets and create a new document.
2. Expand the "Extensions" menu and select "Apps Script".

---

Step 3: Create a script to export data

1. Create a new project in the script editor and paste the ready-made code.
2. Replace YOUR_API_TOKEN with your own token.
3. In the var baseUrl parameter, set the report date range, for example, dateFrom=2024-01-29&dateTo=2025-01-01.
4. Name the script, for example, "Sales Report".
5. After setup, click the "💾" button.

Note: Data is available starting from January 29, 2024.

function getDataFromAPI() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var token = 'ВАШ_API_ТОКЕН';
  var limit = 100000;
  var baseUrl = 'https://statistics-api.wildberries.ru/api/v5/supplier/reportDetailByPeriod?dateFrom=2024-01-29&dateTo=2025-01-01&limit=' + limit;

  var lastRow = sheet.getLastRow();
  var headers = [];
  var rrdid = 0;

  if (lastRow > 1) {
    headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0];
    var rrdidIndex = headers.indexOf('rrd_id');
    if (rrdidIndex !== -1) {
      rrdid = sheet.getRange(lastRow, rrdidIndex + 1).getValue();
    } else {
      throw new Error("Колонка 'rrd_id' не найдена в заголовках.");
    }
  } else if (lastRow === 1) {
    headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0];
  }

  var data, response, url;
  var allData = [];
  var headersSet = (headers.length > 0);

  while (true) {
    url = baseUrl + '&rrdid=' + rrdid;
    var encodedUrl = encodeURI(url);
    var options = {
      'method': 'get',
      'headers': {
        'Authorization': token
      },
      'muteHttpExceptions': true
    };

    try {
      response = UrlFetchApp.fetch(encodedUrl, options);

      if (response.getResponseCode() !== 200) {
        throw new Error('Ошибка API: ' + response.getContentText());
      }

      data = JSON.parse(response.getContentText());

      if (data === null || data.length === 0) {
        Logger.log('Нет больше данных для выгрузки.');
        break;
      }

      if (!headersSet) {
        headers = Object.keys(data[0]);
        sheet.appendRow(headers);
        headersSet = true;
      }

      data.forEach(function(row) {
        var values = headers.map(function(header) {
          return row[header];
        });
        allData.push(values);
      });

      rrdid = data[data.length - 1].rrd_id;
      Logger.log('Следующий rrdid: ' + rrdid);

      if (data.length < limit) {
        Logger.log('Выгружены все доступные данные.');
        break;
      }

    } catch (error) {
      Logger.log('Ошибка при запросе данных: ' + error.message);
      break;
    }
  }

  if (allData.length > 0) {
    sheet.getRange(sheet.getLastRow() + 1, 1, allData.length, allData[0].length).setValues(allData);
  }
}

---

Step 4: Run the script

1. Click "▶️ Run" to execute the script.
2. The system will request permission to run the script. To grant it:

• Click "Review Permissions" in the popup window,
• Then select your account, click "Advanced Settings",
• Then "Go to page...", → "Allow".

1. Return to the created sheet, where you will see your report.

---

---

Build integrations with WB API

Automatic data collection provides sellers with a significant advantage and is becoming increasingly indispensable for successful business management.