5 ms·

Shameless plug incoming... I made the equivalent but for APIs using Google Sheets :) https://sheet2api.com/ https://sheet2api.com/

metrix 6y ago
i'm using Google Sheets for a Coronavirus Tracker http://amarillo.land/coronavirus.html http://amarillo.land/coronavirus.html but i'm not enthused with the performance. This looks very interesting!
- czzarr 6y ago
  Depending on what you're trying to achieve, you could try Awesome Table (I'm the product manager). https://gsuite.google.com/marketplace/app/awesome_table/56088344336 https://gsuite.google.com/marketplace/app/awesome_table/5608...
- richardARPANET 6y ago
  Happy to help, feel free to email me any questions.
fireattack 6y ago
Want something like this for a long time. The 50 row limit of the free tier doesn't fit my hobby project unfortunately, but it's glad to see someone developed such thing!
- ehsankia 6y ago
  Yeah, this is a great service but the pricing doesn't make sense (even after the free tier). 10$ a month (!!!) and it still wouldn't fit my use case with only 1500 rows. The convenience is nice but considering Google/Microsoft is paying for most of the hosting, cell computation and so on, not sure why a wrapper around an API is so expensive.
  - wic8 6y ago
    You can make your own with Appscripts like this Show HN[0]. It's script here[1] also accept POST request. 0 [https://news.ycombinator.com/item?id=23054316 https://news.ycombinator.com/item?id=23054316] 1 [https://github.com/Glowbom/mobile-orders/blob/master/backend/mobileorders.gs https://github.com/Glowbom/mobile-orders/blob/master/backend...]
  - richardARPANET 6y ago
    Time is money and this saves a tonne of it. You're free to code everything yourself and save that tiny amount of money of course if you like. Different people have different priorities.
- superasn 6y ago
  You can try this site: https://sheety.co https://sheety.co (it's not mine just found it on PH long time ago and the name stuck in my head)
hckr_news 6y ago
Saved :)
onesmalluser 6y ago
You can get a Google Sheet in JSON format just by adding alt=json to the URL. What do you do differently?
- kabacha 6y ago
  How do you do it? Seems like this feature has been shutdown?
  - hanniabu 6y ago
    Subscribed comment because also curious
  - theptrk 6y ago
    https://www.freecodecamp.org/news/cjn-google-sheets-as-json-endpoint/ https://www.freecodecamp.org/news/cjn-google-sheets-as-json-... The output needs some parsing but I tried this and it works: Sheet:https://docs.google.com/spreadsheets/d/1Ze0mrYyT98Z3DupKiynCIXIy0FCLWgDk7CdzY_A3Y7U/edit#gid=0 https://docs.google.com/spreadsheets/d/1Ze0mrYyT98Z3DupKiynC... JSON:https://spreadsheets.google.com/feeds/cells/1Ze0mrYyT98Z3DupKiynCIXIy0FCLWgDk7CdzY_A3Y7U/1/public/full?alt=json https://spreadsheets.google.com/feeds/cells/1Ze0mrYyT98Z3Dup...
- richardARPANET 6y ago
  Unfortunately, you cannot. But don't worry we have sheet2api now for this :)

metrix 6y ago

i'm using Google Sheets for a Coronavirus Tracker http://amarillo.land/coronavirus.html http://amarillo.land/coronavirus.html but i'm not enthused with the performance. This looks very interesting!

czzarr 6y ago
Depending on what you're trying to achieve, you could try Awesome Table (I'm the product manager). https://gsuite.google.com/marketplace/app/awesome_table/56088344336 https://gsuite.google.com/marketplace/app/awesome_table/5608...
richardARPANET 6y ago
Happy to help, feel free to email me any questions.

fireattack 6y ago

Want something like this for a long time. The 50 row limit of the free tier doesn't fit my hobby project unfortunately, but it's glad to see someone developed such thing!

ehsankia 6y ago
Yeah, this is a great service but the pricing doesn't make sense (even after the free tier). 10$ a month (!!!) and it still wouldn't fit my use case with only 1500 rows. The convenience is nice but considering Google/Microsoft is paying for most of the hosting, cell computation and so on, not sure why a wrapper around an API is so expensive.
- wic8 6y ago
  You can make your own with Appscripts like this Show HN[0]. It's script here[1] also accept POST request. 0 [https://news.ycombinator.com/item?id=23054316 https://news.ycombinator.com/item?id=23054316] 1 [https://github.com/Glowbom/mobile-orders/blob/master/backend/mobileorders.gs https://github.com/Glowbom/mobile-orders/blob/master/backend...]
- richardARPANET 6y ago
  Time is money and this saves a tonne of it. You're free to code everything yourself and save that tiny amount of money of course if you like. Different people have different priorities.
superasn 6y ago
You can try this site: https://sheety.co https://sheety.co (it's not mine just found it on PH long time ago and the name stuck in my head)

hckr_news 6y ago

Saved :)

onesmalluser 6y ago

You can get a Google Sheet in JSON format just by adding alt=json to the URL. What do you do differently?

kabacha 6y ago
How do you do it? Seems like this feature has been shutdown?
- hanniabu 6y ago
  Subscribed comment because also curious
- theptrk 6y ago
  https://www.freecodecamp.org/news/cjn-google-sheets-as-json-endpoint/ https://www.freecodecamp.org/news/cjn-google-sheets-as-json-... The output needs some parsing but I tried this and it works: Sheet:https://docs.google.com/spreadsheets/d/1Ze0mrYyT98Z3DupKiynCIXIy0FCLWgDk7CdzY_A3Y7U/edit#gid=0 https://docs.google.com/spreadsheets/d/1Ze0mrYyT98Z3DupKiynC... JSON:https://spreadsheets.google.com/feeds/cells/1Ze0mrYyT98Z3DupKiynCIXIy0FCLWgDk7CdzY_A3Y7U/1/public/full?alt=json https://spreadsheets.google.com/feeds/cells/1Ze0mrYyT98Z3Dup...
richardARPANET 6y ago
Unfortunately, you cannot. But don't worry we have sheet2api now for this :)