Created
August 3, 2012 12:05
-
-
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
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// #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