Fun idea. I learned recently that Sheets also works as a JSON service to post and get data if you have a static site and don't want to stand up a DB server.
Any resource for this you can point me to?
I used this https://googlesheetjson.herokuapp.com
Show HN: Sheet2Site – Create Websites Out of Google Sheets
41–50 of 50 posts
Re: Show HN: Sheet2Site – Create Websites Out of Google Sheets
#42Earlier quoted context omitted.
Oh! If you don't mind my asking, how do you go about selling custom domains? Or if there are resources you can point me to, that would be helpful, too.
Not sure @andreyazimov is actually selling domains, only allowing you to connect your own, right? But if you want to actually sell domains via your application I'm sure that's possible via Namecheap API or something similar.
I do not selling domains for sure, just connecting :)
Re: Show HN: Sheet2Site – Create Websites Out of Google Sheets
#43Too funny -- about a month ago I built a web site backed by a Google Sheet so that my father could easily update content. Great idea with Sheet2Site and good luck!
Thanks :)
Re: Show HN: Sheet2Site – Create Websites Out of Google Sheets
#44Reaffirming that Excel truly is the universal format for everything. Good work!
Agree! Go Excel! :)
Re: Show HN: Sheet2Site – Create Websites Out of Google Sheets
#45Your copy: They are working but I need to explain you how :) could be improved to They are working but I need to explain to you how to use it. :)
Done! Thanks!
Re: Show HN: Sheet2Site – Create Websites Out of Google Sheets
#46Re: Show HN: Sheet2Site – Create Websites Out of Google Sheets
#47Great work!
An alternative I have been using recently for some projects is Molnify [1], it has more focus on exposing calculation logic in the app created and less control over background images and layout. Takes either a Excel file or a google sheet doc as input.
Re: Show HN: Sheet2Site – Create Websites Out of Google Sheets
#48Fun idea. I learned recently that Sheets also works as a JSON service to post and get data if you have a static site and don't want to stand up a DB server.
Any resource for this you can point me to?
There's a bunch on the web actually. The gist is that you create a Google App Script linked to your Sheet and deploy it publicly, which can receive GET and POST requests and respond as you like. See:
http://chriszarate.github.io/sheetrock/
http://douglasduhaime.com/posts/crud-operations-on-static-file-sites.html
https://github.com/liddiard/google-sheet-s3
https://www.johnastewart.org/coding/twine-game-data-to-google-sheets-via-javascript/
https://medium.com/@dmccoy/how-to-submit-an-html-form-to-google-sheets-without-google-forms-b833952cc175Re: Show HN: Sheet2Site – Create Websites Out of Google Sheets
#49Can you explain the backend? When the spreadsheet is updated, is the generated website automatically updated?
It's just getting a JSON from a spreadsheet.
Re: Show HN: Sheet2Site – Create Websites Out of Google Sheets
#50Great idea! Any ideas for expansion? I imagine you could map rows/columns to a bootstrap-like grid system for more custom layouts.
Thanks) I'm thinking to add a custom script from the sheet. Like Google Analytics or chat