Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: SheetUI – Turn Google Sheets into Web Pages

sheetui.com

Post reply on HN
Print view View original

91–100 of 154 posts

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

#91

Post by anderspitman »

vertex-four wrote: post #76
anderspitman wrote: post #64

Earlier quoted context omitted.

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?

If you want to contact me, I'm shell@alterednarrative.net on email and XMPP. I'll try and find whether I still have the design notes, but doubt it; I've been through a couple of laptops since and lost a lot. One of my goals was that the flow could start from a service provider - you type in the domain name you want the service to be bound to on the service provider's website, and it goes from there. If you were to us…

I'll shoot you an email, and we can talk more if you do end up working on this.

I'm not a big fan of pre-registered clients in the first place. Ideally any client should be able to talk to any OAuth2 server that speaks the same profile, ie endpoints and scopes. Aaron Parecki describes a way to allow "anonymous" clients here[0]. As I understand that's how IndieAuth is implemented. But I'm still relatively new to OAuth, and I don't doubt there could be subtle security issues. Do you have any thoughts on that?

[0]: https://aaronparecki.com/2018/07/07/7/oauth-for-the-open-web

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

#93

Post by julienb_sea »

In college I would make primitive webpages for my college newspaper to use for live feeds and such content publishing. I built something like this (although vastly less polished) - the writers could just fill in details in a sheet & add image URLs, and my static page could retrieve the spreadsheet contents via API and essentially have a super cheap data backend with a super fancy collaborative editor. Fun times.

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

#94

Post by swyx »

anderspitman wrote: post #64
vertex-four wrote: post #60

Earlier quoted context omitted.

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?

same, i think this is a great idea and dont want to build it myself. hope you guys figure it out!

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

#95

Post by uptown »

I used to drive a restaurant website's menu using a shared Google sheet. It was an easy way for multiple people to have access to update the content. I'd cached the recent versions in-case anyone made a breaking formatting change or Google was unavailable. Worked very well for our use-case.

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

#96

Post by czzarr »

eyelidlessness wrote: post #22
tjchear wrote: post #2

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

This looks really cool. I have a potential use case I'd consider using this for, but I don't want to make the sheet (or resulting page) public. Have you considered support for OAuth to retrieve private sheets?

Try Awesome Table, it's been here for years for exactly that purpose and is one of the very top G Suite Marketplace apps: https://gsuite.google.com/marketplace/app/awesome_table/5608...

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

#98

Post by tjchear »

czzarr wrote: post #97

So why not use Awesome Table? one of the very top G Suite Marketplace apps: https://gsuite.google.com/marketplace/app/awesome_table/5608...

Never heard of it, but it looks really well done! It also mirrors Google Sheet's UI closely for easier onboarding. I guess at this point you can say SheetUI is a pale copy of it and I'd have nothing to counter. That said, their margin is my opportunity, and I can definitely find opportunities amongst users whom AwesomeTable has not fully satisfied. Thanks for bringing this to my attention - I'll learn from them and improve my craft.

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

#99

Post by tjchear »

uptown wrote: post #95

I used to drive a restaurant website's menu using a shared Google sheet. It was an easy way for multiple people to have access to update the content. I'd cached the recent versions in-case anyone made a breaking formatting change or Google was unavailable. Worked very well for our use-case.

That's a good point. I should cache the generated sites or the sheet's data in case the sheet server goes down.

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

#100

Post by tjchear »

julienb_sea wrote: post #93

In college I would make primitive webpages for my college newspaper to use for live feeds and such content publishing. I built something like this (although vastly less polished) - the writers could just fill in details in a sheet & add image URLs, and my static page could retrieve the spreadsheet contents via API and essentially have a super cheap data backend with a super fancy collaborative editor. Fun times.

That is the perfect use case! Sheets already got a lot of features baked into it, no point re-inventing.
Post reply on HN