Live data from Hacker News

Show HN: Sheetlabs – Turn your spreadsheets into APIs

sheetlabs.com

51–60 of 82 posts

Re: Show HN: Sheetlabs – Turn your spreadsheets into APIs

#51

They (Ycombinator) should implement 'mark as favorite'. There are so many similar tools included in the comments that I'm writing this comment just to have a quick shortcut to find the thread in future references.

Your browser almost certainly has a bookmarks feature. If you don't like that, I use and would recommend InstaPaper.

Re: Show HN: Sheetlabs – Turn your spreadsheets into APIs

#53
post #20

This is a really clever idea. So simple and almost-obvious, yet it's the first time I come across this. Genius. Particularly like the fact that REST APIs are pretty easy to start with providing GET access to resources, but get messy when you start doing POST, PUT, DELETE, PATCH etc. In this case, it's read-only by definition. That must make things so much easier. I can anticipate people asking for update access in fu…

Actually there is a company out there called https://www.ragic.com/ . Not exactly same but similar.

This strikes me as different. This looks a lot like Microsoft Access. A tool for "simplifying" database construction and common tasks like reporting (which doesn't actually work except in very simple cases, because you quickly reach the point of needing to understand concepts like normalization and foreign keys even if the GUI is pretty).

Re: Show HN: Sheetlabs – Turn your spreadsheets into APIs

#54
This is really cool, and a nice implementation. My question is about target customers. Presumably, you have two sides to this: non-devs writing and uploading the spreadsheet, and devs writing a client to to consume its API. I would imagine these two parties would be in the same company. e.g., Sales team wants some analytics dashboards written over their spreadsheets. So they upload a sheet and give it the API to devs, and then the devs consume the API, analyze the data, and pull it into a dashboard. Also presumably, it would be the devs recommending to the non-devs that they upload their spreadsheet here for easy access.

But if this is the case, why would the devs choose to use this over any number of CSV or XLS parsing libraries? You can write a simple web server that takes a spreadsheet as an upload, and then parse it to CSV, in less than 50 lines of code. The CSV reading APIs in any language are very easy to use and parse to native data structures, and I would argue maybe even easier than using an API like this.

What is your value proposition to devs in this scenario? Or I missing an entirely different use case?

Re: Show HN: Sheetlabs – Turn your spreadsheets into APIs

#57
This seems like a nice layer between some data scientists that might be used to working with csv's or some subset of databases, and a dev team that happens to be using another subset of db's. Data scientists could throw some results into a csv and front end devs could quickly pull it in as a rough version of what the actual API would look like to get started on presentation of the data. First pass mockups could be done taking minimal time away from the engineering team, iterate these with stakeholders, and finally implement the final API with the fully fleshed out front end.

Re: Show HN: Sheetlabs – Turn your spreadsheets into APIs

#58
post #45

Earlier quoted context omitted.

You need to put up some examples of what can be done by this service. Something visitors can interact with without registering is ideal to convince them to register.

There's an example API created with the service here: https://sheetlabs.com/#/services/doc/ACME/getDomain This is linked off the front page, but could certainly be more prominent (as another commenter said)

I stared at that for 10 minutes trying to find the spreadsheet. I assume there is a spreadsheet backing it? You should actually show people the spreadsheet - just seeing an API description without demonstrating that it runs off a simple spreadsheet almost kind of defeats the whole purpose of the service!

Re: Show HN: Sheetlabs – Turn your spreadsheets into APIs

#59
What makes this better than using the Google Docs API? I could have anyone write to a spreadsheet and in turn it would be updated when called on their API.

In fact I do that for many small business clients of mine which don't want to deal with databases for things like their product catalog and pricing lists.

Additionally you get version control, busier sites get the google doc scraped X times a minute as to not reach the request limit.

Re: Show HN: Sheetlabs – Turn your spreadsheets into APIs

#60
post #58

Earlier quoted context omitted.

There's an example API created with the service here: https://sheetlabs.com/#/services/doc/ACME/getDomain This is linked off the front page, but could certainly be more prominent (as another commenter said)

I stared at that for 10 minutes trying to find the spreadsheet. I assume there is a spreadsheet backing it? You should actually show people the spreadsheet - just seeing an API description without demonstrating that it runs off a simple spreadsheet almost kind of defeats the whole purpose of the service!

Thanks for the feedback. Yes, it is backed onto a spreadsheet effectively. Showing it is a good idea for the front page.

But I don't think showing the spreadsheet in the API docs is so useful; the idea is to present a clean API to the users, and they don't even need to know that the data was originally from a spreadsheet.

Post reply on HN