Google Sheets custom function that returns status of the shipment serviced by "Nova Poshta" express delivery.

getCargoStatus.gs

//Keep in mind that Nova Poshta may change tracking API method to require phone number
/**
 * Returns current status of cargo.
 *
 * @param {number} invoice Invoice number.
 * @return {string} cargo status information.
 * @customfunction
 */
function getCargoStatus(invoice) {
  
  if(!invoice || isNaN(invoice)) {
    throw new Error("Bad value");
  }
  
  var apiKey = "your_api_key_goes_here";//To perform API requests Nova Poshta API key needed
  var url = "http://testapi.novaposhta.ua/v2.0/en/documentsTracking/json/";
  var payload, options, response;
  
  payload = JSON.stringify({
    "apiKey": apiKey,
    "modelName": "TrackingDocument",
    "calledMethod": "getStatusDocuments",
    "methodProperties": {
      "Language": "UA",
      "Documents": [
        {
        "DocumentNumber": invoice, 
        "Phone": "380ХХХХХХХХХ"
        }
      ]
    }
  });
  
  options = {
    "method": "post",
    "contentType": "application/json",
    "payload": payload
  };
  
  response = JSON.parse(UrlFetchApp.fetch(url, options));
  
  if(!response.success) {
    throw new Error(response.errors.toString());
  }
  
  return (response.data[0].Status);
}