function onOpen(){
  var ui = SpreadsheetApp.getUi();
 ui.createMenu('Menu')
      .addItem('Get Lodgify Data', 'getLodgifyData')
      .addSeparator()
      .addItem('Create Trigger', 'createTrigger')
      .addToUi();
}
function getLodgifyData(){
  
  var data = {
    'X-ApiKey': 'yours API key'
  };
  var options = {
    'method' : 'get',
    'contentType': 'application/json',
    'headers' : data
  };
  var count = 0;
  var url = 'http://api.lodgify.com/v1/reservation?limit=50&status=Booked&trash=False&periodStart=2018-01-01';
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('sheet1');
  var lastRow = sheet.getLastRow();
  if(lastRow > 1){
    sheet.insertRowsAfter(lastRow, 1);
    sheet.deleteRows(2, lastRow-1);
  }
  do{
    var response = UrlFetchApp.fetch(url, options);
    var data = JSON.parse(response.getContentText());
    Logger.log(data)
    var completeRow = [];
    for(var i = 0; i < data.items.length; i++) {
      var row = [];
      row.push(data.items[i].guest.name)
      row.push(data.items[i].property_name)
      row.push(data.items[i].arrival)
      row.push(data.items[i].departure)
      row.push(data.items[i].total_amount)
      row.push(data.items[i].amount_to_pay)
      row.push(data.items[i].source)
      row.push(data.items[i].type)
      completeRow.push(row)
    }
    sheet.getRange(sheet.getLastRow()+1, 1, completeRow.length, 8).setValues(completeRow);
    //Logger.log(completeRow)
    url = data.next;
    count = count + data.items.length;
    Logger.log(count)
    Logger.log(url)
  }while(count < data.total)
  var range = sheet.getRange("A2:H"+lastRow);
  // Sorts by the values in column 3 (C)
  range.sort({column: 3, ascending: true});
}
function createTrigger() {
  // Trigger every 10 minute
  ScriptApp.newTrigger('getLodgifyData')
      .timeBased()
      .everyMinutes(5)
      .create();
}