Skip to content

Use a google spreadsheet as database. 3 Classes to make a google sheet API request and select the data from a sheet.

License

Notifications You must be signed in to change notification settings

reneFrings/spreadsheetAsDatabase

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

11 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

spreadsheetAsDatabase

Use a google spreadsheet as database. Classes to make a google sheet API request and select the data from a sheet.

spreadsheet

Set filter and columns to select data and make other queries...:

...
let objFilter = {
 Genres: ['anta','Action','Thrill'],
 Tags: ['Space','Favorite','Top10']
};

let arrColumns = ['Title','Genres','Tags'];
...               

... and get the data:

log

Usage

See index.html line:

  /**
   * Use the classes according to this structure.
   */
   ...

Please first share the spreadsheet so that anyone who has the link can open it.

spreadsheet-share

link-aendern

link-bestaetigen

Tested for

Windows 10 Desktop

  • Chrome

About

Use a google spreadsheet as database. 3 Classes to make a google sheet API request and select the data from a sheet.

Topics

Resources

License

Stars

Watchers

Forks