Google app script library that lets you use google sheet like a key value pair database.

Usage Link to heading

ProjectId:Mh3fuMDJ6YrJ-WBuWKeMtlj6333tZbdFa

Go to Resources > Libraries and add the above library using the above project id.

Learn By Example Link to heading

Open a spreadhseet as sheetdb Link to heading

var sid = "1Y6N-jNCF23TyE8WbV8FEEfUcdDDCw5IlvNt9wCOwg9w";
db = new SheetDb(sid,"SheetName");

Add record Link to heading

let value = {"first_name":"sujit","last_name":"maharjan"};
db.set(value);

Read record Link to heading

let value = db.get({"first_name":"sujit"});

Update record Link to heading

db.update({"first_name":"sumit"},{"first_name"":"sujit"});

Delete record Link to heading

db.removeRows({"first_name":"sujit"});

github