Show HN: SheetUI – Turn Google Sheets into Web Pages • Hacker News Board

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

#21

Post by [deleted] » Tue, Jul 07, 2020, 5:49 PM UTC

[deleted]

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

#22

Post by eyelidlessness » Tue, Jul 07, 2020, 5:51 PM UTC

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?

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

#23

Post by hogFeast » Tue, Jul 07, 2020, 5:51 PM UTC

Does this only work with public sheets?

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

#24

Post by adamfeldman » Tue, Jul 07, 2020, 5:53 PM UTC

It'd be interesting to use this alongside the Google Sheets connector [1] for BigQuery

[1]: https://cloud.google.com/blog/products/g-suite/connecting-bi...

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

#25

Post by zenojevski » Tue, Jul 07, 2020, 5:54 PM UTC

Not quite the same, but...

Turn your Google Sheets into a beautiful Gopherhole :)

https://github.com/zenoamaro/gophersheet

A much closer transformation.

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

#26

Post by alpb » Tue, Jul 07, 2020, 5:54 PM UTC

I also recently built a URL shortener on top of Sheets API (https://github.com/ahmetb/sheets-url-shortener) and I don't have to worry about setting up a database or other form of storage. All I needed to do was set up credentials, and it's good to go.

A lot of folks don't realize Google Sheets is like a free small database with a decent API. :)

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

#27

Post by kpennell » Tue, Jul 07, 2020, 5:56 PM UTC

How to use google sheets + react together: https://www.developintelligence.com/blog/2018/08/the-simple-...

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

#28

Post by tjchear » Tue, Jul 07, 2020, 5:56 PM UTC

zenojevski wrote: post #25

Not quite the same, but... Turn your Google Sheets into a beautiful Gopherhole :) https://github.com/zenoamaro/gophersheet A much closer transformation.

Ooh. Can you explain what a Gopherhole is?

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

#29

Post by tjchear » Tue, Jul 07, 2020, 5:57 PM UTC

hogFeast wrote: post #23

Does this only work with public sheets?

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

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

#30

Post by tjchear » Tue, Jul 07, 2020, 5:58 PM UTC

adamfeldman wrote: post #24

It'd be interesting to use this alongside the Google Sheets connector [1] for BigQuery [1]: https://cloud.google.com/blog/products/g-suite/connecting-bi...

I can see a need for this. I'll look into it!