Live data from Hacker News

Show HN: SheetUI – Turn Google Sheets into Web Pages

sheetui.com

101–110 of 154 posts

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

#101
post #87

Earlier quoted context omitted.

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

You might be mixing up access to GMail APIs with general access to Google APIs? Reading people's emails comes with tons of red tape, other things not so much.

I am not - https://support.google.com/cloud/answer/9110914?hl=en - after Facebook, everyone is tightening up these permissions.

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

#102

Earlier quoted context omitted.

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

No, the easiest way is to use a service account and share the sheet with the service account. No need for user OAuth at all. https://github.com/juampynr/google-spreadsheet-reader

Would you build a livelihood on that? I have heard of that but it sounds like the kind of loophole that got the industry into a situation where you needed to pay tens of thousands to use an API.

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

#103
post #87

Earlier quoted context omitted.

You might be mixing up access to GMail APIs with general access to Google APIs? Reading people's emails comes with tons of red tape, other things not so much.

I am not - https://support.google.com/cloud/answer/9110914?hl=en - after Facebook, everyone is tightening up these permissions.

[deleted]

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

#104
post #50

Earlier quoted context omitted.

Nice! I would recommend making the link clearer: unless I knew it was there, I would have missed it.

Got it! I bolded the text. Also added one for Article Curation. Thank you for your advice and suggestion!

I missed it even after your changes until I read this thread. Maybe modifying the CSS is too much of an ask, but I personally think the link color should be a bit differentiated, the link should be underlined, or the link should be moved since I didn't expect a link there.

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

#105
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 great! I made a while back a library[1] to do this, but of course you still have to code on top of it (which is what I wanted). Your project makes it very easy for everyone to get started and not only those who know how to code, props on launching it.

Are you using Node.js? Would love some feedback on my lib since it seems we are doing the same thing for different user types!

[1] https://github.com/franciscop/drive-db

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

#106
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…

Do you have demos of current sites using this?

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

#107
post #87

Earlier quoted context omitted.

You might be mixing up access to GMail APIs with general access to Google APIs? Reading people's emails comes with tons of red tape, other things not so much.

I am not - https://support.google.com/cloud/answer/9110914?hl=en - after Facebook, everyone is tightening up these permissions.

Okay, it's wider than just GMail, I had missed the addition of Drive, but according to that link an audit is just required for

> Drive - Any Drive API scope that permits an application to read, modify, or manage the content or metadata of a user’s Drive files, without the user individually granting file-by-file access.

I could be wrong, but to me this suggests you can use the Sheets API against a user-specified document without it. It has it's own namespace of scopes that's not under drive.X

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

#108

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…

Rather than leaving all this to the many registrars, what about a SaaS (let’s call it usemycustomdomain) that allows you to point a CNAME record for a subdomain to it, then when you sign up to an app that supports custom domains, you can oAuth2 to usemycustomdomain. Then usemycustomdomain can do the SSL management and termination and proxy the traffic to different SaaS products. It could even support custom URLs on a domain.

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

#109

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…

Rather than leaving all this to the many registrars, what about a SaaS (let’s call it usemycustomdomain) that allows you to point a CNAME record for a subdomain to it, then when you sign up to an app that supports custom domains, you can oAuth2 to usemycustomdomain. Then usemycustomdomain can do the SSL management and termination and proxy the traffic to different SaaS products. It could even support custom URLs on a…

That would make it more flexible, but in my mind the whole point of this thing existing is to take the pain out of having a custom domain, and making the process accessible to more people. Part of that would include handling registration and hiding all the DNS nonsense unless you really want to fiddle with it.

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

#110
Crazy I know: why not just link them to the sheet? If the goal is for one person to convey information to another, why do we need to “decorate” it?

I kind of like some of the Brutalism takes on web design. Just throw away all decoration and live with the ugly world, “ugly” being subjective. I think excel sheets are actually quite beautiful.

Challenge the status quo :-) at the expense of coolness, dignity and comfort.

Post reply on HN