Leafcutter: Google Sheets for Grasshopper

29 members

Description

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

Comments Discussions Members

  • lv2311

    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

    Jul 25, 2014

  • machinehistories

    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 

    Feb 11, 2016

  • flux.io

    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!

    Sep 22, 2016

  • Martin Zatecka

    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

    Oct 27, 2016