Check Prices Webhook

function doPost(e) {
  var postdatacontents = JSON.parse(e.postData.contents)
  var ss = SpreadsheetApp.openByUrl('INSERT YOUR SHEET URL HERE')
  var sheetarray = ss.getSheets();

//This code will display Check Prices items on sheets named after FFXIV's servers. You must create the initial sheets and name them appropriately.
  var sheetnum = 0;
  for (var x = 0; x < sheetarray.length; x++) {
    if (sheetarray[x].getName() == postdatacontents.server)
      sheetnum = x;
  }
  var sheet = ss.getSheets()[sheetnum];
//This code will display Check Prices items on sheets named after FFXIV's servers. You must create the initial sheets and name them appropriately.

  sheet.clear();
  sheet.getRange(1,1).setValue('Items');

  var numberOfItemsToCheck = postdatacontents.items.length;
  var greatestLength = 0;
  for (var c = 0; c < numberOfItemsToCheck; c++)
  {
    if (postdatacontents.items[c].prices.length > greatestLength)
    {
      greatestLength = postdatacontents.items[c].prices.length;
    }
  }
  sheet.getRange(1,greatestLength + 2).setValue('Ave. Price');
  for (var c = 0; c < numberOfItemsToCheck; c++)
  {
    sheet.getRange(c+2, 1).setValue(postdatacontents.items[c].name);
    for (var d = 0; d < postdatacontents.items[c].prices.length; d++)
    {
      sheet.getRange(c+2,d+2).setValue(postdatacontents.items[c].prices[d].price);
    }
    sheet.getRange(c+2, greatestLength + 2).setValue(postdatacontents.items[c].ave_price);
  }
  
  return ContentService.createTextOutput('Success');
}