Home

Awesome

GDataDB

GDataDB is a database-like interface to Google Spreadsheets for .Net.<br/> It models spreadsheets as databases, worksheets as database tables, and rows as records.

NuGet package here.

A few articles documenting it:

Google has changed the authentication scheme since those articles were written. Now it requires OAuth2. <br/> To set this up visit http://console.developers.google.com , create a new project, enable the Drive API, create a new client ID of type "service account" and download the P12 key. Use the service account email address and the P12 key as shown in this example .<br/> If you want to access any documents from your personal gmail account, share them (edit permissions) with the service account email address (the one that looks like "987191231-asdfkasjdjfk@developer.gserviceaccount.com") and make sure that they're in the root folder of Drive.

Original idea for GDataDB borrowed from https://github.com/google/gdata-python-client/blob/master/src/gdata/spreadsheet/text_db.py

Please donate