Skip to content

Google app script converts the google sheet into small db

Notifications You must be signed in to change notification settings

shubhajeet/SheetDb

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 

Repository files navigation

SheetDb

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

Usage

ProjectId:Mh3fuMDJ6YrJ-WBuWKeMtlj6333tZbdFa

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

Learn By Example

Open a spreadhseet as sheetdb

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

Add record

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

Read record

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

Update record

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

Delete record

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

About

Google app script converts the google sheet into small db

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published