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

131–140 of 154 posts

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

#131

Post by tjchear »

fermienrico wrote: post #115
priomsrb wrote: post #113

Earlier quoted context omitted.

Ugliness aside, there are some things that don't work very well in a plain spreadsheet vs a UI. For example large paragraphs and images. Part of conveying information should be about making the information easy to digest. Sometimes a spreadsheet fits that bill. Other times a crafted UI works better.

It does if you create large cells and stick paragraphs in. Make sure the width of the cell is enough for 12-15 words. Images also work just fine. It truly boils down to "uglyness" and not functionality. "Easy to digest" is a subjective term. Excel sheets are essentially rectangular grid with borders. Grids have been used since the 60's in graphic design, primarily championed by the Swiss Grid System (Josef-muller bro…

I agree with this to some extent. The aesthetics, even if it does almost nothing for functionality, unfortunately does influence people's impression and opinion, and ultimately, their decision to open their wallet. When the SaaS world is filled with players who each bring something to the table, aesthetics sometimes becomes a tie-breaker, so to speak.

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

#132

Post by tjchear »

chris_st wrote: post #114
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…

I have a personal website backed by a Google sheets page; however, it started not handing out proper CORS headers on the request, so it no longer works for me. Have you run across this? How did you solve it? Thanks!

I have not run across this issue before. How are you accessing the sheets though? Cloud Sheets API, or the json-in-script endpoint?

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

#133

Post by thesandlord »

hogFeast wrote: post #102
thesandlord wrote: post #85

Earlier quoted context omitted.

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.

> Would you build a livelihood on that?

Yes? Google is notorious for deprecating and changing things, so I would have a backup plan but companies like Streak have built large businesses on much more restricted APIs like Gmail.

> kind of loophole

This is not a loophole, this is 2-legged Oauth. This is much safer than the typical 3-legged Oauth where the user gives blanket permission to read and write from their Google Drive. The user has to explicitly share the sheet with this service account email. Google is trying to protect people from clicking a phishing link and getting all their email and drive content stolen or hijacked.

Yes, Google can shut this down tomorrow or demand thousands of dollars to use it. It's a inherent risk building on top of someone's platform, the trade off being you get the scaffolding and user base the platform already has.

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

#134

Post by tjchear »

abhayhegde wrote: post #128

Wonderful product! I was looking to build a page on a team that I am working with, but wanted a simple integration like this. Kudos! I would like to know if you are going to add more features later. For example, informal 'About us' pages would have links to social media in their bios. So can we have more than primary and secondary buttons? Also, it would be lovely to have profile photo frame customizable. It looks st…

These are great ideas! I'll add them to SheetUI's feature roadmap. Definitely reach out to me at tjchear (twitter/linkedin/gmail) and we can talk about what you need.

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

#135

Post by theluketowers »

tjchear wrote: post #52
akdarrah wrote: post #46

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?

Note that Liquid is quite similar to Twig, which is used in quite a bit more projects than just Shopify.

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

#136

Post by mrmonkeyman »

andrei_says_ wrote: post #124
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…

Why is React needed to display static HTML?

The author needs the React-rails.

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

#137

Post by smuemd »

franciscop wrote: post #105
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 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/francis…

This looks great. Thanks for sharing.

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

#138

Post by achow »

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

Copy/Pasting my reply to the exact same comment posted elsewhere.

------------------------------------------------------

From reviews:

"..you have to pay £5,400 per year!"

"Even with the nonprofit pricing it would cost $900 per year."

"Pricing for singe user with one "app" is $60 per month. The "free" version only allows 100 "views" per month. Everytime you go to the page with the app and interface with the tools it counts as a "view". Everytime you refresh the page it is another "view"."

------------------------------------------------------

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

#140

Post by rvnx »

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 is great, it's really something that Google POs should look at
Post reply on HN