Helper for Google appscript sheet crud operation
$ npm install
npm run build
Copy file contents in dist/index.js into your App script. Then you can use like this
var sheet = sheet = SpreadsheetApp.openByUrl(sheetUrl);
var sheetHelper = new SheetHelper(sheet.getSheets()[0],{idColumn:0});
//Insert Item
sheet.Helper.create([1,"Data 1","Data 2"]);
//Find an item where coloumn 2 id Data
var item = sheetHelper.find(2,"Data");
Create an item in sheet as Row,
Parameters
item
Read A Row by id
Parameters
id
Returns any
This will find a value in a specif column, Will return an array of all matches
Parameters
columnvalue
Returns Array
* This will find a value in a specif column, Will return an array of all matches
Parameters
columnvalue
Returns Array
Update a row by Row
Parameters
rowitem
Update a row by ID
Parameters
iditem
Delete a row by ID
Parameters
id
Returns boolean
MIT © saleeh