Auto Buy Items Webhook

function doPost(e) {
  var postdatacontents = JSON.parse(e.postData.contents)
  var ss = SpreadsheetApp.openByUrl('urltoyourspreadsheet')
  var sheetarray = ss.getSheets();
  var sheetnum = 0;
  for (var x = 0; x < sheetarray.length; x++) {
if (sheetarray[x].getName() == postdatacontents.Character_Info.Name)
  sheetnum = x;
  }
  var sheet = ss.getSheets()[sheetnum];
  var itemprice = 0;
  var itemname = "";
  var itemquantity = 0;
  var itemexists = false;
  for (var c = 0; c < 140; c++)
  {
itemexists = false;
eval('if (null != postdatacontents.Inventory.Item_' + (c+1).toString() + '_Name) { itemexists = true; }');
if (itemexists)
{
  eval('itemname = postdatacontents.Inventory.Item_' + (c+1).toString() + '_Name; itemquantity = postdatacontents.Inventory.Item_' + (c+1).toString() + '_Quantity;');
  sheet.getRange(c+1, 1).setValue(itemname);
  sheet.getRange(c+1, 2).setValue(itemquantity);
}
  }
  sheet.getRange(141, 1).setValue("Gil:");
  sheet.getRange(141, 2).setValue(postdatacontents.Character_Info.Gil);

  //This code will display Buy List items on sheets named after FFXIV's servers. You must create the initial sheets and name them appropriately.
  sheetnum = 0;
  for (var x = 0; x < sheetarray.length; x++) {
if (sheetarray[x].getName() == postdatacontents.Character_Info.Current_Server)
  sheetnum = x;
  }
  sheet = ss.getSheets()[sheetnum];
  //This code will display Buy List items on sheets named after FFXIV's servers. You must create the initial sheets and name them appropriately.
  
  sheet.getRange(1, 4).setValue("Market Board Item");
  sheet.getRange(1, 5).setValue("Price");
  var c = 1;
  while (true)
  {
itemexists = false;
eval('if (null != postdatacontents.Market_Board_Prices.Item_' + (c).toString() + '_Name) { itemexists = true; }');
if (itemexists)
{
  eval('itemname = postdatacontents.Market_Board_Prices.Item_' + (c).toString() + '_Name;');
  eval('itemprice = postdatacontents.Market_Board_Prices.Item_' + (c).toString() + '_Price;');
  sheet.getRange(c+1, 4).setValue(itemname);
  sheet.getRange(c+1, 5).setValue(itemprice);
}
else
  break;
c++;
  }
  return ContentService.createTextOutput('Success');
}