Live data from Hacker News

Show HN: SheetUI – Turn Google Sheets into Web Pages

sheetui.com

51–60 of 154 posts

Re: Show HN: SheetUI – Turn Google Sheets into Web Pages

#51
post #29

Earlier quoted context omitted.

For now, yes. I'm hard at work building Google Sheets API integration so you won't have to make your sheet public.

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.

Re: Show HN: SheetUI – Turn Google Sheets into Web Pages

#52

This looks really cool! I love your quick video that shows how to use the product and build a great looking UI so quickly. I'm guessing you guys use Liquid based on the curly braces? It looks like you have a pretty nice UI for manipulating the dynamic data, but if you're interested, my product helps people write Liquid: https://www.dropkiq.com/ Let me know if you're interested. Otherwise, best of luck with your produ…

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?

Re: Show HN: SheetUI – Turn Google Sheets into Web Pages

#53
post #52

This looks really cool! I love your quick video that shows how to use the product and build a great looking UI so quickly. I'm guessing you guys use Liquid based on the curly braces? It looks like you have a pretty nice UI for manipulating the dynamic data, but if you're interested, my product helps people write Liquid: https://www.dropkiq.com/ Let me know if you're interested. Otherwise, best of luck with your produ…

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 per year.

Keep us in mind as you grow! :D

Re: Show HN: SheetUI – Turn Google Sheets into Web Pages

#55
post #43
post #19

Great idea and execution! I've been using Liftoff[1] with Airtable as a DIY solution for this and while it's been easy to set it up and deploy it on Netlify, I still had to resort to writing a custom watch for changes daemon and forking the repo for adjusting the components layout. I like that SheetUI has the things above built-in and more functionalities like adding buttons and a customisation UI. Is a custom-CSS fe…

SheetUI is built using Material UI, which I'm still getting the hang of. It certainly has support for parameterized themes. As for custom CSS, I'm going to have to look into how to do that technically while making sure there's no security implications. Thanks for showing me Liftoff! The generated websites look great. I'll see what I can learn from it.

I think just allowing a CSS textarea input that can be injected inside a HTML tag is enough. If the input is HTML escaped (replace and other dangerous characters) then nothing should escape out of that tag.

Thank you for considering this!

Re: Show HN: SheetUI – Turn Google Sheets into Web Pages

#56
post #54

Is there a tool that does the reverse? It would also be very interesting. Turn any webpage into a spreadsheet.

There was one other comment that mentioned the same thing. I'll look into this. How can I chat with you further about this? My email's tjchear at gmail if you want to reach out.

Re: Show HN: SheetUI – Turn Google Sheets into Web Pages

#58
post #40

This 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...

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 results, and I could probably have the data sorted in under 60 seconds on a column of "=B5+C5*0.5"

Re: Show HN: SheetUI – Turn Google Sheets into Web Pages

#59
post #47

Services 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…

This is an interesting use case (the delegation of subdomain). Sounds like something that can be built atop Amazon Route 53. Have you seen this need come up a lot?

I think it would be helpful for decentralizing things, ie less necessary for the web we have than the web I want.

For example I'm working on a project right now that's ideal for self-hosting, but I really want to encourage people to use their own domain names, and registering them and handling HTTPS is a rather large barrier.

Re: Show HN: SheetUI – Turn Google Sheets into Web Pages

#60

Services 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.
Post reply on HN