Grasshopper

algorithmic modeling for Rhino

Leafcutter: Google Sheets for Grasshopper

Information

Leafcutter: Google Sheets for Grasshopper

Leafcutter is an open source project to connect Grasshopper to Google Sheets, with proper OAuth 2.0 Authentication.

Leafcutter exposes the following components:

  • Google Authenticator. Creates a session token for connecting to your Google account.
  • Spreadsheet List.  Fetches a list of spreadsheets in your account.
  • Read From Spreadsheet.  Read specified cells from the specified sheet and worksheet.
  • Write To Spreadsheet.  Write to specified cells and worksheet.
  • Create Spreadsheet.  Self-explanatory.
  • Find Cell Address.  Query the spreadsheet for an existing value and return the cell address.

Demo video:

https://vimeo.com/fluxio/leafcutter

Leafcutter can be downloaded here:

http://www.food4rhino.com/project/leafcutter

This project is open source and released under the MIT License.  Visit the Github repo here:

https://github.com/fluxio/leafcutter.git

Website: http://www.food4rhino.com/project/leafcutter
Members: 19
Latest Activity: Jun 11

Discussion Forum

Find Multiple Cells with Same Content

Hey guys,I'm finding some issues with the "find cell" component though.Is it possible to retrieve all the cell addresses that have the same content?as you can see from the screenshots I'd like to…Continue

Tags: leafcutter, findcell

Started by lv2311 Jul 25, 2014.

Comment Wall

Comment

You need to be a member of Leafcutter: Google Sheets for Grasshopper to add comments!

Comment by Martin Zatecka on October 27, 2016 at 10:16am

Hey everyone,
I have a trouble with creating a new spreadsheet. Do you know way how to solve it? I know about flux, but i prefer leafcutter for my solution.
thanks,
Martin

Comment by flux.io on September 22, 2016 at 1:40am

Leafcutter has now formally been superceded by the Flux plugin for Google Sheets - please follow the link to install the Google Sheets plugin https://chrome.google.com/webstore/detail/flux-beta/jligldjpandgfdi... and visit flux.io/downloads for the Grasshopper installer. Enjoy!

Comment by machinehistories on February 11, 2016 at 10:25pm

I am having trouble getting the write to spreadsheet component working. I get the following error:

1. Solution exception:Execution of request failed: https://docs.google.com/feeds/default/private/full?category=spreads...

The read component works just fine however. thanks, jason 

Comment by lv2311 on July 25, 2014 at 3:59pm

Hey guys,

I really like this component. Great work!

I'm finding some issues with the "find cell" component though.

Is it possible to retrieve all the cell addresses that have the same content?

Inline image 1

Inline image 1

as you can see from the screenshots I'd like to have also the rest cell addresses that contain the item "a" and not just the first  one.

Any thought?!

thank

 

Members (19)

 
 
 

About

Translate

Search

Photos

  • Add Photos
  • View All

© 2017   Created by Scott Davidson.   Powered by

Badges  |  Report an Issue  |  Terms of Service