Leafcutter: Google Sheets for Grasshopper

Information

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: 29
Latest Activity: Sep 20, 2023

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.

View All

Comment Wall

Comment

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

Comment by Remy Konings on September 9, 2020 at 2:19am: Would love to get it working again too. I believe flux.io doesn't exist anymore. Perhaps someone else can make it work again as it is on GitHub.

I'm having the same issue as Vlad Buga.

Comment by Vlad Buga on February 4, 2020 at 6:04am: Hi,

I am having troubles with the Plug-in..

When I click on authenticate now and it transfers me to Google Chrome there appears the error:

"Error: deleted_client

The OAuth client was deleted."

What exactly do I need to do? I tried rebuilding the plug-in in Visual studio.. but there were problems regarding the NET.Framework (it changed from 4.0 to 4.5).. and since I have little experience coding, I was hoping someone here could maybe help me out..

Or is there any other plug-in to write into Google sheets directly?

Thanks in advance!

Comment by Idil Gumruk on May 3, 2018 at 1:00pm: Hello,

I am having some issues with authetication. When I hit authenticate now it does not open a new tab where I can login my information. I believe I may have done something wrong when downloading but I am not able to figure it out. Thank you

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?

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