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);
}
}