k0sti

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('Korttipulautin')
      .addItem('Luo Ilmiökortit', 'createScenarioCards')
      .addItem('Luo Linssikortit', 'createLensCards')
      .addToUi();
}

function getNamedRange(name) {
  var sheet = SpreadsheetApp.getActive();

russorat

/************************************
* Store Account, Campaign, and AdGroup Level Quality Score
* Version 2.3
* ChangeLog v2.3
*  - Solved #NUM! issue by filtering out -- values
* ChangeLog v2.2
*  - Updated KeywordText to Criteria
* ChangeLog v2.1
*  - Ignore negatives
* ChangeLog v2.0

mhawksey

function getJSON(aUrl,sheetname) {
  //var sheetname = "test";
  //var aUrl = "http://pipes.yahoo.com/pipes/pipe.run?_id=286bbb1d8d30f65b54173b3b752fa4d9&_render=json";
  var response = UrlFetchApp.fetch(aUrl); // get feed
  var dataAll = JSON.parse(response.getContentText()); //
  var data = dataAll.value.items;
  for (i in data){
    data[i].pubDate = new Date(data[i].pubDate);
    data[i].start = data[i].pubDate;
  }