Google Sheets - App Script - Binance Prices

script.js

function myFunction() {

  // https://api.binance.com/api/v3/ticker/price?symbols=%5B%22BTCUSDT%22,%22ETHUSDT%22%5D

  const sheetStatus = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('SHEET_NAME');

  const _rows = SpreadsheetApp.getActiveSheet().getDataRange().getValues()
    .filter(e => e[1] === 'USDT' || e[1] === 'BUSD')
    .map((e, i) => {
      // 0 = Column A
      // 1 = Column B
      return { index: i, symbol: e[0] + e[1] };
    });

  //console.log(_rows);

  const rows = {};
  _rows.forEach(e => rows[e.symbol] = e.index);

  //console.log(rows);

  const apis = ['api', 'api1', 'api2', 'api3'];
  const binanceUrl = `https://${apis[Math.floor(Math.random()*apis.length)]}.binance.com/api/v3/ticker/price?symbols=%5B${_rows.map(e => `%22${e.symbol}%22`).join(',')}%5D`;

  //console.log(binanceUrl);

  const prices = JSON.parse(
    UrlFetchApp.fetch(binanceUrl, {
      method: 'GET',
      json: true,
      gzip: true
    }).getContentText()
  );

  prices.forEach(e => {
    // 3 = Column C
    const index = rows[e.symbol];

    const range = sheetStatus.getRange(index + 2, 3);
    range.setNumberFormat("#.##0,00;(#.##0,00)");
    range.setValue(e.price.replace('.', ','));

  //console.log(`row.index: ${index}, row.price: ${e.price}`);

  });

  //console.log(prices);
}

sheets.csv

Steps

• Extensions > App Scripts on Google Sheet
• write code on App Script Editor
• set Trigger if you want

Automation with Google Apps Script Triggers