Published using Google Docs
Spreadsheet to ScriptDB
Updated automatically every 5 minutes

function loadDatabaseFromSheet() {

  var sheetID = "<ID OF THE SPREADSHEET>";

  var spreadsheet = SpreadsheetApp.openById(sheetID).getSheetByName('<NAME OF THE SHEET>');

  var columns = spreadsheet.getLastColumn();

  var data = spreadsheet.getDataRange().getValues();

  var keys = data[0];

  var db = <YOUR LIBRARY’S NAME>.getDb();

  for (var row = 1; row < data.length; row++) {

    var rowData = data[row];

    var item = {};

    for (var column = 0; column < keys.length; column++) {

      item[keys[column]] = rowData[column];

    }

    db.save(item);

  }

}