Sheety: How to Convert Google Sheets into an API
Sheety

If you find yourself experimenting with code often, it's not a bad idea to have an environment that lets you evaluate early results in seconds. Traditional methods work well, but the person behind Sheety presents a very striking alternative: turn any Google Sheets spreadsheet into an API. Publish, export to CSV, paste the final URL into Sheety, and that's it.

Unfinished projects, eternal prototypes, improvised patches that keep running for years… I think we all have one or two of those at home, right? For developers the story isn't much different. Some of the most popular services on the web run in a kind of perpetual beta, and nothing suggests that's going to change.

Of course, every programmer will need to evaluate their creations sooner or later, and that's where Sheety comes in. Whether it's a website, an online app, or another experiment, Sheety lets you study its behavior in under a minute, and the key is a Google Sheets spreadsheet.

Sheety: How to Convert Google Sheets into an API
You must publish as .csv

In other words, Sheety's job is to convert Google spreadsheets into an API. Once your sheet is ready, publish it to the web in CSV format (comma-separated values), copy the URL Google generates into Sheety, and click to create the API.

Sheety takes advantage of Google Sheets' collaborative nature so any change made to the sheet is reflected on the API almost in real time (Google's servers can be a bit slow sometimes). Still, it's much faster than some conventional methods, and any quirk of Google Sheets becomes tolerable when all you want is to play with prototypes.

Sheety: How to Convert Google Sheets into an API
Try to use it only on things you can break as you like

Sheety's developer created this tool for all those programmers who enjoy “taking shortcuts and using questionable backends”, so beyond its usefulness, nobody should use it for critical projects (in fact, its name says it all).

Sheety isn't the only service in this particular “Google Sheets-to-API” market, but they tend to be very expensive. That's where Sheety's advantage shows: its free tier allows unlimited projects, 200 requests per month, and 100 rows per spreadsheet. Of course, if you need more you'll have to pay, but that should be enough for simple projects.

Official site: Click here

https://old.neoteo.com/como-crear-una-rueda-de-la-fortuna-con-google-sheets/