Query Google Spreadsheet with Miso Dataset or other JS library?

Question

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 ...)

score 1 · Answer 1 · answered Apr 25 '13 at 09:09

1

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

answered Apr 25 '13 at 09:09

Alerkesi

165
8

score 0 · Answer 2 · edited May 23 '17 at 11:43

0

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.

edited May 23 '17 at 11:43

Community

1
1

answered Apr 19 '13 at 08:14

eddyparkinson

3,680
4
26
52

score 0 · Answer 3 · answered May 14 '13 at 05:11

0

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.

answered May 14 '13 at 05:11

Josh

3,385
5
23
45

Query Google Spreadsheet with Miso Dataset or other JS library?

3 Answers3