Skip to content

Instantly share code, notes, and snippets.

@St3ph-fr
Created August 3, 2012 12:05
Show Gist options
  • Save St3ph-fr/3246983 to your computer and use it in GitHub Desktop.
Save St3ph-fr/3246983 to your computer and use it in GitHub Desktop.
Google Apps Script - Add all the data in a google spreadsheet to the scriptdb database
// #GoogleAppsScript #Gscript #GoogleSpreadsheet
//Personalised from google help page : https://developers.google.com/apps-script/scriptdb
function setup(){
ScriptProperties.setProperty('sheet', SpreadsheetApp.getActiveSpreadsheet().getId());
}
function addAll() {
var spreadsheet = SpreadsheetApp.openById(ScriptProperties.getProperty('sheet') );//Run setup in first to initialise script var 'sheet'.
var columns = spreadsheet.getLastColumn();
var sheet = spreadsheet.getSheetByName("NomDeLaFeuille"); //NomDeLaFeuille name of the sheet where you store the data
var data = sheet.getDataRange().getValues();
var keys = data[0];
var db = ScriptDb.getMyDb();
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);
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment