Show HN: Turn a Google Spreadsheet into an API

#1

Post by michaeloblak » Mon, Sep 21, 2015, 12:22 PM UTC

Show HN: Turn a Google Spreadsheet into an API
sheetsu.com

Re: Show HN: Turn a Google Spreadsheet into an API

#2

Post by michaeloblak » Mon, Sep 21, 2015, 12:23 PM UTC

Paste Google Spreadsheet url and get a link to an RESTful API. Read (GET) and save (POST).

Re: Show HN: Turn a Google Spreadsheet into an API

#3

Post by nbevans » Mon, Sep 21, 2015, 1:06 PM UTC

API doesn't look very REST to me. It is basically just using HTTP as a JSON transport. The JSON contains a "status" code which appears to loosely follow the HTTP status code numbering. But if that was the intent then why not just use HTTP status codes like a true REST endpoint?

Otherwise, a neat idea. Needs a Office 365 connector too.

Re: Show HN: Turn a Google Spreadsheet into an API

#4

Post by JayeshSidhwani » Mon, Sep 21, 2015, 1:06 PM UTC

Will you maintain relationship between sheets? For many API use-cases, I'd expect my data to be relational.

Re: Show HN: Turn a Google Spreadsheet into an API

#5

Post by michaeloblak » Mon, Sep 21, 2015, 1:13 PM UTC

nbevans wrote: post #3

API doesn't look very REST to me. It is basically just using HTTP as a JSON transport. The JSON contains a "status" code which appears to loosely follow the HTTP status code numbering. But if that was the intent then why not just use HTTP status codes like a true REST endpoint? Otherwise, a neat idea. Needs a Office 365 connector too.

It's an MVP right now. Yep, will introduce those fixes this week! Thanks for kind words.

Re: Show HN: Turn a Google Spreadsheet into an API

#6

Post by [deleted] » Mon, Sep 21, 2015, 1:14 PM UTC

[deleted]

Re: Show HN: Turn a Google Spreadsheet into an API

#7

Post by michaeloblak » Mon, Sep 21, 2015, 1:15 PM UTC

JayeshSidhwani wrote: post #4

Will you maintain relationship between sheets? For many API use-cases, I'd expect my data to be relational.

It's great idea! I'll think about it. You want use each sheet as a separate table (like in DB), right?

Re: Show HN: Turn a Google Spreadsheet into an API

#8

Post by user1241320 » Mon, Sep 21, 2015, 1:17 PM UTC

Cool. I used https://github.com/jlord/sheetsee for a little thing. These things can be very handy.

Re: Show HN: Turn a Google Spreadsheet into an API

#9

Post by binoyxj » Mon, Sep 21, 2015, 1:20 PM UTC

Neat. Instantly converted my BTC price tracking spreadsheet [1] into an API [2]

1) https://docs.google.com/spreadsheets/d/1iUVXmC04KIU5K1Osb_4H...

2) http://sheetsu.com/apis/2aab25c7

Re: Show HN: Turn a Google Spreadsheet into an API

#10

Post by arethuza » Mon, Sep 21, 2015, 1:23 PM UTC

michaeloblak wrote: post #5

nbevans wrote: post #3

API doesn't look very REST to me. It is basically just using HTTP as a JSON transport. The JSON contains a "status" code which appears to loosely follow the HTTP status code numbering. But if that was the intent then why not just use HTTP status codes like a true REST endpoint? Otherwise, a neat idea. Needs a Office 365 connector too.

It's an MVP right now. Yep, will introduce those fixes this week! Thanks for kind words.

Microsoft (specifically Power BI) is pretty keen on consuming OData so exposing a Google spreadsheet as OData might be interesting.