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

Rows.com – Spreadsheet that supports external API integration and collaboration

rows.com

Post reply on HN
Print view View original

11–20 of 80 posts

Re: Rows.com – Spreadsheet that supports external API integration and collaboration

#11

Post by raihansaputra »

nateguchi wrote: post #9

If you haven't looked into it yet - Google Apps Script [0] is an incredibly powerful system when combined with Google Sheets. You can integrate lots of business processes and external systems (rest,soap,databases etc) together and integrate with classic spreadsheet functionality, we use it a lot in our business! [0] https://developers.google.com/apps-script

Is there a solution to version control/deterministically see/deploy active scripts? How do you manage all the scripts? I've used it to compile/summarize spreadsheets and serve as a simple endpoint (testing webhooks), but not much more.

Re: Rows.com – Spreadsheet that supports external API integration and collaboration

#12

Post by jcun4128 »

nateguchi wrote: post #9

If you haven't looked into it yet - Google Apps Script [0] is an incredibly powerful system when combined with Google Sheets. You can integrate lots of business processes and external systems (rest,soap,databases etc) together and integrate with classic spreadsheet functionality, we use it a lot in our business! [0] https://developers.google.com/apps-script

Yeah I made a UPS zip-weight lookup with GS/GAS before was pretty cool. Alternative is to use Google Drive apparently/more legit with user auth.

Re: Rows.com – Spreadsheet that supports external API integration and collaboration

#13

Post by logicuce »

raihansaputra wrote: post #11
nateguchi wrote: post #9

If you haven't looked into it yet - Google Apps Script [0] is an incredibly powerful system when combined with Google Sheets. You can integrate lots of business processes and external systems (rest,soap,databases etc) together and integrate with classic spreadsheet functionality, we use it a lot in our business! [0] https://developers.google.com/apps-script

Is there a solution to version control/deterministically see/deploy active scripts? How do you manage all the scripts? I've used it to compile/summarize spreadsheets and serve as a simple endpoint (testing webhooks), but not much more.

You should look at clasp by Google https://github.com/google/clasp

Have used it in past to do exactly what you asked for.

Re: Rows.com – Spreadsheet that supports external API integration and collaboration

#14

Post by thenaturalist »

Compliments to see this thrive since 2016 with that large of a team! I had to laugh at the Berlin (ex) Rocket company logos; this age old Excel style data formatting which looks nice and custom at first glance brings back memories of inevitably ending up in swamps of versions, custom tweaks and data inaccuracies. Arguably, most of these problems can be well mitigated by a cloud hosted solution like yours!

But the audience being non-tech people, the look is pretty fantastic.

From a technical perspective: Care to share how you do data integration (batch/ stream/ mix? All hosted hyperscaler or something like Airbyte)? How do you address what I would think are dynamic load peaks during business days?

Re: Rows.com – Spreadsheet that supports external API integration and collaboration

#15

Post by vatican_banker »

dagurp wrote: post #8
vatican_banker wrote: post #6

The real power of this product is as a replacement of BI/Visualization tools. Imagine being able to connect Rows to a database and create "governed" sheets that look/work like dashboards with charts, tables, filters, etc. It would be a killer product because most users are familiar with spreadsheets already. Many users end-up copying data from dashboards into spreadsheets (gsheet, excel, etc) so why not skipping the…

You mean like https://grid.is/ ?

Haven't heard from them before

Re: Rows.com – Spreadsheet that supports external API integration and collaboration

#16

Post by kishansh »

vatican_banker wrote: post #6

The real power of this product is as a replacement of BI/Visualization tools. Imagine being able to connect Rows to a database and create "governed" sheets that look/work like dashboards with charts, tables, filters, etc. It would be a killer product because most users are familiar with spreadsheets already. Many users end-up copying data from dashboards into spreadsheets (gsheet, excel, etc) so why not skipping the…

Its done already

http://nocodb.com/

This is fully open source

Re: Rows.com – Spreadsheet that supports external API integration and collaboration

#17

Post by vatican_banker »

vidar wrote: post #7
vatican_banker wrote: post #6

The real power of this product is as a replacement of BI/Visualization tools. Imagine being able to connect Rows to a database and create "governed" sheets that look/work like dashboards with charts, tables, filters, etc. It would be a killer product because most users are familiar with spreadsheets already. Many users end-up copying data from dashboards into spreadsheets (gsheet, excel, etc) so why not skipping the…

Check out https://grid.is

grid.is looks more like a shiny app on steroids while Rows feel more like a hardcore spreadsheet. That being said, I haven't tried any of these.

Re: Rows.com – Spreadsheet that supports external API integration and collaboration

#18

Post by vatican_banker »

kishansh wrote: post #16
vatican_banker wrote: post #6

The real power of this product is as a replacement of BI/Visualization tools. Imagine being able to connect Rows to a database and create "governed" sheets that look/work like dashboards with charts, tables, filters, etc. It would be a killer product because most users are familiar with spreadsheets already. Many users end-up copying data from dashboards into spreadsheets (gsheet, excel, etc) so why not skipping the…

Its done already http://nocodb.com/ This is fully open source

Interesting... it doesn't seem to allow putting charts next to the spreadsheet though

Re: Rows.com – Spreadsheet that supports external API integration and collaboration

#19

Post by henriquecruz »

vatican_banker wrote: post #6

The real power of this product is as a replacement of BI/Visualization tools. Imagine being able to connect Rows to a database and create "governed" sheets that look/work like dashboards with charts, tables, filters, etc. It would be a killer product because most users are familiar with spreadsheets already. Many users end-up copying data from dashboards into spreadsheets (gsheet, excel, etc) so why not skipping the…

thank you! Yes, our goals is really to make a better spreadsheet - but simpler to use, integrated with the tools people use everyday, and 10x better to share.

Re: Rows.com – Spreadsheet that supports external API integration and collaboration

#20

Post by TheCowboy »

vatican_banker wrote: post #6

The real power of this product is as a replacement of BI/Visualization tools. Imagine being able to connect Rows to a database and create "governed" sheets that look/work like dashboards with charts, tables, filters, etc. It would be a killer product because most users are familiar with spreadsheets already. Many users end-up copying data from dashboards into spreadsheets (gsheet, excel, etc) so why not skipping the…

FileMaker is one product that does these things. It kind of languished while it was owned by Apple, and made some poor decisions. It does seem to have made a change for a better direction and I could see it making a comeback, but entry-level pricing is needed.
Post reply on HN