CODEWITHSUNDEEP
javascriptgoogle-sheetsgoogle-sheets-apimiso.dataset
dani
dani

Reputation: 5000

Query Google Spreadsheet with Miso Dataset or other JS library?

I would like to use a Google Spreadsheet as a simple database.

Can I query for specific cells using Miso Dataset or another JavaScript library? I have seen Tabletop.js but I can't get the query part to work. (It fetches the full sheet or nothing ...)

Upvotes: 0

Views: 545

Answers (3)

Josh
Josh

Reputation: 3442

You can use the standard API to get certain cells: Google Spreadsheet API - Working with Cell-based feeds. Make sure to click the "Protocol" tab for the Javascript version.

Upvotes: 0

Alerkesi
Alerkesi

Reputation: 165

I know this man created js library for google spreadsheet here: https://github.com/mikeymckay/google-spreadsheet-javascript

Upvotes: 1

eddyparkinson
eddyparkinson

Reputation: 3700

CSV:

if you can make the spreadsheet public, this will work:

jquery google spreadsheet csv

If login is required, I think there is a way to do web based OAuth, but never used it.

Upvotes: 0

Related Questions