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