Ha, does this qualify as a headless cms?
Show HN: SheetUI – Turn Google Sheets into Web Pages
61–70 of 154 posts
Re: Show HN: SheetUI – Turn Google Sheets into Web Pages
#62Earlier quoted context omitted.
But presumably, that is going to cost you $15k or whatever it is now to be an approved user of Google API?
I don't think so. I just need to procure an API key and some credentials from Cloud Console to begin using Sheet API. The rest is just a lot more backend development for me.
Right, but won't you need permissions to access data in user accounts? You can only get permissions with a Google audit (which you have to pay for).
Re: Show HN: SheetUI – Turn Google Sheets into Web Pages
#63Earlier quoted context omitted.
What you just described is essentially a scraper/crawler right? Would scraping them into a sheet you own be sufficient for your use case?
Yes, but currently the process of writing a scraper for a given page is usually half an hour with beautiful soup... Or more if you have to handle multiple pages, Auth cookies that expire, and rate limits. Example usecase:. eBay search results, I want to sort by "Price plus $0.50 per mile from me", since I'm going to have to drive my van to pick up the item. That would be super easy with a spreadsheet of the search re…
It's the complete opposite of what SheetUI hopes to achieve, but this is such an interesting use case I'll think more about it :) I can see how there might be a legitimately strong demand for it. Feel free to connect with me (tjchear on twitter/linkedin/gmail) to discuss this further.
Re: Show HN: SheetUI – Turn Google Sheets into Web Pages
#64Services like this need an easy way to allow people to use their own domain names, and we need to lower the barrier of entry to individuals registering domains and setting up HTTPS. Imagine a SaaS that sells domains, then provides and easy (and open) API for delegating control over subdomains using OAuth2. So I sign up for sheetui, and during the registration process they redirect me to a namecheap.com (where andersp…
Hahaha oh wow, I had a design document for this last year, down to the details. OAuth2 doesn't quite fit the bill without a little modification, unfortunately.
Would love to discuss it. I think this could be a solid business. I have little interest in building it myself, but may have to in order to make my other projects easier to self-host. I keep bringing it up hoping to find out it already exists.
What issues did you run into with OAuth2? Are you open to sharing your design doc?
Re: Show HN: SheetUI – Turn Google Sheets into Web Pages
#65Is there a tool that does the reverse? It would also be very interesting. Turn any webpage into a spreadsheet.
Sheets itself does a remarkable job of pasting HTML into a sheet. I just tried it with English Wikipedia's list of the world's largest cities and it worked perfectly, except the column of photographs is blank instead, which is a reasonable choice.
Re: Show HN: SheetUI – Turn Google Sheets into Web Pages
#66This product is great... But it makes me feel sad to think about all the webpages that hide a small amount of tabular data in an oversized web UI. I want the reverse of this service - I just want the raw data from any web page in a spreadsheet ready to filter and sort and define new columns as I please...
This is one of the reasons I really like that some webpages have taken to using JSON REST endpoints to provide the data for their (usually React-based) webpage. It makes it fantastically easy to circumvent all the complicated stuff and just directly access the data.
It's somewhat of a shame that HTML never quite managed to split data from representation. It managed to separate content and styling, but the content is still treated as some kind of text document, not a textual representation of some data.
Re: Show HN: SheetUI – Turn Google Sheets into Web Pages
#67So from talking to people I see a need to quickly turn a spreadsheet of information into something visually pleasing. SheetUI is my response to that need. You give it a Google Sheet URL, pick a template, and tap in the columns where you want them to show up. In return you get a visually pleasing and responsive web page that you can embed on your site, or link to in your newsletter or chat with a client. Created with…
Massive kudos to the effort. The Gsheets API is notoriously hard to understand and work with. I see that you have put it to good use! Great work!
Re: Show HN: SheetUI – Turn Google Sheets into Web Pages
#68Earlier quoted context omitted.
I implemented the parsing part! This is the first I've heard of Liquid though. When SheetUI has gained sufficient traction that people need advanced Liquid support, I'll look to your product for that :) There is no price quoted on your page though; do you mind telling us here a ballpark figure?
Awesome! Yea, Liquid is a pretty robust language built by Shopify that is implemented in most languages to help with this exact problem. It might come in handy some day as you scale your app. :) For Dropkiq, your app looks simple enough (for the Liquid part) that you could likely use our free version. For apps that have complex Liquid, we have our Pro version, which I'm currently offering beta pricing at around 1K pe…
Got it akdarrah! Thanks for letting me know about Liquid and your wonderful product!
Re: Show HN: SheetUI – Turn Google Sheets into Web Pages
#69This is great, congrats on the launch! I've noticed a lot of products recently that attempt to solve this.
Re: Show HN: SheetUI – Turn Google Sheets into Web Pages
#70Anyone have a end-result demo page that I can look at?
I would like to see what it looks like.