Save top visited sites in Google spreadsheets

spreadsheet_script_topvisited.js

//  1. Enter sheet name where data is to be written below
        var SHEET_NAME = "Other";
         
//  2. Run > setup
//
//  3. Publish > Deploy as web app
//    - enter Project Version name and click 'Save New Version'
//    - set security level and enable service (most likely execute as 'me' and access 'anyone, even anonymously)
//
//  4. Copy the 'Current web app URL' and post this in your form/script action
//
//  5. Insert column names on your destination sheet matching the parameter names of the data you are passing in (exactly matching case)
 
var SCRIPT_PROP = PropertiesService.getScriptProperties(); // new property service
 
// If you don't want to expose either GET or POST methods you can comment out the appropriate function
function doGet(e){
  return handleResponse(e);
}
 
function doPost(e){
  return handleResponse(e);
}

function getJsonData(e){
  var dataAll = JSON.parse(e.parameter["data"]);
  var dataSet = dataAll;
  
  var email = e.parameter["email"];
  if(email){
    SHEET_NAME = email;
  }
  var doc = SpreadsheetApp.openById(SCRIPT_PROP.getProperty("key"));
  var sheet = doc.getSheetByName(SHEET_NAME);
    
  var rows = [],
      data;
  
    
    rows.push(["Title","URL"]); 
  
  
    for (i = 0; i < dataSet.length; i++) {
      data = dataSet[i];
      rows.push([data.title,data.url]); //your JSON entities here
    }
    
    dataRange = sheet.getRange(1, 1, rows.length, 2); // 3 Denotes total number of entites
    dataRange.setValues(rows);
  
  return sheet;
    
    
}


 
function handleResponse(e) {
  // shortly after my original solution Google announced the LockService[1]
  // this prevents concurrent access overwritting data
  // [1] http://googleappsdeveloper.blogspot.co.uk/2011/10/concurrency-and-google-apps-script.html
  // we want a public lock, one that locks for all invocations
  var lock = LockService.getPublicLock();
  lock.waitLock(30000);  // wait 30 seconds before conceding defeat.
   
  try {
    // next set where we write the data - you could write to multiple/alternate destinations
    
    
    
    sheet = getJsonData(e);
    //getFields(sheet,e);
    
    var nextRow = sheet.getLastRow()+1; // get next row
    
    return ContentService
          .createTextOutput(JSON.stringify({"result":"success", "row": nextRow}))
          .setMimeType(ContentService.MimeType.JSON);
    
   
  } catch(e){
    // if error return this
    return ContentService
          .createTextOutput(JSON.stringify({"result":"error", "error": e}))
          .setMimeType(ContentService.MimeType.JSON);
  } finally { //release lock
    lock.releaseLock();
  }
}
 
function setup() {
    var doc = SpreadsheetApp.getActiveSpreadsheet();
    SCRIPT_PROP.setProperty("key", doc.getId());
  //Logger.log(doc.getSheetByName(SHEET_NAME));
}