Pull Facebook Advertising Metrics into Google Sheets

facebookads.gs

var SPREADSHEET_URL = "";
function facebookSpend() {
  var ss = SpreadsheetApp.openByUrl(SPREADSHEET_URL);
  var sheet = ss.getSheetByName('facebook');
  var values = [];
  Utilities.sleep(1000);
  var fullUrl = 'https://graph.facebook.com/v2.3/act_xxx/stats?access_token=xxx';
  var fetchRequest = UrlFetchApp.fetch(fullUrl);
  var results = JSON.parse(fetchRequest.getContentText());
  Logger.log(results.spent/100);
  values.push('spend',results.spent/100);
  sheet.appendRow(values);
}