Google Drive (Docs) spreadsheet input possible?

Replies to This Discussion

Permalink Reply by djordje on October 23, 2012 at 12:22pm

The following process is how your problem can be solved in Microsoft Office. I assume that somewhat similar method can be applied to GoogleDocs too?!

Maybe I am wrong, but maybe this will help you.

Export your data from Grasshopper using some spreadsheet format. For example .csv, .dat or .log

You can do this by using the regular Panel from Grasshopper, then by right clicking on it, and "Stream Content". Choose the appropriate file format, let's say above mentioned .csv and type the name of the of the file.

Run your GoogleDocs, and import that .csv file into it's tables.

Whenever you change your data in Grasshopper, get back to your GoogleDocs and refresh that page. It should refresh your data gained from .csv file and there for Grasshopper.

Permalink Reply by Andrei Raducanu on October 23, 2012 at 1:11pm

Thanks, but i'm actually interested in the other way around, processing in Grasshopper data from Google Drive..

Permalink Reply by Patrick DONBECK on January 20, 2013 at 1:52pm

Did you hear/learn anything about this problem yet. Let me know.

Thanks

P

Permalink Reply by Matt McDonnell on January 20, 2013 at 4:39pm

Andrei,

You could use the Google API to access this via a custom scripted component. I haven't played around with this too much as yet but when I have the time (one day in a far of distant magical land) I'd be interested to see how this would work. A quick search found some links that may get you started. I don't know how adapt you are at writing code?

Google data access - https://developers.google.com/google-apps/spreadsheets/

Demonstration of access via html query - http://www.youtube.com/watch?v=3IbfHL5RmRQ

Importing gdata lib into python script - https://developers.google.com/gdata/articles/python_client_lib

Good luck sounds like a great way to centralise live data streams.

Regards,

/m

Permalink Reply by Andrei Raducanu on January 21, 2013 at 9:01am

Thanks a lot for the info!

I did some coding (in MEL mainly), but didn't go too deep, so i'm not exactly like a fish in water..

I will try whay You suggested if i will need this more than i currently do (i just wanted to make some simple operations that google drive unfortunately isn't able to do, but are manageable by hand as well..)

Thanks again!

Permalink Reply by Marc Syp on August 1, 2013 at 3:46pm

Has anyone coded this up yet?  I'm trying to get away from XLS-based spreadsheets and it would be great to link directly to Google Drive...

Marc

Permalink Reply by Jonatan Schumacher on February 24, 2014 at 8:24pm

Hi Andrei and all, 

we just released a new version of the TT Toolbox plugin that features interoperability with Google Spreadsheets. I hope you like it!

Permalink Reply by Andrei Raducanu on February 25, 2014 at 2:45am

wooohooo, can't believe it!

Permalink Reply by yj on March 2, 2014 at 10:15am

thank you! just in time