Google Spreadsheets

Sorry Can't find a suitable section. Had to post in Lounge

I'm looking for a tool that can pull data from daily updated Google spreadsheets and can do some statistical analysis.

Is there any tool out there that can do the above?

I need a "dashboard" to visualisethe results of statistical analysis done too all autopilot, kind a web app, but a pc software is also fine

If there are more people to se such type of data, then their would be a free one. I could suggest to you to hire someone for building tool.

Can't you analyze the data on Google spreadsheets directly?

I can manually do that, but the data is continuously updated, so have to do the analysis continuously( Can any Automation tool help with that? spreadsheets to IFTTT and so on).

I'm looking for a web app like google analytics, for analysing spreadsheet data

There are some formulas in Microsoft excel, so the page will get updated by just a click. I think it will be easier to make a script and load where you want to publish it.

You may be able to find a way to use yahoo pipes to parse your data. It's difficult say without knowing exactly how you want to manipulate the data. I can say I find pipes to quite versatile despite it's simplicity. If you add in the YQL modules you can accomplish a lot of functions that seem outside the scope of pipes at first. That said, it might be a challenge to figure out how to accomplish your specific analysis, but at least it would be free.

Alternatively I'm sure you can find much better solutions, especially if you are willing to pay.

Any other insights?